Sends an email notification to the specified recipients from
All Snowflake customers can send email messages using this feature. Email messages sent from the Notifications System Stored Procedure are processed through Snowflake’s Amazon Web Services (AWS) deployments, using AWS Simple Email Service (SES). The content of an email message sent using AWS may be retained by Snowflake for up to thirty days to manage the delivery of the message. After this period, the message content is deleted.
CALL SYSTEM$SEND_EMAIL( '<integration_name>', '<email_address_1> [ , ... <email_address_N> ]', '<email_subject>', '<email_content>', [ '<mime_type>' ] );
Name of the notification integration that you want to use to send the email message.
email_address_1 [ , ... email_address_N ]
List of email addresses that should receive the email notification.
Specify one or more unquoted email addresses in a comma-separated string.
The email addresses must be in the
ALLOWED_RECIPIENTSproperty of the notification integration. If any of the email addresses is not in
ALLOWED_RECIPIENTS, no emails are sent.
Subject line of the email notification. You cannot specify an empty string.
Body of the email. You cannot specify an empty string.
The MIME type of the
email_contentvalue, the email’s content. Default is
The following types are supported:
text/plain– Specify this when
email_contentis plain text. This is the default value.
text/html– Specify this when
Note that the content of a message of the
text/htmltype is not validated as well-formed HTML.
Returns TRUE if the stored procedure executes successfully.