Medium severityexecution
Power BI Refresh Error:
000603 (XX000)
What does this error mean?
Snowflake aborted query processing before completion. This typically happens due to a user-initiated cancel, a session timeout, a warehouse restart, or an internal resource limit being reached.
Common causes
- 1Query was explicitly cancelled by a user or by a SYSTEM$CANCEL_QUERY() call
- 2Session or statement timeout (STATEMENT_TIMEOUT_IN_SECONDS) was reached
- 3The virtual warehouse was suspended or restarted mid-query
- 4A Snowflake warehouse auto-suspend occurred during a long-running query
- 5Snowflake platform maintenance or internal resource reclamation aborted the query
How to fix it
- 1Check query history for the query status — if marked 'cancelled' it was explicitly stopped
- 2Increase STATEMENT_TIMEOUT_IN_SECONDS for long-running queries: ALTER SESSION SET STATEMENT_TIMEOUT_IN_SECONDS = 3600
- 3Set AUTO_SUSPEND to a higher value on the warehouse so it does not suspend during active queries: ALTER WAREHOUSE my_wh SET AUTO_SUSPEND = 600
- 4For ETL jobs, configure retry logic to re-run aborted queries automatically
- 5If aborts occur on a shared warehouse, consider a dedicated warehouse for long-running batch jobs