snowflake.core.alert.AlertResource¶

class snowflake.core.alert.AlertResource(name: Annotated[str, Strict(strict=True)], collection: AlertCollection)¶

Bases: SchemaObjectReferenceMixin[AlertCollection]

Represents a reference to a Snowflake Alert resource.

With this alert reference, you can create, update, delete, and fetch information about alerts, as well as perform certain actions on them.

Attributes

database¶

fully_qualified_name¶

root¶

Methods

drop(if_exists: bool = False) → None¶

Drop this alert.

Parameters:

if_exists (bool, optional) – Check the existence of this alert before drop. The default value is False.

Examples

Deleting an alert using its reference, erroring if it doesn’t exist:

>>> alert_reference.drop()

Copy

Deleting an alert using its reference if it exists:

>>> alert_reference.drop(if_exists=True)

Copy

execute() → None¶

Execute an alert.

Examples

Use an alert reference to execute it:

>>> alert_reference.execute()

Copy

fetch() → Alert¶

Fetch the details of an alert.

Examples

Fetching an alert reference to print its name and query properties:

>>> my_alert = alert_reference.fetch()
>>> print(my_alert.name, my_alert.condition, my_alert.action)

Copy