Snowpipe: Multiple auto-ingest notification integrations with the same URL not allowed for Azure and GCP

Attention

This behavior change is in the 2023_08 bundle.

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

Snowflake does not allow multiple auto-ingest notification integrations with the same URL for Azure and GCP.

Before the change:

When you create a new pipe using a notification integration with the same queue URL as another notification integration, the pipe creation succeeds without error.

After the change:

When you create a new pipe using a notification integration with the same queue URL as another notification integration, the pipe creation fails with an error: “Notification queue already in use with another integration.”

Ref: 1394