Alert

Snowflake Documentation

Alerts trigger notifications when certain conditions are met.

Examples

Python

alert = Alert(
    name="some_alert",
    warehouse="some_warehouse",
    schedule="USING CRON * * * * *",
    condition="SELECT COUNT(*) FROM some_table",
    then="CALL SYSTEM$SEND_EMAIL('example@example.com', 'Alert Triggered', 'The alert condition was met.')",
)

YAML

alerts:
  - name: some_alert
    warehouse: some_warehouse
    schedule: USING CRON * * * * *
    condition: SELECT COUNT(*) FROM some_table
    then: CALL SYSTEM$SEND_EMAIL('example@example.com', 'Alert Triggered', 'The alert condition was met.')

Fields

  • name (string, required) - The name of the alert.

  • warehouse (string or Warehouse) - The name of the warehouse to run the query on.

  • schedule (string) - The schedule for the alert to run on.

  • condition (string) - The condition for the alert to trigger on.

  • then (string) - The query to run when the alert triggers.

  • owner (string or Role) - The owner role of the alert. Defaults to "SYSADMIN".

  • comment (string) - A comment for the alert. Defaults to None.

  • tags (dict) - Tags for the alert. Defaults to None.

PreviousAggregationPolicyNextAuthenticationPolicy

Last updated