METERING_HISTORY view¶

SERVICE_TYPE

VARCHAR

Type of service that is consuming credits. The following list includes many, but not all, of the possible service types:

• 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 Openflow BYOC cost and scaling considerations.

• OPENFLOW_COMPUTE_SNOWFLAKE: See Openflow Snowflake Deployment cost and scaling considerations.

• PIPE: See Snowpipe.

• QUERY_ACCELERATION: See Using the Query Acceleration Service (QAS).

• 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.

END_TIME

TIMESTAMP_LTZ

The date and end of the hour (in the local time zone) in which the usage took place.

NAME

VARCHAR

Name of the service type. When the service type is SNOWPIPE_STREAMING, there are two cost entries. One entry is for the name of the Snowflake Table object and the other one is for the colon-separated Snowpipe Streaming, CLIENT_NAME and SNOWFLAKE_PROVIDED_ID. When the service type is COPY_FILES, this column shows the name of the database from which files are copied. NULL when the SERVER_TYPE is one of the Openflow types.

CREDITS_USED_CLOUD_SERVICES

NUMBER

Number of credits used for cloud services in the hour. Always 0 when the SERVICE_TYPE is one of the Openflow types.

BYTES

NUMBER

When the service type is auto_clustering, indicates the number of bytes reclustered during the START_TIME and END_TIME window. When the service type is pipe, indicates the number of bytes inserted during the START_TIME and END_TIME window. When the service type is SNOWPIPE_STREAMING, indicates the number of bytes migrated during the START_TIME and END_TIME window. When the service type is COPY_FILES, columns are aggregated at the database level.

FILES

NUMBER

When the service type is pipe, indicates number of files loaded during the START_TIME and END_TIME window. When the service type is SNOWPIPE_STREAMING, this is null. When the service type is COPY_FILES, columns are aggregated at the database level.