snowflake.core.view.ViewResource¶

class snowflake.core.view.ViewResource(name: Annotated[str, Strict(strict=True)], collection: ViewCollection)¶

Bases: SchemaObjectReferenceMixin[ViewCollection]

Represents a reference to a Snowflake view.

With this view reference, you can drop and fetch information about views.

Attributes

database¶

fully_qualified_name¶

root¶

Methods

drop(if_exists: bool | None = None) → None¶

Drop this view.

Parameters:

if_exists (bool, optional) – Check the existence of this view before dropping it. Default is None, which is equivalent to False.

Examples

Deleting a view using its reference:

>>> view_reference.drop()

Copy

Deleting a view using its reference if it exists:

>>> view_reference.drop(if_exists = True)

Copy

fetch() → View¶

Fetch the details of a view.

Examples

Fetching a reference to a view to print its name and query properties:

>>> my_view = view_reference.fetch()
>>> print(my_view.name, my_view.query)

Copy