架构：: ACCOUNT_USAGE、READER_ACCOUNT_USAGE

METERING_HISTORY 视图¶

ACCOUNT_USAGE 架构中的 METERING_HISTORY 视图可用于返回账户在过去 365 天（1 年）内的每小时 Credit 使用情况。

列¶

列名称	数据类型	描述
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`：请参阅 Snowflake Cortex AI Functions (including LLM functions)、Cortex Analyst 和 Document AI。 `ARCHIVE_STORAGE_RETRIEVAL_FILE_PROCESSING`: See 存储生命周期策略计费. `ARCHIVE_STORAGE_WRITE`: See 存储生命周期策略计费. `AUTO_CLUSTERING`：请参阅自动聚类。 `BACKUP`: See Snapshots for backups and immutable storage. `COPY_FILES`：请参阅 COPY FILES。 `DATA_QUALITY_MONITORING`：请参阅数据质量和数据指标函数简介。 `HYBRID_TABLE_REQUESTS`：请参阅混合表。 `MATERIALIZED_VIEW`：请参阅使用物化视图。 `OPENFLOW_COMPUTE_BYOC`: See Openflow BYOC 成本和扩展注意事项. `OPENFLOW_COMPUTE_SNOWFLAKE`: See Openflow Snowflake 部署成本和扩展注意事项. `PIPE`：请参阅 Snowpipe。 `QUERY_ACCELERATION`：请参阅 Using the Query Acceleration Service (QAS)。 `REPLICATION`：请参阅跨多个账户的复制和故障转移简介。 `SEARCH_OPTIMIZATION`：请参阅 Search optimization service。 `SENSITIVE_DATA_CLASSIFICATION`：请参阅敏感数据分类。 `SERVERLESS_ALERTS`：请参阅根据 Snowflake 中的数据设置警报。 `SERVERLESS_TASK`：请参阅任务简介。 `SNOWPARK_CONTAINER_SERVICES`：请参阅 Snowpark Container Services。 `SNOWPIPE_STREAMING`: See Snowpipe Streaming. `STORAGE_LIFECYCLE_POLICY_EXECUTION`: Compute cost to apply a policy on a target table and expire or archive rows (policy execution). See 存储生命周期策略. `TELEMETRY_DATA_INGEST`: See 事件表概述. `TRUST_CENTER`：请参阅 Trust Center。 `WAREHOUSE_METERING`：请参阅仓库概述。 `WAREHOUSE_METERING_READER`：请参阅管理阅读者账户。
START_TIME	TIMESTAMP_LTZ	发生使用的日期以及起始时间（以本地时区为准）。
END_TIME	TIMESTAMP_LTZ	发生使用的日期以及结束时间（以本地时区为准）。
ENTITY_ID	NUMBER	Internal/system-generated identifier for the entity type. When the service type is `COPY_FILES`, this column shows the ID of the database, schema, or stage from which files are copied. `NULL` when the SERVICE_TYPE is one of the Openflow types.
ENTITY_TYPE	VARCHAR	Type of Snowflake resource that consumed credits, such as WAREHOUSE, TASK, or TABLE. Note that TABLE is used for all table-like objects.
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. When the service type is one of the Openflow types, the column shows NULL.
DATABASE_ID	NUMBER	Internal/system-generated identifier of the database associated with the resource of type `ENTITY_TYPE`. Contains a NULL value when the resource isn't associated with a specific database (for example, a warehouse or compute pool).
DATABASE_NAME	VARCHAR	Name of the database associated with the resource of type `ENTITY_TYPE`. Contains a NULL value when the resource isn't associated with a specific database.
SCHEMA_ID	NUMBER	Internal/system-generated identifier of the schema associated with the resource of type `ENTITY_TYPE`. Contains a NULL value when the resource isn't associated with a specific schema.
SCHEMA_NAME	VARCHAR	Name of the schema associated with the resource of type `ENTITY_TYPE`. Contains a NULL value when the resource isn't associated with a specific schema.
CREDITS_USED_COMPUTE	NUMBER	仓库、无服务器计算和 Openflow 资源在一小时内使用的 credit 数。
CREDITS_USED_CLOUD_SERVICES	NUMBER	一小时内用于云服务的 credit 数。如果 SERVICE_TYPE 是 Openflow 类型之一，则始终为 `0`。
CREDITS_USED	NUMBER	一小时内用于账户的 Credit 总数。这是 CREDITS_USED_COMPUTE 和 CREDITS_USED_CLOUD_SERVICES 的总和。此值未考虑云服务的调整，因此可能大于实际使用的 Credit的量。
BYTES	NUMBER	当服务类型为 `auto_clustering` 时，表示在 START_TIME 和 END_TIME 窗口内重聚类的字节数。当服务类型为 `pipe` 时，表示在 START_TIME 和 END_TIME 窗口内插入的字节数。当服务类型为 `SNOWPIPE_STREAMING` 时，指示在 START_TIME 和 END_TIME 窗口期间迁移的字节数。当服务类型为 `COPY_FILES` 时，将在数据库级别聚合列。
ROWS	NUMBER	当服务类型为 `auto_clustering` 时，表示在 START_TIME 和 END_TIME 窗口内重聚类的行数。当服务类型为 `SNOWPIPE_STREAMING` 时，表示在 START_TIME 和 END_TIME 窗口内迁移的行数。
FILES	NUMBER	当服务类型为 `pipe` 时，表示在 START_TIME 和 END_TIME 窗口内加载的文件数。当服务类型为 `SNOWPIPE_STREAMING` 时，此值为 null。当服务类型为 `COPY_FILES` 时，将在数据库级别聚合列。

使用说明¶

此视图的延迟时间可能长达 180 分钟（3 小时），CREDITS_USED_CLOUD_SERVICES 列除外。CREDITS_USED_CLOUD_SERVICES 的延迟时间最长可达 6 小时。
在显示 SNOWPIPE_STREAMING 的 Credit 用量时，延迟时间可能长达 12 小时。