SHOW NOTIFICATION INTEGRATIONS 和 DESC NOTIFICATION INTEGRATION 命令：输出变更

Attention

This behavior change is in the 2025_01 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the output of the SHOW NOTIFICATION INTEGRATIONS and DESC NOTIFICATION INTEGRATION commands changes as described in the following sections:

SHOW NOTIFICATION INTEGRATIONS 输出中的新列

进行此行为变更之后，SHOW NOTIFICATION INTEGRATIONS 命令的输出将包括以下新列：

Column nameDescription
direction

指定以下值之一，表示集成是否支持发送或接收通知：

  • OUTBOUND: Snowflake uses the integration to send notifications to a third-party messaging service.

此值用于通知集成，其中：

  • TYPE=QUEUE，DIRECTION=OUTBOUND

  • TYPE=EMAIL

  • TYPE=WEBHOOK

  • INBOUND: Snowflake uses the integration to receive notifications from a third-party messaging service.

此值用于未指定 DIRECTION=OUTBOUND 的通知集成。

DESC NOTIFICATION INTEGRATION 输出变更

进行此行为变更之后，DESC NOTIFICATION INTEGRATION 命令的输出按以下方式变更：

Before the change:

对于以下类型的通知集成，输出中不包括 DIRECTION 属性：

  • TYPE = QUEUE，NOTIFICATION_PROVIDER = AZURE_STORAGE_QUEUE
  • TYPE = EMAIL
  • TYPE = WEBHOOK
After the change:

DIRECTION 属性会在输出中显示。

In addition, the value in the property_default column for the DIRECTION property changes in the following way:

Before the change:

The property_default column contains INBOUND for the DIRECTION property.

After the change:

The property_default column contains an empty string for the DIRECTION property.

参考：1846