ANOMALY_INSIGHTS!GET_MONITOR_NOTIFICATION_EMAILS¶

Returns the list of email addresses that receive a notification when an anomaly monitor detects a cost anomaly.

Syntax¶

SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_MONITOR_NOTIFICATION_EMAILS(
  '<alias>' )

Arguments¶

'alias'

Name of the monitor. The name isn’t case-sensitive.

Data type: VARCHAR

Output¶

Returns a VARCHAR that contains a comma-delimited list of the email addresses currently associated with the monitor.

Access control requirements¶

Users with any of the following roles can call this method:

• ACCOUNTADMIN system role
• GLOBALORGADMIN system role
• SNOWFLAKE.APP_USAGE_ADMIN application role

Usage notes¶

• The method fails if no monitor with the specified name exists in the account.
• To change the list, use ANOMALY_INSIGHTS!SET_MONITOR_NOTIFICATION_EMAILS.

Example¶

Return the notification list for the monitor named Eng-Platform:

CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_MONITOR_NOTIFICATION_EMAILS('Eng-Platform');