ANOMALY_INSIGHTS!SET_ACCOUNT_NOTIFICATION_EMAILS¶
Defines the list of email addresses that will receive a notification when there is an account-level cost anomaly in the current account.
Note
Email notifications 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.
Syntax¶
SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!SET_ACCOUNT_NOTIFICATION_EMAILS(
'<email_address> [, <email_address> ... ]' )
Arguments¶
'email_address [, email_address ... ]'Comma-delimited list of email addresses that will receive a notification when there is an account-level cost anomaly.
Each email address must have been verified by the user, otherwise it is ignored.
Returns¶
Returns a table with the following column:
Column name |
Data type |
Description |
|---|---|---|
EMAIL_LIST |
VARCHAR |
Comma-delimited list of email addresses where notifications are sent when there is an account-level cost anomaly in the current account. |
Access control requirements¶
Users with any of the following roles can call this method:
ACCOUNTADMIN role
GLOBALORGADMIN role
Usage notes¶
This method sets the email notification list for the account in which it is called.
Executing this method overwrites email addresses that were previously added to the notification list.
Example¶
Set the email notification list so that users with email addresses user1@example.com and user2@example.com receive a notification
when there is a cost anomaly in the current account:
CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!SET_ACCOUNT_NOTIFICATION_EMAILS(
'user1@example.com, user2@example.com');