snowflake.core.event_table.EventTableResource

class snowflake.core.event_table.EventTableResource(name: str, collection: EventTableCollection)

Bases: SchemaObjectReferenceMixin[EventTableCollection]

Represents a reference to a Snowflake event table.

With this event table reference, you can create, update, and fetch information about event tables, as well as perform certain actions on them.

Attributes

database
fully_qualified_name
root

Methods

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

Drop this event table.

Parameters:

if_exists (bool, optional) – Check the existance of event_table before drop. The default value is None, which is equivalent to False.

Examples

Deleting this event table using its reference:

>>> event_table_reference.drop()
Copy

Deleting this event table if it exists:

>>> event_table_reference.drop(if_exists = True)
Copy
fetch() → EventTable

Fetch the details of an event table.

Examples

Fetching an event table reference to print its time of creation:

>>> print(event_table_reference.fetch().created_on)
Copy
rename(target_name: str, if_exists: bool | None = None) → None

Rename this event table.

Parameters:

  • target_name (str) – The new name of the event table

  • if_exists (bool, optional) – Check the existence of event table before rename

Examples

Renaming this event table using its reference:

>>> event_table_reference.rename("my_other_event_table")
Copy

Renaming this event table if it exists:

>>> event_table_reference.rename("my_other_event_table", if_exists = True)
Copy
Language: English