<budget_name>!GET_NOTIFICATION_INTEGRATION_NAME

Returns the name of the email notification integration configured for a budget.

To get the names of the notification integrations for cloud provider queues and webhooks, call <budget_name>!GET_NOTIFICATION_INTEGRATIONS instead.

See also:

<budget_name>!GET_NOTIFICATION_EMAIL, <budget_name>!GET_NOTIFICATION_INTEGRATIONS, <budget_name>!GET_NOTIFICATION_MUTE_FLAG, <budget_name>!SET_EMAIL_NOTIFICATIONS, <budget_name>!SET_NOTIFICATION_MUTE_FLAG

语法

<budget_name>!GET_NOTIFICATION_INTEGRATION_NAME()

返回

  • 通知集成的名称。
  • 如果未设置通知电子邮件地址，则为空字符串。

访问控制要求

  • 查看 自定义预算 的结果需要以下最低权限和角色：

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

示例

View the name of the notification integration used by my_budget in schema budget_db.budget_schema:

CALL budget_db.budget_schema.my_budget!GET_NOTIFICATION_INTEGRATION_NAME();

查看账户预算使用的通知集成的名称：

CALL snowflake.local.account_root_budget!GET_NOTIFICATION_INTEGRATION_NAME();