Medium severitycapacity
Power BI Refresh Error:
Snowflake Budget Exceeded Notification
What does this error mean?
A Snowflake Budget reached its configured spending threshold and triggered a notification or action. Depending on the budget configuration, warehouses may be suspended automatically when the credit limit is hit.
Common causes
- 1A warehouse is running more than expected (long queries, missing auto-suspend, or a loop in a Snowflake Task)
- 2Automatic Clustering or Materialized View maintenance consumed more credits than budgeted
- 3A data load pipeline ran longer than expected due to file volume growth
- 4A runaway query or task loop consumed credits without a circuit breaker
How to fix it
- 1Check the budget alert in Snowsight under Admin → Cost Management → Budgets.
- 2Identify the credit consumer: `SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY WHERE START_TIME > DATEADD('hour',-24,CURRENT_TIMESTAMP()) ORDER BY CREDITS_USED DESC`.
- 3For runaway tasks: `SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY()) WHERE STATE = 'RUNNING' ORDER BY SCHEDULED_TIME DESC` to find long-running tasks.
- 4Enable auto-suspend on all warehouses: `ALTER WAREHOUSE <wh> SET AUTO_SUSPEND = 60`.
- 5Add a STATEMENT_TIMEOUT to long-running queries to prevent a single query from consuming excessive credits.