Medium severityinfrastructure
Power BI Refresh Error:
Warehouse Suspended / Auto-Suspend
What does this error mean?
The virtual warehouse that should execute the query or job is in a SUSPENDED state. Queries will queue until the warehouse auto-resumes (if enabled) or fail immediately if auto-resume is disabled.
Common causes
- 1AUTO_SUSPEND was reached with no active queries — warehouse entered suspended state as expected
- 2AUTO_RESUME is set to FALSE, so the warehouse does not restart automatically when queries arrive
- 3The warehouse was manually suspended by an administrator (ALTER WAREHOUSE my_wh SUSPEND)
- 4Credit limit reached and Snowflake auto-suspended all warehouses
- 5A resource monitor with a SUSPEND action triggered due to credit consumption
How to fix it
- 1Manually resume the warehouse: ALTER WAREHOUSE my_wh RESUME
- 2Enable auto-resume if it is off: ALTER WAREHOUSE my_wh SET AUTO_RESUME = TRUE
- 3Check resource monitors for triggered actions: SHOW RESOURCE MONITORS
- 4If a credit limit was hit, increase the resource monitor quota or contact your Snowflake account team
- 5For scheduled jobs, ensure the connector or ETL tool is configured to auto-resume the warehouse before submitting queries