<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:

    • Any instance role for the budget instance.

    • USAGE privilege on the database and schema that contains the budget instance.

  • The following role is required to view results for the account budget:

For more information, see Budgets roles and privileges.

Usage notes

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.

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