<budget_name>!SET_SPENDING_LIMIT¶

Syntax¶

<budget_name>!SET_SPENDING_LIMIT(<number>)

Arguments¶

number:

The number of credits allocated to the budget per month. When total usage for all objects assigned to the budget reaches this number for the current month, the budget is considered to be at 100% of the spending limit.

For the account budget, all supported objects contribute to the credit usage.

If a value is not specified for a budget, the budget has no spending limit, will never reach 100% usage, and will not trigger notifications.

Default: -1 (no spending limit).

Returns¶

The spending limit has been updated to <n> credits.

Access Control Requirements¶

• The following minimum privileges and roles are required to view results for custom budgets:

  • A role with the ADMIN instance role for the budget instance.

  • A role granted the USAGE privilege on the database and schema that contains the budget instance.

• The following role is required to view results for the account budget:

  A role with the BUDGET_ADMIN application role for the account budget.

Usage Notes¶

The number argument must be a positive integer.

Examples¶

Set the spending limit for the account budget to 500 credits per month:

CALL snowflake.local.account_root_budget!SET_SPENDING_LIMIT(500);

Set the spending limit for budget my_database.my_schema.my_budget to 100 credits per month.

CALL my_database.my_schema.my_budget!SET_SPENDING_LIMIT(100);