SYSTEM$SEND_EMAIL¶

Sends an email notification to the specified recipients from no-reply@snowflake.net.

Note

The Notification System Stored Procedure feature is only hosted on Amazon Web Services (AWS). If you choose to use this feature, the hosting provider for this feature will be AWS and the available location(s) of the hosting will be as set forth in the table below. The content of a message sent using AWS SES may be retained by Snowflake for up to thirty days to manage the delivery of the message and is thereafter deleted.

Supported AWS Regions
us-west-2
us-east-1
eu-west-1

Syntax¶

CALL SYSTEM$SEND_EMAIL(
    '<integration_name>',
    '<email_address_1> [ , ... <email_address_N> ]',
    '<email_subject>',
    '<email_content>'
);

Copy

Arguments¶

integration_name

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_RECIPIENTS property of the notification integration. If any of the email addresses is not in ALLOWED_RECIPIENTS, no emails are sent.

email_subject

Subject line of the email notification. You cannot specify an empty string.

email_content

Body of the email. You cannot specify an empty string.

Snowflake currently supports only plain text email.

Returns¶

Returns TRUE if the stored procedure executes successfully.

Examples¶

See Sending Email Notifications.