- Schema:
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. |