<budget_name>!ADD_NOTIFICATION_INTEGRATION

Adds a queue or webhook notification integration to a custom budget or the account budget.

See also:

<budget_name>!GET_NOTIFICATION_INTEGRATIONS, <budget_name>!REMOVE_NOTIFICATION_INTEGRATION

Syntax

<budget_name>!ADD_NOTIFICATION_INTEGRATION( '<integration_name>' )
Copy

Arguments

'integration_name'

The name of the queue or webhook notification integration to add to the budget.

Returns

Returns a VARCHAR value that indicates whether or not the notification integration was successfully added.

  • If the notification integration was added successfully, the method returns Integration added successfully.

  • Otherwise, the method returns an error message.

Access control requirements

The following privileges and roles are required to call this method for a custom budget:

  • ADMIN instance role for the budget instance.

  • USAGE privilege on the database and schema that contain the budget instance.

For more information, see Budgets roles and privileges.

In addition, you must grant the following privileges to the SNOWFLAKE application:

  • The USAGE privilege on the notification integration.

If the notification integration is for a webhook that uses a secret object, you must also grant the following privileges to the SNOWFLAKE application:

  • The READ privilege on that secret.

  • The USAGE privilege on the schema containing that secret.

  • The USAGE privilege on the database containing that schema.

For information, see:

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

The following example adds the notification integration budgets_notification_integration to the account budget:

CALL SNOWFLAKE.LOCAL.ACCOUNT_ROOT_BUDGET!ADD_NOTIFICATION_INTEGRATION(
  'budgets_notification_integration',
);
Copy