ANOMALY_INSIGHTS!GET_ACCOUNT_ANOMALIES_IN_CREDITS¶

Returns daily consumption for the current account, and identifies whether that consumption is considered a cost anomaly.

Note

This method returns consumption with credits as the unit of measure. If you want to return consumption in a currency instead, see ANOMALY_INSIGHTS!GET_DAILY_CONSUMPTION_ANOMALY_DATA.

Syntax¶

SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_ACCOUNT_ANOMALIES_IN_CREDITS(
  '<start_date>',
  '<end_date>' )

Copy

'start_date'

Specifies the beginning of the time period for which consumption data is returned.

Data type: DATE

'end_date'

Specifies the end of the time period for which consumption data is returned.

Data type: DATE

Returns a table with the following columns:

Column name	Data type	Description
USAGE_DATE	DATE	Day in Coordinated Universal Time (UTC) when the consumption occurred.
CONSUMPTION	NUMBER (38,2)	Amount of consumption, measured in credits.
FORECASTED_CONSUMPTION	NUMBER (38,2)	Predicted consumption based on the anomaly-detecting algorithm, measured in credits.
UPPER_BOUND	NUMBER (38,2)	Predicted highest level of consumption based on the anomaly-detecting algorithm, measured in credits. Consumption levels above this value are considered an anomaly.
LOWER_BOUND	NUMBER (38,2)	Predicted lowest level of consumption based on the anomaly-detecting algorithm, measured in credits. Consumption levels below this value are considered an anomaly.
IS_ANOMALY	BOOLEAN	If `TRUE`, consumption was identified as a cost anomaly because it has gone outside the range of the upper and lower bound.
CURRENCY_TYPE	VARCHAR	Unit of measure for the consumption, which is always `CREDITS`.
ANOMALY_ID	VARCHAR	System-generated identifier.

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

The following example identifies anomalies in the current account based on consumption between January 1, 2024, and March 31, 2024:

CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_ACCOUNT_ANOMALIES_IN_CREDITS(
  '2024-01-01', '2024-03-31');

Copy