Schema:: ACCOUNT_USAGE

METERING_DAILY_HISTORY view¶

The METERING_DAILY_HISTORY view in the ACCOUNT_USAGE schema can be used to return the daily credit usage and a cloud services rebate for an account within the last 365 days (1 year).

Columns¶

Column Name	Data Type	Description
SERVICE_TYPE	VARCHAR	Type of service that is consuming credits, which can be one of the following: `AI_SERVICES`: See Snowflake Cortex AISQL (including LLM functions), Cortex Analyst, and Document AI. `AUTO_CLUSTERING`: See Automatic Clustering. `COPY_FILES`: See COPY FILES. `DATA_QUALITY_MONITORING`: See Introduction to data quality and data metric functions. `HYBRID_TABLE_REQUESTS`: See Hybrid tables. `MATERIALIZED_VIEW`: See Working with Materialized Views. `OPENFLOW_COMPUTE_BYOC`: See Understanding Openflow costs. `OPENFLOW_COMPUTE_SNOWFLAKE`: See Understanding Openflow costs. `PIPE`: See Snowpipe. `QUERY_ACCELERATION`: See Using the Query Acceleration Service. `REPLICATION`: See Introduction to replication and failover across multiple accounts. `SEARCH_OPTIMIZATION`: See Search Optimization Service. `SENSITIVE_DATA_CLASSIFICATION`: See Sensitive data classification. `SERVERLESS_ALERTS`: See Setting up alerts based on data in Snowflake. `SERVERLESS_TASK`: See Introduction to tasks. `SNOWPARK_CONTAINER_SERVICES`: See Snowpark Container Services. `SNOWPIPE_STREAMING`: See Snowpipe Streaming. `TRUST_CENTER`: See Trust Center. `WAREHOUSE_METERING`: See Overview of warehouses. `WAREHOUSE_METERING_READER`: See Manage reader accounts.
USAGE_DATE	DATE	Date when the usage took place.
CREDITS_USED_COMPUTE	NUMBER	Number of credits billed for warehouses, serverless compute, and Openflow resources in the day.
CREDITS_USED_CLOUD_SERVICES	NUMBER	Number of credits billed for cloud services in the day. Always `0` when the SERVICE_TYPE is one of the Openflow types.
CREDITS_USED	NUMBER	Sum of CREDITS_USED_COMPUTE and CREDITS_USED_CLOUD_SERVICES.
CREDITS_ADJUSTMENT_CLOUD_SERVICES	NUMBER	Number of credits adjusted for cloud services. This is a negative value (e.g. `-9`).
CREDITS_BILLED	NUMBER	Total number of credits billed for the account in the day. This is a sum of CREDITS_USED_COMPUTE, CREDITS_USED_CLOUD_SERVICES, and CREDITS_ADJUSTMENT_CLOUD_SERVICES.

Usage notes¶

Latency for the view may be up to 180 minutes (3 hours).
If you want to reconcile the data in this view with a corresponding view in the ORGANIZATION USAGE schema, you must first set the timezone of the session to UTC. Before querying the Account Usage view, execute:
ALTER SESSION SET TIMEZONE = UTC;
Copy

Example¶

Usage for cloud services is billed only if the daily consumption of cloud services exceeds 10% of the daily usage of virtual warehouses. This query returns how much of cloud services consumption was actually billed for a particular day, ordered by the highest billed amount.

SELECT
    usage_date,
    credits_used_cloud_services,
    credits_adjustment_cloud_services,
    credits_used_cloud_services + credits_adjustment_cloud_services AS billed_cloud_services
FROM snowflake.account_usage.metering_daily_history
WHERE usage_date >= DATEADD(month,-1,CURRENT_TIMESTAMP())
    AND credits_used_cloud_services > 0
ORDER BY 4 DESC;

Copy