ANOMALY_INSIGHTS!GET_TOP_WAREHOUSES_ON_DATE

Returns warehouses with the highest change in consumption for a given date, determined by comparing the specified day with the previous day. Helps investigate account-level and organization-level cost anomalies.

Syntax

SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_TOP_WAREHOUSES_ON_DATE(
  '<date>',
  <number_of_warehouses>,
  <account_name> )
Copy

Arguments

'date'

Specifies the date for which you want to return consumption data.

Data type: DATE

number_of_warehouses

Limits the number of warehouses returned by the method. For example, if you specify 5, the method returns only the top five warehouses in terms of change in consumption.

Data type: NUMBER

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 warehouse data for the specified account. You must specify the account name, not the account locator.

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

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

Returns

Returns a table with the following columns:

Column name

Data type

Description

WAREHOUSE_NAME

VARCHAR

Name of the warehouse.

WAREHOUSE_ID

NUMBER

System-generated identifier of the warehouse.

CONSUMPTION

NUMBER (38,9)

Amount of consumption on the specified day in credits.

COST_CHANGE

NUMBER (38,9)

Difference between consumption on the specified day and the previous day.

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.

  • You cannot use this method to return a currency as the unit of measure for the consumption.

Example

Returns the top six warehouses in the organization in terms of change in consumption when comparing August 9, 2024, and August 10, 2024.

CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_TOP_WAREHOUSES_ON_DATE('2024-08-10', 6, NULL);
Copy

Returns the top five warehouses in the current account in terms of change in consumption when comparing December 8, 2024, and December 9, 2024.

CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_TOP_WAREHOUSES_ON_DATE(
  '2024-12-09', 5, CURRENT_ACCOUNT_NAME());
Copy

Returns the top three warehouses in the account my_acct in terms of change in consumption when comparing November 8, 2024, and November 9, 2024.

CALL SNOWFLAKE.LOCAL.ANOMALY_INSIGHTS!GET_TOP_WAREHOUSES_ON_DATE(
  '2024-11-09', 5, 'my_acct');
Copy
Language: English