<budget_name>!SET_NOTIFICATION_MUTE_FLAG

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 } );
Copy

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);
Copy

Enable email notifications for the account budget:

CALL snowflake.local.account_root_budget!SET_NOTIFICATION_MUTE_FLAG(FALSE);
Copy