create_alert
Create an alert that watches a saved query and triggers when a specified column meets a condition (greater than, less than, or equals) a threshold.
Instructions
Create an alert that watches a saved query and fires when a chosen result column crosses a threshold (e.g., daily_signups less than 10). Behavior: creates the alert and returns its id and name. Usage: get the query_id from list_queries and confirm the exact column name with get_query / get_query_result first. The alert evaluates the query's latest result on Redash's schedule.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| op | Yes | Comparison operator between the column value and the threshold | |
| name | Yes | Display name for the alert | |
| rearm | No | Seconds to wait before the alert can fire again; 0 means fire only once until manually reset (default 0) | |
| value | Yes | Threshold value that triggers the alert when the comparison is true | |
| column | Yes | Name of the result column to compare against the threshold | |
| query_id | Yes | ID of the saved query whose results are monitored (from list_queries) |