<budget_name>!GET_NOTIFICATION_INTEGRATION_NAME¶
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 name of the notification integration configured for a budget.
- See also:
<budget_name>!GET_NOTIFICATION_EMAIL, <budget_name>!GET_NOTIFICATION_MUTE_FLAG, <budget_name>!SET_EMAIL_NOTIFICATIONS, <budget_name>!SET_NOTIFICATION_MUTE_FLAG
Syntax¶
<budget_name>!GET_NOTIFICATION_INTEGRATION_NAME()
Returns¶
The name of the notification integration.
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 name of the notification integration used by my_budget in schema budget_db.budget_schema:
CALL budget_db.budget_schema.my_budget!GET_NOTIFICATION_INTEGRATION_NAME();
View the name of the notification integration used by the account budget:
CALL snowflake.local.account_root_budget!GET_NOTIFICATION_INTEGRATION_NAME();