What causes BUDGET_LIMIT_EXCEEDED?

An unexpectedly large query or a runaway pipeline consumed credits faster than the budget period anticipated. The budget's credit limit was set too conservatively for the current workload, with no buffer for peak usage. A new scheduled task, dynamic table, or serverless feature was assigned to the budget without adjusting the credit limit

How do I fix BUDGET_LIMIT_EXCEEDED?

Step 1: Query SNOWFLAKE.BUDGET_MONITOR.BUDGET_USAGE_HISTORY or the budget's notification history to identify which resource consumed the most credits.. Step 2: Increase the budget's credit limit via ALTER BUDGET or create a higher-limit budget for the affected resources if the usage is legitimate.. Step 3: If a runaway query caused the overage, identify and terminate any lingering queries using SHOW QUERIES and SYSTEM$CANCEL_QUERY.. Step 4: Review the budget's action policy — adjust the threshold percentages so that notifications fire early enough to take manual action before suspension.

Critical severityresource

Power BI Refresh Error:
BUDGET_LIMIT_EXCEEDED

What does this error mean?

A Snowflake Budget object's credit limit was reached, triggering either a notification or an automatic suspension of the monitored warehouses or compute resources assigned to that budget.

Common causes

1An unexpectedly large query or a runaway pipeline consumed credits faster than the budget period anticipated
2The budget's credit limit was set too conservatively for the current workload, with no buffer for peak usage
3A new scheduled task, dynamic table, or serverless feature was assigned to the budget without adjusting the credit limit

How to fix it

1Step 1: Query SNOWFLAKE.BUDGET_MONITOR.BUDGET_USAGE_HISTORY or the budget's notification history to identify which resource consumed the most credits.
2Step 2: Increase the budget's credit limit via ALTER BUDGET or create a higher-limit budget for the affected resources if the usage is legitimate.
3Step 3: If a runaway query caused the overage, identify and terminate any lingering queries using SHOW QUERIES and SYSTEM$CANCEL_QUERY.
4Step 4: Review the budget's action policy — adjust the threshold percentages so that notifications fire early enough to take manual action before suspension.

Frequently asked questions

Is a Snowflake Budget different from a Resource Monitor?

Yes. A Resource Monitor is older and monitors virtual warehouse credit consumption. Snowflake Budgets (introduced in 2023) are more flexible and can monitor serverless tasks, dynamic tables, and other compute types in addition to warehouses.

Can budget limits be automatically increased?

No. Budget limits must be manually adjusted by an account administrator. Automatic scaling is not supported for budget credit limits.