Pipe usage history and COPY history views: New column¶
Attention
This behavior change is in the 2025_05 bundle.
For the current status of the bundle, refer to Bundle History.
When this behavior change bundle is enabled, the following views include a new column, BYTES_BILLED:
- ACCOUNT_USAGE.PIPE_USAGE_HISTORY
- ORGANIZATION_USAGE.PIPE_USAGE_HISTORY
- INFORMATION_SCHEMA.PIPE_USAGE_HISTORY
- ACCOUNT_USAGE.COPY_HISTORY
- ORGANIZATION_USAGE.COPY_HISTORY
- INFORMATION_SCHEMA.COPY_HISTORY
| Column name | Data type | Description |
|---|---|---|
BYTES_BILLED | NUMBER | Represents the number of bytes Snowpipe uses for billing purposes, providing clearer visibility into Snowpipe’s cost implications directly within these history views. |
The new BYTES_BILLED column aims to enhance transparency and simplify cost analysis for Snowpipe usage. This new column provides a direct metric for the data volume that is considered for billing, making it easier to monitor and manage Snowpipe-related expenses. Users can now directly query these views to gain insights into the billed data volume for their pipe and copy operations.
Ref: 2045