Source
SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG
Sends a notification to Snowflake Open Catalog to update Snowflake - managed Apache Iceberg™ tables in Open Catalog with the latest table changes, and returns whether the notification was sent successfully along with an error code and…
Sending email notifications
To send an email notification: Make sure that the intended recipients verify their email addresses. Create a notification integration. Call a stored procedure to send the notification.
SYSTEM$SEND_SNOWFLAKE_NOTIFICATION
To send an HTML email message, call the TEXT_HTML function. To send a plain text email message, call the TEXT_PLAIN function. To send a JSON message to a queue, call the APPLICATION_JSON function.
Using SYSTEM$SEND_EMAIL to send email notifications
To send the email notification, call the SYSTEM$SEND_EMAIL stored procedure. For example, to use the notification integration my_email_int to send an email message with the subject line “Email Alert: Task A has finished.”…
Creating a notification integration to send notifications to a Microsoft Azure Event Grid topic
To send notifications to a Microsoft Azure Event Grid topic, you must create a notification integration for that topic. To do this: Create a custom Event Grid topic. Create a notification integration. NoteCurrently, this feature is limited…
ALTER NOTIFICATION INTEGRATION (email)
Modifies the properties for an existing notification integration for sending email messages.
CREATE NOTIFICATION INTEGRATION (email)
Creates a new notification integration in the account or replaces an existing integration for sending email messages.
Creating a notification integration to send notifications to a Google Cloud Pub/Sub topic
To send notifications to a Google Cloud Pub/Sub topic, you must create a notification integration for that topic. To do this: Create a Pub/Sub topic. Create a Pub/Sub subscription. Create a notification integration.
SYSTEM$SEND_EMAIL
Sends an email notification to the specified recipients from no - reply@snowflake.net. NoteEmail notifications are processed through Snowflake’s Amazon Web Services (AWS) deployments, using AWS Simple Email Service (SES).
INTEGRATION
Returns a JSON object that specifies the notification integration to use to send a message. This is a helper function that you use to construct an integration configuration object for the SYSTEM$SEND_SNOWFLAKE_NOTIFICATION stored…