Schema:
ACCOUNT_USAGE

PIPE_USAGE_HISTORY View

This Account Usage view can be used to query the history of data loaded into Snowflake tables using Snowpipe within the last 365 days (1 year). The view displays the history of data loaded and credits billed for your entire Snowflake account.

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.
START_TIME TIMESTAMP_LTZ Start of the time range in which data loading took place.
END_TIME TIMESTAMP_LTZ End of the time range in which data loading took place.
CREDITS_USED FLOAT Number of credits billed for Snowpipe data loads during the START_TIME and END_TIME window.
BYTES_INSERTED VARIANT 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 180 minutes (3 hours).