<budget_name>!GET_NOTIFICATION_EMAIL¶
Preview Feature — Open
Available to all Snowflake edition accounts.
This feature is currently not available for Trial Accounts or accounts in government regions.
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()
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();
View the email address(es) configured to receive notifications for the account budget:
CALL snowflake.local.account_root_budget!GET_NOTIFICATION_EMAIL();