<budget_name>!GET_NOTIFICATION_INTEGRATIONS¶

Returns information about the queue and webhook notification integrations associated with a custom budget or the account budget.

To get the name of the email notification integration associated with the budget, call <budget_name>!GET_NOTIFICATION_INTEGRATION_NAME instead.

See also:: <budget_name>!ADD_NOTIFICATION_INTEGRATION, <budget_name>!GET_NOTIFICATION_INTEGRATION_NAME, <budget_name>!REMOVE_NOTIFICATION_INTEGRATION

语法

<budget_name>!GET_NOTIFICATION_INTEGRATIONS()

返回表格数据，其中包含与预算相关的通知集成的信息。针对与预算相关的每个队列或 Webhook 通知集成，该数据中都包含对应的一行。这些行包括以下列：

列名称	数据类型	描述
`integration_name`	VARCHAR	通知集成名称。
`last_notification_time`	NUMBER	UTC timestamp when the last notification was sent. If no notifications were sent out yet, the value in this column is `-1`.
`added_date`	DATE	通知集成添加到预算的日期。

访问控制要求

查看 自定义预算 的结果需要以下最低权限和角色：
- Any instance role for the budget instance.
- 对包含预算实例的数据库和架构的 USAGE 权限。
需要以下角色才能查看 账户预算 的结果：
- Any application role for the account budget.

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.

示例

View the names of the queue and webhook notification integrations, if any, for my_budget in schema budget_db.budget_schema:

CALL budget_db.budget_schema.my_budget!GET_NOTIFICATION_INTEGRATIONS();

针对账户预算，查看队列名称和 Webhook 通知集成（如有）：

CALL SNOWFLAKE.LOCAL.ACCOUNT_ROOT_BUDGET!GET_NOTIFICATION_INTEGRATIONS();