What causes ALERT_ACTION_FAILED?

The action SQL references a table or stored procedure that does not exist. The warehouse assigned to the alert was suspended and could not resume in time. The role running the alert lacks INSERT, CALL, or EXECUTE permission on the action target. The action calls an external function or notification integration that has a misconfigured endpoint

How do I fix ALERT_ACTION_FAILED?

Step 1: Query ALERT_HISTORY() in the INFORMATION_SCHEMA to see the last alert execution status and error message.. Step 2: Manually run the action SQL under the alert's owner role to reproduce and inspect the error.. Step 3: Verify that all tables, stored procedures, and integrations referenced in the action still exist and are accessible.. Step 4: If the action uses a notification integration (email, webhook), test the integration independently with SYSTEM$SEND_EMAIL or a direct webhook call.. Step 5: Correct the action SQL or permissions, then use ALTER ALERT RESUME to re-enable the alert.

High severityexecution

Power BI Refresh Error:
ALERT_ACTION_FAILED

What does this error mean?

A Snowflake Alert's action SQL statement failed to execute after the condition evaluated to true, meaning the intended notification or DML action was not performed.

Common causes

1The action SQL references a table or stored procedure that does not exist
2The warehouse assigned to the alert was suspended and could not resume in time
3The role running the alert lacks INSERT, CALL, or EXECUTE permission on the action target
4The action calls an external function or notification integration that has a misconfigured endpoint

How to fix it

1Step 1: Query ALERT_HISTORY() in the INFORMATION_SCHEMA to see the last alert execution status and error message.
2Step 2: Manually run the action SQL under the alert's owner role to reproduce and inspect the error.
3Step 3: Verify that all tables, stored procedures, and integrations referenced in the action still exist and are accessible.
4Step 4: If the action uses a notification integration (email, webhook), test the integration independently with SYSTEM$SEND_EMAIL or a direct webhook call.
5Step 5: Correct the action SQL or permissions, then use ALTER ALERT RESUME to re-enable the alert.

Frequently asked questions

How do I check the history of all my Snowflake alert executions?

Query SELECT * FROM TABLE(INFORMATION_SCHEMA.ALERT_HISTORY()) ORDER BY SCHEDULED_TIME DESC LIMIT 100. This shows scheduled time, state (SUCCEEDED, FAILED, TRIGGERED, CONDITION_FALSE), and error details.

Can I receive a notification when a Snowflake alert itself fails?

Not natively through Snowflake Alerts. You can set up an external monitoring job that queries ALERT_HISTORY periodically and notifies you when the STATE is FAILED. Alternatively, wrap alert logic in a Task with error notification integrations.