account_root_budget!DEACTIVATE¶

Syntax¶

CALL account_root_budget!DEACTIVATE()

Returns¶

Deactivated!

Access control requirements¶

The role used to call this method must be granted the following role and privilege:

• BUDGET_ADMIN application role

• Snowflake database role USAGE_VIEWER

For more information, see Budgets roles and privileges.

Usage notes¶

• After you deactivate the account budget, you can no longer create new custom budgets using Snowsight. However, you can continue to create custom budgets using SQL.

• This method is only available on the account budget. Custom budgets can’t be deactivated. They must be dropped using the DROP BUDGET command.

• Calling this method does not return the object. Because of this, you can’t use method chaining to call another method on the return value of this method. Instead, call each method in a separate SQL statement.

Example¶

Dectivate the account budget for your account:

CALL snowflake.local.account_root_budget!DEACTIVATE();