<budget_name>!GET_NOTIFICATION_INTEGRATIONS¶
Returns information about the queue and webhook notification integrations associated with a custom budget or the account budget.
To get the name of the email notification integration associated with the budget, call <budget_name>!GET_NOTIFICATION_INTEGRATION_NAME instead.
- See also:
<budget_name>!ADD_NOTIFICATION_INTEGRATION, <budget_name>!GET_NOTIFICATION_INTEGRATION_NAME, <budget_name>!REMOVE_NOTIFICATION_INTEGRATION
Syntax¶
<budget_name>!GET_NOTIFICATION_INTEGRATIONS()
Returns¶
Returns tabular data containing information about the notification integrations associated with the budget. The data includes a row for each queue or webhook notification integration associated with the budget. The rows include the following columns:
Column name |
Data type |
Description |
---|---|---|
|
VARCHAR |
Name of the notification integration. |
|
NUMBER |
UTC timestamp when the last notification was sent. If no notifications were sent out yet, the value in this column is
|
|
DATE |
Date when the notification integration was added to the budget. |
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:
Any application role 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 names of the queue and webhook notification integrations, if any, for my_budget
in schema budget_db.budget_schema
:
CALL budget_db.budget_schema.my_budget!GET_NOTIFICATION_INTEGRATIONS();
View the names of the queue and webhook notification integrations, if any, for the account budget:
CALL SNOWFLAKE.LOCAL.ACCOUNT_ROOT_BUDGET!GET_NOTIFICATION_INTEGRATIONS();