<budget_name>!GET_NOTIFICATION_EMAIL

View the email address(es) configured to receive budget notifications for a budget.

See also:

<budget_name>!GET_NOTIFICATION_INTEGRATION_NAME, <budget_name>!GET_NOTIFICATION_MUTE_FLAG, <budget_name>!SET_EMAIL_NOTIFICATIONS, <budget_name>!SET_NOTIFICATION_MUTE_FLAG

Syntax

<budget_name>!GET_NOTIFICATION_EMAIL()
Copy

Returns

  • An email address or comma-separated list of email addresses.

  • An empty string if the notification email address is not set.

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 email address(es) configured to receive notifications for my_budget in schema budget_db.budget_schema:

CALL budget_db.budget_schema.my_budget!GET_NOTIFICATION_EMAIL();
Copy

View the email address(es) configured to receive notifications for the account budget:

CALL snowflake.local.account_root_budget!GET_NOTIFICATION_EMAIL();
Copy