ANOMALY_
Returns the notification integrations that are registered to receive cost anomaly notifications for the specified anomaly scope.
Syntax¶
Arguments¶
'anomaly_scope'Specifies the anomaly level to return registered notification integrations for. The value is case-insensitive and must be one of the following:
ACCOUNT: Returns the integrations registered for account-level cost anomalies.ORG: Returns the integrations registered for organization-level cost anomalies.
Output¶
Returns a table with the following columns, ordered by registration time in descending order. If no integrations are registered for the specified anomaly scope, the table is empty.
| Column name | Data type | Description |
|---|---|---|
| INTEGRATION_NAME | VARCHAR | Name of the registered notification integration. |
| LAST_SUCCESSFUL_NOTIFICATION | TIMESTAMP_TZ | Timestamp of the most recent successful notification sent to the integration. The value is NULL if no notification has been sent. |
| ADDED_TIMESTAMP | TIMESTAMP_TZ | Timestamp when the notification integration was registered. |
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
- SNOWFLAKE.APP_USAGE_VIEWER application role
- SNOWFLAKE.ORGANIZATION_BILLING_VIEWER application role in the organization account
- SNOWFLAKE.APP_ORGANIZATION_BILLING_VIEWER application role in an ORGADMIN-enabled account
Usage notes¶
- Anomaly Insights notification integrations must be enabled for the account. If the feature isn’t enabled, this method raises an exception.
- This method raises an exception if the anomaly scope is invalid.
- This method doesn’t validate whether the underlying notification integration objects still exist in the account.
Example¶
Return the notification integrations registered for account-level cost anomalies: