SHOW NOTIFICATION INTEGRATIONS and DESC NOTIFICATION INTEGRATION commands: Changes to output (Pending)

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:

New column in the output of SHOW NOTIFICATION INTEGRATIONS

With this behavior change, the output of the SHOW NOTIFICATION INTEGRATIONS command includes the following new column:

Column name

Description

direction

Specifies one of the following values, which indicates whether the integration supports sending or receiving notifications:

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

    This value appears for notification integrations with:

    • TYPE=QUEUE and DIRECTION=OUTBOUND

    • TYPE=EMAIL

    • TYPE=WEBHOOK

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

    This value appears for notification integrations that do not specify DIRECTION=OUTBOUND.

Changes to the output of DESC NOTIFICATION INTEGRATION

With this behavior change, the output of the DESC NOTIFICATION INTEGRATION command changes in the following way:

Before the change:

For notification integrations of the following types, the DIRECTION property was not included in the output:

  • TYPE = QUEUE and NOTIFICATION_PROVIDER = AZURE_STORAGE_QUEUE

  • TYPE = EMAIL

  • TYPE = WEBHOOK

After the change:

The DIRECTION property appears in the output.

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.

Ref: 1846

Language: English