EVENT_USAGE_HISTORY View¶

This Account Usage view can be used to query the history of data loaded into Snowflake event tables within the last 365 days (1 year).

The view displays the history of data loaded and credits billed for your entire Snowflake account.

For more information about event tables, refer to Setting up an Event Table.

For more information about logging and tracing, refer to Logging and Tracing Overview.

Columns¶

There are two tables in this section:

The first table defines the columns in the ACCESS_HISTORY view.
The second table defines the fields in the JSON array for the BASE_OBJECTS_ACCESSED, DIRECT_OBJECTS_ACCESSED, and OBJECTS_MODIFIED columns.

Column Name	Data Type	Description
START_TIME	TIMESTAMP_LTZ	Start of the time range (in the UTC time zone) in which data loading took place.
END_TIME	TIMESTAMP_LTZ	End of the time range (in the UTC time zone) in which data loading took place.
CREDITS_USED	FLOAT	Number of credits billed for loading data into the event table during the START_TIME and END_TIME window.
BYTES_INGESTED	NUMBER	Number of bytes of data loaded during the START_TIME and END_TIME window.