# ALERT

Config path: `/<database>/<schema>/alert/<name>.yaml`

Example:

```yaml
warehouse: al001_wh1
schedule: 1 minute

condition: |-
  SELECT gauge_value
  FROM ${{ env_prefix }}db1.sc1.gauge
  WHERE gauge_value>200

action: |-
  INSERT INTO ${{ env_prefix }}db1.sc1.gauge_value_exceeded_history
  VALUES (current_timestamp())

```

## Schema

* **warehouse** (ident) - warehouse used to executed alert
* <mark style="background-color:red;">**schedule**</mark> (str) - schedule for periodically evaluating the condition for the alert
* <mark style="background-color:red;">**condition**</mark> (str) - SQL statement that represents the condition for the alert
* <mark style="background-color:red;">**action**</mark> (str) - SQL statement that should be executed if the condition returns one or more rows
* **comment** (str)

## Usage notes

1. SnowDDL only creates alerts. Alerts are initially suspended. You should execute `ALTER ALERT ... RESUME` via different means to enable alert execution.
2. Schema objects should be referred using fully-qualified identifiers, with `${{ env_prefix }}` placeholder, database name, schema name and object name. It is currently required due to limitations of `ALTER ALERT` command missing scope during validation of SQL statements.
3. Alerts can only be created via SnowDDL config. Users with `OWNER` privilege on specific schemas cannot create custom alerts in such schemas.
4. Alerts are executed with full privileges of [SnowDDL Administrator User](/guides/other-guides/admin.md) role.

## Additional privileges

In order for `ALERT` objects to operate properly, the following additional grants should be added to OWNER role in [schema config](/basic/yaml-configs/schema.md):

* `owner_warehouse_usage` - list warehouses used to execute alerts
* `owner_integration_usage` - if you send alert notifications, add name of notification integration here
* `owner_account_grants` - Snowflake requires `EXECUTE ALERT` or `EXECUTE MANAGED ALERT` privilege to run alerts

## Links

* [CREATE ALERT](https://docs.snowflake.com/en/sql-reference/sql/create-alert.html)
* [ALTER ALERT](https://docs.snowflake.com/en/sql-reference/sql/alter-alert.html)
* [SHOW ALERTS](https://docs.snowflake.com/en/sql-reference/sql/show-alerts.html)
* [Setting up Alerts](https://docs.snowflake.com/en/user-guide/alerts.html)
* [Parser & JSON Schema (GitHub)](https://github.com/littleK0i/SnowDDL/blob/master/snowddl/parser/alert.py)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.snowddl.com/basic/yaml-configs/alert.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.