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>'
);
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 inALLOWED_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.