Create and Execute an Alert
A 3-step recipe with Snowflake. We can help you get access.
Recipe · 3 steps
Create and Execute an Alert
with Snowflake
Create an alert, fetch it to confirm, then execute it on demand.
- Create the alert with its condition, action, warehouse, and schedule.
- Describe the alert to confirm it was created.
- Execute the alert immediately rather than waiting for its schedule.
What you'll need to have ready
- authToken: Bearer token (KEYPAIR_JWT, OAUTH, or programmatic access token).
- tokenType: Value for the X-Snowflake-Authorization-Token-Type header.
- databaseName: Database that holds the schema and alert.
- schemaName: Schema that holds the alert.
- alertName: Name of the alert to create.
- warehouse: Warehouse used to evaluate the alert condition and action.
- condition: The SQL condition that triggers the alert.
- action: The SQL action performed when the condition is met.
- schedule: The schedule object controlling how often the alert is evaluated.
- comment: Optional comment applied to the alert.
For your developer
Arazzo workflow snowflake:create-and-execute-alert, 3 operations: createAlert → fetchAlert → executeAlert. Specs on APIs.io.