<budget_name>!SET_EMAIL_NOTIFICATIONS¶

Set the email addresses to receive budgets notifications.

See also:: <budget_name>!GET_NOTIFICATION_EMAIL, <budget_name>!GET_NOTIFICATION_INTEGRATION_NAME, <budget_name>!GET_NOTIFICATION_MUTE_FLAG, <budget_name>!SET_NOTIFICATION_MUTE_FLAG

语法

<budget_name>!SET_EMAIL_NOTIFICATIONS( [ '<notification_integration>', ]
                                       '<email> [ , <email> [ , ... ] ]' )

必填实参

'email [ , email [ , ... ] ]': Specifies the email addresses to receive budget notification emails. Each email address in the list must be verified.

可选实参

'notification_integration'

Specifies the identifier for the email notification integration.

If the ALLOWED_RECIPIENTS parameter is set for the notification integration, each email in the notifications list must be included in the ALLOWED_RECIPIENTS list for the notification integration. Otherwise, you can include any verified email address in the notifications list.

The email integration is updated.

访问控制要求

为 自定义预算 调用此方法需要以下最低权限和角色：
- ADMIN instance role for the budget instance.
- 对包含预算实例的数据库和架构的 USAGE 权限。
The minimum role required to call this method for the account budget is the BUDGET_ADMIN application role.

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.
If you are using a notification integration, the USAGE privilege on the notification integration must be granted to APPLICATION SNOWFLAKE:
```
GRANT USAGE ON INTEGRATION budgets_notification_integration
  TO APPLICATION SNOWFLAKE;
```

示例

Send email notifications for budget my_budget in the budgets_db.budgets_schema schema to costadmin@domain.com and budgetadmin@domain.com:

CALL budgets_db.budgets_schema.my_budget!SET_EMAIL_NOTIFICATIONS(
   'costadmin@domain.com, budgetadmin@domain.com');

Send email notifications for the account budget to budgetadmin@domain.com:

CALL snowflake.local.account_root_budget!SET_EMAIL_NOTIFICATIONS(
   'budgets_notification', 'budgetadmin@domain.com');

错误消息

For a list of common error messages and their causes and solutions, see You can’t set email notifications for a budget.