- Schema:
PIPE_USAGE_HISTORY view¶
The PIPE_USAGE_HISTORY view in the ORGANIZATION_USAGE schema can be used to query the history of data loaded into Snowflake tables and Apache Icebergâ„¢ tables using Snowpipe within a specified date range. It includes the history of data loaded and credits billed for your entire Snowflake organization.
Columns¶
Organization-level columns
Column Name |
Data Type |
Description |
---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
ACCOUNT_LOCATOR |
VARCHAR |
System-generated identifier for the account. |
ACCOUNT_NAME |
VARCHAR |
User-defined identifier for the account. |
Additional columns
Column Name |
Data Type |
Description |
---|---|---|
PIPE_ID |
NUMBER |
Internal/system-generated identifier for the pipe used for the data load. Displays NULL if no pipe name was specified in the query. Each row includes the totals for all pipes in use within the time range. |
PIPE_NAME |
TEXT |
Name of the pipe or Iceberg table with automated refresh. Displays NULL for the internal (hidden) pipe object used to refresh the metadata for an external table or Delta-based Iceberg table. |
START_TIME |
TIMESTAMP_LTZ |
Start of the time (in the local time zone) range in which data loading took place. |
END_TIME |
TIMESTAMP_LTZ |
End of the time (in the local time zone) range in which data loading took place. |
CREDITS_USED |
NUMBER |
Number of credits billed for Snowpipe data loads during the START_TIME and END_TIME window. |
BYTES_INSERTED |
FLOAT |
Number of bytes loaded during the START_TIME and END_TIME window. |
FILES_INSERTED |
VARIANT |
Number of files loaded during the START_TIME and END_TIME window. |
Usage notes¶
Latency for the view may be up to 24 hours (1 day).
The data is retained for 365 days (1 year).