CREATE NOTIFICATION INTEGRATION（出站到 Azure 事件网格主题）¶

Creates a new notification integration in the account or replaces an existing integration for sending a message to an Azure Event Grid topic.

Note

Currently, this feature is limited to Snowflake accounts hosted on Microsoft Azure.

See also:: ALTER NOTIFICATION INTEGRATION (outbound to an Azure Event Grid topic) , DESCRIBE NOTIFICATION INTEGRATION , DROP INTEGRATION , SHOW NOTIFICATION INTEGRATIONS

语法

CREATE [ OR REPLACE ] NOTIFICATION INTEGRATION [ IF NOT EXISTS ] <name>
  ENABLED = { TRUE | FALSE }
  TYPE = QUEUE
  DIRECTION = OUTBOUND
  NOTIFICATION_PROVIDER = AZURE_EVENT_GRID
  AZURE_EVENT_GRID_TOPIC_ENDPOINT = '<event_grid_topic_endpoint>'
  AZURE_TENANT_ID = '<ad_directory_id>';
  [ COMMENT = '<string_literal>' ]

必填参数

name: String that specifies the identifier (i.e. name) for the integration; must be unique in your account.

In addition, the identifier must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (for example, "My object"). Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

ENABLED = { TRUE | FALSE }

Specifies whether to initiate operation of the integration or suspend it.

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

The value is case-insensitive.

The default is TRUE.

TYPE = QUEUE: Specifies that this is an integration between Snowflake and a third-party cloud message-queuing service.

DIRECTION = OUTBOUND: Specifies that Snowflake produces the notification sent to the cloud messaging service.

NOTIFICATION_PROVIDER = AZURE_EVENT_GRID: 将 Microsoft Azure 事件网格指定为第三方云消息队列服务。

AZURE_EVENT_GRID_TOPIC_ENDPOINT = 'event_grid_topic_endpoint': Event Grid topic endpoint to which Snowflake pushes notifications.
AZURE_TENANT_ID = 'ad_directory_id': 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 topic.

可选参数

COMMENT = 'string_literal'

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

Default: No value

访问控制要求

A role used to execute this operation must have the following privileges at a minimum:

权限	对象	备注
CREATE INTEGRATION	账户	Only the ACCOUNTADMIN role has this privilege by default. The privilege can be granted to additional roles as needed.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

使用说明

推送通知支持对多个管道使用相同的出站通知集成。
关于元数据：

Attention

Customers should ensure that no personal data (other than for a User object), sensitive data, export-controlled data, or other regulated data is entered as metadata when using the Snowflake service. For more information, see Metadata fields in Snowflake.

The OR REPLACE and IF NOT EXISTS clauses are mutually exclusive. They can’t both be used in the same statement.
CREATE OR REPLACE <object> statements are atomic. That is, when an object is replaced, the old object is deleted and the new object is created in a single transaction.

The government regions of the cloud providers do not allow event notifications to be sent to or from other commercial regions. For more information, see Azure Government (https://learn.microsoft.com/en-us/azure/azure-government/).

示例

请参阅以下主题：