Categories:: User & Security DDL (Third-Party Service Integrations)

ALTER NOTIFICATION INTEGRATION¶

Modifies the properties for an existing notification integration.

See also:: CREATE NOTIFICATION INTEGRATION , DROP INTEGRATION , SHOW INTEGRATIONS

In this Topic:

Syntax
Parameters
Examples

Syntax¶

ALTER [ NOTIFICATION ] INTEGRATION [ IF EXISTS ] <name> SET
  [ ENABLED = { TRUE | FALSE } ]
  [ AZURE_STORAGE_QUEUE_PRIMARY_URI = 'https://<storage_queue_account>.queue.core.windows.net/<storage_queue_name>' ]
  [ AZURE_TENANT_ID = '<ad_directory_id>' ]
  [ COMMENT = '<string_literal>' ]

Parameters¶

name

Identifier for the integration to alter. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

SET ...

Specifies one (or more) properties/parameters to set for the table (separated by blank spaces, commas, or new lines):

ENABLED = TRUE | FALSE Specifies whether to initiate operation of the integration or suspend it.

TRUE allows the integration to run based on the parameters specified in the pipe definition.

FALSE suspends the integration for maintenance. Any integration between Snowflake and a third-party service fails to work.

AZURE_STORAGE_QUEUE_PRIMARY_URI = 'https://storage_queue_account.queue.core.windows.net/storage_queue_name'

Specifies the queue ID for the Azure Queue Storage queue created for Event Grid notifications.

Note

An Azure Queue Storage queue supports a single notification integration. Referencing a single storage queue in multiple notification integrations can result in missing data in target tables because event notifications are split between notification integrations.

For more information, see:

Snowpipe: Automating Snowpipe for Azure Blob Storage
External tables: Refreshing External Tables Automatically for Azure Blob Storage

AZURE_TENANT_ID = 'ad_directory_id'

Specifies the ID of the Azure Active Directory tenant used for identity management. This ID is needed to generate the consent URL that grants Snowflake access to the Event Grid notification subscription, which is used to automatically trigger Snowpipe loads of new files in blob storage.

COMMENT = 'string_literal'

String (literal) that specifies a comment for the integration.

Examples¶

The following example initiates operation of a suspended integration:

ALTER NOTIFICATION INTEGRATION myint SET ENABLED = TRUE;