ANOMALY_INSIGHTS!GET_DAILY_CONSUMPTION_ANOMALY_DATA

Returns daily consumption for a specific account or the entire organization, and identifies whether that consumption is considered a cost anomaly.

Syntax

SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_DAILY_CONSUMPTION_ANOMALY_DATA(
  '<start_date>',
  '<end_date>',
  <account_name> )
Copy

Arguments

'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

account_name

Specifies an expression that determines the account(s) for which consumption data is returned. You can specify the following values:

  • 'account_name': Returns data for the specified account. You must specify the account name, not the account locator.

  • CURRENT_ACCOUNT_NAME(): Returns data for the current account.

  • NULL: Returns data for the entire organization, not a specific account.

Returns

Returns a table with the following columns:

Column name

Data type

Description

USAGE_DATE

DATE

Day in UTC when the consumption occurred.

CONSUMPTION

NUMBER

Amount of consumption measured in CURRENCY_TYPE.

FORECASTED_CONSUMPTION

NUMBER

Predicted consumption based on the anomaly-detecting algorithm, measured in CURRENCY_TYPE.

UPPER_BOUND

NUMBER

Predicted highest level of consumption based on the anomaly-detecting algorithm, measured in CURRENCY_TYPE. Consumption levels above this value are considered an anomaly.

LOWER_BOUND

NUMBER

Predicted lowest level of consumption based on the anomaly-detecting algorithm, measured in CURRENCY_TYPE. Consumption levels below this value are considered an anomaly.

IS_ANOMALY

BOOLEAN

If true, consumption has been 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. For information about why the unit of measure is credits or a currency, see Unit of measure for cost data.

ANOMALY_ID

VARCHAR

System-generated identifier.

Access control requirements

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

  • ACCOUNTADMIN role

  • GLOBALORGADMIN role

Usage notes

To return data for a different account or the entire organization, you must execute this method from the organization account or an ORGADMIN-enabled account.

Example

Identify organization-level anomalies based on consumption between January 1, 2024, and March 31, 2024:

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

Identify anomalies in the current account based on consumption between January 1, 2024, and March 31, 2024:

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

Identify anomalies in the account prod_acct1 based on consumption between January 1, 2024, and March 31, 2024:

CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_DAILY_CONSUMPTION_ANOMALY_DATA(
  '2024-01-01', '2024-03-31', 'prod_acct1');
Copy
Language: English