ANOMALY_INSIGHTS!SET_ORG_NOTIFICATION_EMAILS¶
Defines the list of email addresses that will receive a notification when there is an organization-level cost anomaly.
An organization-level anomaly occurs when the aggregate consumption all of accounts falls outside an expected range. If you want to define a list of email addresses that will receive a notification when a specific account has a cost anomaly, see ANOMALY_INSIGHTS!SET_ACCOUNT_NOTIFICATION_EMAILS.
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_ORG_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 organization-level cost anomaly.
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 organization-level cost anomaly. |
Access control requirements¶
Users with any of the following roles can call this method:
ACCOUNTADMIN role
GLOBALORGADMIN role
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 an organization-level cost anomaly:
CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!SET_ORG_NOTIFICATION_EMAILS(
'user1@example.com, user2@example.com');