- Categories:
User & Security DDL (Third-Party Service Integrations)
ALTER NOTIFICATION INTEGRATION¶
Modifies the properties for an existing notification integration.
In this Topic:
Syntax¶
ALTER [ NOTIFICATION ] INTEGRATION [ IF EXISTS ] <name> SET
[ ENABLED = { TRUE | FALSE } ]
cloudProviderParams
[ COMMENT = '<string_literal>' ]
Where:
cloudProviderParams (for Microsoft Azure) ::= AZURE_STORAGE_QUEUE_PRIMARY_URI = 'https://<storage_queue_account>.queue.core.windows.net/<storage_queue_name>' AZURE_TENANT_ID = '<ad_directory_id>'
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.
COMMENT = 'string_literal'
String (literal) that specifies a comment for the integration.
Cloud Provider Parameters (cloudProviderParams
)¶
Google Cloud Storage
None.
Microsoft Azure
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:
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.
Examples¶
The following example initiates operation of a suspended integration:
ALTER NOTIFICATION INTEGRATION myint SET ENABLED = TRUE;