<budget_name>!SET_NOTIFICATION_MUTE_FLAG¶
Preview Feature — Open
Available to all Snowflake edition accounts.
This feature is currently not available for Trial Accounts or accounts in government regions.
Enable or disable email notifications for a budget.
- See also:
<budget_name>!GET_NOTIFICATION_EMAIL, <budget_name>!GET_NOTIFICATION_INTEGRATION_NAME, <budget_name>!GET_NOTIFICATION_MUTE_FLAG, <budget_name>!SET_EMAIL_NOTIFICATIONS
Syntax¶
<budget_name>!SET_NOTIFICATION_MUTE_FLAG( { TRUE | FALSE } );
Arguments¶
{ TRUE | FALSE }:TRUE to disable email notifications.
FALSE to enable email notifications.
Default: FALSE
Returns¶
The notification mute flag has been updated to <true | false>.
Access Control Requirements¶
The following minimum privileges and roles are required to execute this method for custom budgets:
A role with any instance role for the budget instance.
A role granted the USAGE privilege on the database and schema that contains the budget instance.
To execute this method for the account budget:
A role with any application role for the account budget.
Examples¶
Disable email notifications for budget my_budget in schema budget_db.budget_schema:
CALL budget_db.budget_schema.my_budget!SET_NOTIFICATION_MUTE_FLAG(TRUE);
Enable email notifications for the account budget:
CALL snowflake.local.account_root_budget!SET_NOTIFICATION_MUTE_FLAG(FALSE);