snowflake.core.view.View | Snowflake Documentation (original) (raw)

class snowflake.core.view.View(*, name: Annotated[str, Strict(strict=True)], secure: Annotated[bool, Strict(strict=True)] | None = None, kind: Annotated[str, Strict(strict=True)] | None = None, recursive: Annotated[bool, Strict(strict=True)] | None = None, columns: List[ViewColumn], comment: Annotated[str, Strict(strict=True)] | None = None, query: Annotated[str, Strict(strict=True)], created_on: datetime | None = None, database_name: Annotated[str, Strict(strict=True)] | None = None, schema_name: Annotated[str, Strict(strict=True)] | None = None, owner: Annotated[str, Strict(strict=True)] | None = None, owner_role_type: Annotated[str, Strict(strict=True)] | None = None)¶

Bases: BaseModel

A model object representing the View resource.

Constructs an object of type View with the provided properties.

Parameters:

• name (str) – Name of the view
• columns (List _[_ViewColumn]) – The columns of the view
• query (str) – Query used to create the view
• secure (bool , optional) – Whether or not this view is secure
• kind (str , optional) – Kind of the view, permanent (default) or temporary
• recursive (bool , optional) – Whether or not this view can refer to itself using recursive syntax withot requiring a CTE (common table expression)
• comment (str , optional) – user comment associated to an object in the dictionary
• created_on (datetime , optional) – Date and time when the view was created.
• database_name (str , optional) – Database in which the view is stored
• schema_name (str , optional) – Schema in which the view is stored
• owner (str , optional) – Role that owns the view
• owner_role_type (str , optional) – The type of role that owns the view

Create a new model by parsing and validating input data from keyword arguments.

Raises [ValidationError][pydantic_core.ValidationError] if the input data cannot be validated to form a valid model.

self is explicitly positional-only to allow self as a field name.

Methods

classmethod from_dict(obj: dict) → View¶

Create an instance of View from a dict.

classmethod from_json(json_str: str) → View¶

Create an instance of View from a JSON string.

to_dict(hide_readonly_properties: bool = False) → dict[str, Any]¶

Returns the dictionary representation of the model using alias.

to_dict_without_readonly_properties() → dict[str, Any]¶

Return the dictionary representation of the model without readonly properties.

to_json() → str¶

Returns the JSON representation of the model using alias.

to_str() → str¶

Returns the string representation of the model using alias.