alerts_create
Create a SQL alert that evaluates a saved query and notifies subscribers when a condition is satisfied.
Instructions
Create a new SQL alert. Returns id.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Alert name | |
| query_id | Yes | ID of the saved query to evaluate | |
| condition | Yes | Trigger condition: {'op': '>' | '<' | '>=' | '<=' | '==' | '!=', 'operand': 'VALUE' | 'COLUMN_NAME', 'threshold': {...}} | |
| notify | No | Notify settings: {'subscribers': [{'destination', 'user_id' | 'destination_id' | 'webhook_id'}]} | |
| options | No | ||
| rearm | No | Rearm settings after firing (seconds or null) | |
| schedule | No | ||
| parent | No | Parent folder/workspace path | |
| evaluation | No | Evaluation settings: {'last_eval_run_id', 'state', 'comparison'} | |
| run_as_role | No | OWNER | VIEWER | |
| custom_subject | No | ||
| custom_body | No |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |