account_root_budget!DEACTIVATE¶

Deactivate the account budget.

See also:

account_root_budget!ACTIVATE

语法

CALL account_root_budget!DEACTIVATE()

返回

Deactivated!

访问控制要求

用于调用此方法的角色必须被授予以下角色和权限：

• BUDGET_ADMIN application role
• Snowflake database role USAGE_VIEWER

For more information, see Budgets roles and privileges.

使用说明

• 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.

示例

为您的账户停用账户预算：

CALL snowflake.local.account_root_budget!DEACTIVATE();