Schema:

ORGANIZATION_USAGE

ANOMALIES_IN_CURRENCY_DAILY view

This Organization Usage view provides insights into whether cost anomalies occurred in accounts in the organization.

Each row provides the consumption of an account on a specific day, and whether that consumption was a cost anomaly.

Columns

Column nameData typeDescription
DATEDATEDay in UTC when the consumption occurred.
ANOMALY_IDVARCHARSystem-generated identifier.
IS_ANOMALYBOOLEAN

If true, consumption has been identified as a cost anomaly because it has gone outside the range of the upper and lower bound.

ORGANIZATION_NAMEVARCHARName of the organization.
ACCOUNT_NAMEVARCHARName of the account where consumption occurred.
ACCOUNT_LOCATORVARCHARAccount locator of the account where consumption occurred.
REGIONVARCHARSnowflake region where the account is located.
ACTUAL_VALUENUMBERAmount of consumption measured in CURRENCY.
CURRENCYVARCHARUnit of measure for the consumption.
UPPER_BOUNDNUMBER

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

LOWER_BOUNDNUMBER

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

FORECASTED_VALUENUMBER

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

Usage notes

Latency for the view might be up to 8 hours.