<budget_name>!GET_NOTIFICATION_MUTE_FLAG¶

View the status of the notification mute flag for a budget. If the mute flag is set to TRUE, no notification emails are sent about the budget’s spending limit.

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

Syntax¶

<budget_name>!GET_NOTIFICATION_MUTE_FLAG()

Copy

Returns¶

TRUE if notifications are disabled.
FALSE if notifications are enabled.

Access Control Requirements¶

The following minimum privileges and roles are required to view results 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.
The following role is required to view results for the account budget:
- A role with any application role for the account budget.

Examples¶

View the state of the notification mute flag for my_budget in schema budget_db.budget_schema:

CALL budget_db.budget_schema.my_budget!GET_NOTIFICATION_MUTE_FLAG();

Copy

View the state of the notification mute flag for the account budget:

CALL snowflake.local.account_root_budget!GET_NOTIFICATION_MUTE_FLAG();

Copy