MetricSign
EN|NLRequest Access
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

  1. 1Manually resume the warehouse: ALTER WAREHOUSE my_wh RESUME
  2. 2Enable auto-resume if it is off: ALTER WAREHOUSE my_wh SET AUTO_RESUME = TRUE
  3. 3Check resource monitors for triggered actions: SHOW RESOURCE MONITORS
  4. 4If a credit limit was hit, increase the resource monitor quota or contact your Snowflake account team
  5. 5For scheduled jobs, ensure the connector or ETL tool is configured to auto-resume the warehouse before submitting queries

Frequently asked questions

Does AUTO_SUSPEND save money?

Yes — Snowflake charges by the second for compute time. AUTO_SUSPEND stops billing when the warehouse is idle. The default is 600 seconds; lower values save more money but increase cold-start latency.

What is the difference between SUSPEND and ABORT_ALL_QUERIES?

ALTER WAREHOUSE ... SUSPEND waits for running queries to complete before suspending. ABORT_ALL_QUERIES kills running queries immediately. Use SUSPEND for graceful shutdown.

Other infrastructure errors