Schema:: ORGANIZATION_USAGE

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 using Snowpipe within a specified date range. The function returns the history of data loaded and credits billed for your entire Snowflake account.

Columns¶

Column Name	Data Type	Description
ORGANIZATION_NAME	VARCHAR	Name of the organization where the usage took place.
ACCOUNT_NAME	TEXT	Name of the account where the usage took place.
ACCOUNT_LOCATOR	TEXT	Name of the account locator.
REGION	VARCHAR	Name of the region where the account is located.
USAGE_DATE	DATE	Date (in the UTC time zone) of this usage history record.
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. Displays NULL for the internal (hidden) pipe object used to refresh the metadata for an external table.
CREDITS_USED	NUMBER	Number of credits billed for Snowpipe data loads during the USAGE_DATE.
BYTES_INSERTED	VARIANT	Number of bytes loaded during the USAGE_DATE.
FILES_INSERTED	VARIANT	Number of files loaded during the USAGE_DATE.

Usage notes¶

Latency for the view may be up to 24 hours (1 day).
The data is retained for 365 days (1 year).