<budget_name>!REMOVE_NOTIFICATION_INTEGRATION

Removes a queue or webhook notification integration from a custom budget or the account budget.

See also:

<budget_name>!ADD_NOTIFICATION_INTEGRATION, <budget_name>!GET_NOTIFICATION_INTEGRATIONS

语法

<budget_name>!REMOVE_NOTIFICATION_INTEGRATION( '<integration_name>' )

实参

'integration_name'

要从预算中移除的队列或 Webhook 通知集成的名称。

返回

返回一个 VARCHAR 值，指明是否已成功移除通知集成。

  • If the notification integration was removed successfully, the method returns Integration removed successfully.
  • 否则该方法会返回错误消息。

访问控制要求

要对预算调用此方法，需要具备以下最低权限和角色：

  • ADMIN instance role for the budget instance.
  • 对包含预算实例的数据库和架构的 USAGE 权限。

For more information, see Budgets roles and privileges.

使用说明

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.

示例

Remove the notification integration budgets_notification_integration from custom budget my_budget in schema budget_db.budget_schema:

CALL budget_db.budget_schema.my_budget!REMOVE_NOTIFICATION_INTEGRATION(
  'budgets_notification_integration');

Remove the notification integration budgets_notification_integration from the account budget:

CALL SNOWFLAKE.LOCAL.ACCOUNT_ROOT_BUDGET!REMOVE_NOTIFICATION_INTEGRATION(
  'budgets_notification_integration');