<budget_name>!REMOVE_NOTIFICATION_INTEGRATION¶
Removes a queue or webhook notification integration from a custom budget or the account budget.
Syntax¶
<budget_name>!REMOVE_NOTIFICATION_INTEGRATION( '<integration_name>' )
Arguments¶
'integration_name'
The name of the queue or webhook notification integration to remove from the budget.
Returns¶
Returns a VARCHAR value that indicates whether or not the notification integration was successfully removed.
If the notification integration was removed successfully, the method returns
Integration removed successfully
.Otherwise, the method returns an error message.
Access control requirements¶
The following minimum privileges and roles are required to call this method on a budget:
ADMIN instance role for the budget instance.
USAGE privilege on the database and schema that contains the budget instance.
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¶
Remove the notification integration budgets_notification_integration
from custom budget my_budget
in schema
budget_db.budget_schema
:
CALL budget_db.budget_schema.my_budget!REMOVE_NOTIFICATION_INTEGRATION(
'budgets_notification_integration');
Remove the notification integration budgets_notification_integration
from the account budget:
CALL SNOWFLAKE.LOCAL.ACCOUNT_ROOT_BUDGET!REMOVE_NOTIFICATION_INTEGRATION(
'budgets_notification_integration');