Notifications in Snowflake¶

Calling a stored procedure to send a notification¶

To call a stored procedure to send a notification:

1. If you are sending an email notification, make sure that the intended recipients verify their email addresses.

2. Create a notification integration.

3. Call SYSTEM$SEND_SNOWFLAKE_NOTIFICATION or SYSTEM$SEND_EMAIL to send the notification.

Step 1: Verify the email addresses of the email notification recipients¶

You can send email notifications only to Snowflake users within the same account. Those users must verify their email addresses through one of the following interfaces:

• Snowsight (the Snowflake Web Interface)

• Classic Console

Step 2: Create a notification integration¶

When calling the SYSTEM$SEND_SNOWFLAKE_NOTIFICATION or SYSTEM$SEND_EMAIL stored procedure, you must specify a notification integration that will be used to send the notification.

The following topics explain how to create the notification integration.

• Creating an email notification integration

• Creating a notification integration to send notifications to an Amazon SNS topic

• Creating a notification integration to send notifications to a Microsoft Azure Event Grid topic

• Creating a notification integration to send notifications to a Google Cloud Pub/Sub topic

Step 3: Send the notification¶

You can call one of the following stored procedures to send a notification:

• To send a notification to email addresses or queues, call the SYSTEM$SEND_SNOWFLAKE_NOTIFICATION stored procedure.

  Preview Feature — Open

  The SYSTEM$SEND_SNOWFLAKE_NOTIFICATION stored procedure is a preview feature that is available to all accounts.

• To send a notification to email addresses, call the SYSTEM$SEND_EMAIL stored procedure.

Viewing the history of notifications¶

To view the history of notifications, call the Information Schema NOTIFICATION_HISTORY table function.