What causes ALERT_CONDITION_EVALUATION_FAILED?

A table or view referenced in the condition SQL was dropped or renamed after the alert was created. The warehouse used by the alert was deleted or the alert owner role lost USAGE on it. The condition query returned more than one column or used a non-boolean expression. A dynamic table or stream referenced in the condition is in an error state

How do I fix ALERT_CONDITION_EVALUATION_FAILED?

Step 1: Query ALERT_HISTORY() to retrieve the specific SQL error from the condition evaluation failure.. Step 2: Run the condition SQL manually under the alert's owner role to reproduce the error.. Step 3: Fix the condition SQL — ensure it returns exactly one row with one column containing a non-null value to fire, per Snowflake Alert requirements.. Step 4: Verify the warehouse assigned to the alert still exists and the alert owner role has USAGE on it.. Step 5: Use ALTER ALERT RESUME after fixing the condition to re-activate the alert.

High severityexecution

Power BI Refresh Error:
ALERT_CONDITION_EVALUATION_FAILED

What does this error mean?

A Snowflake Alert's condition SQL failed to execute during its scheduled evaluation, meaning the system could not determine whether the alert should fire.

Common causes

1A table or view referenced in the condition SQL was dropped or renamed after the alert was created
2The warehouse used by the alert was deleted or the alert owner role lost USAGE on it
3The condition query returned more than one column or used a non-boolean expression
4A dynamic table or stream referenced in the condition is in an error state

How to fix it

1Step 1: Query ALERT_HISTORY() to retrieve the specific SQL error from the condition evaluation failure.
2Step 2: Run the condition SQL manually under the alert's owner role to reproduce the error.
3Step 3: Fix the condition SQL — ensure it returns exactly one row with one column containing a non-null value to fire, per Snowflake Alert requirements.
4Step 4: Verify the warehouse assigned to the alert still exists and the alert owner role has USAGE on it.
5Step 5: Use ALTER ALERT RESUME after fixing the condition to re-activate the alert.

Frequently asked questions

What SQL structure does a Snowflake Alert condition require?

The condition must be a SELECT statement that returns at least one row to trigger the action. A result set with zero rows means the condition is false and the action is skipped. Returning multiple columns is allowed but only the row presence matters.

How do I pause an alert while fixing the condition?

Run ALTER ALERT <name> SUSPEND. This stops evaluation without deleting the alert definition. After fixing, run ALTER ALERT <name> RESUME.