- Schema:
LOAD_HISTORY View¶
This Account Usage view enables you to retrieve the history of data loaded into tables using the COPY INTO <table> command within the last 365 days (1 year). The view displays one row for each file loaded.
Note
This view does not return the history of data loaded using Snowpipe. For this historical information, query the COPY_HISTORY view instead.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
TABLE_ID |
NUMBER |
Internal/system-generated identifier for the target table |
TABLE_NAME |
TEXT |
Name of target table |
SCHEMA_ID |
NUMBER |
Internal/system-generated identifier for the schema of the target table |
SCHEMA_NAME |
TEXT |
Schema of target table |
CATALOG_ID |
NUMBER |
Internal/system-generated identifier for the database of the target table |
CATALOG_NAME |
TEXT |
Database of target table |
FILE_NAME |
TEXT |
Name of source file |
LAST_LOAD_TIME |
TIMESTAMP_LTZ |
Date and time (in the UTC time zone) of the load record |
STATUS |
TEXT |
Status: |
ROW_COUNT |
NUMBER |
Number of rows loaded from the source file |
ROW_PARSED |
NUMBER |
Number of rows parsed from the source file |
FIRST_ERROR_MESSAGE |
TEXT |
First error of the source file |
FIRST_ERROR_LINE_NUMBER |
NUMBER |
Line number of the first error |
FIRST_ERROR_CHARACTER_POSITION |
NUMBER |
Position of the first error character |
FIRST_ERROR_COL_NAME |
TEXT |
Column name of the first error |
ERROR_COUNT |
NUMBER |
Number of error rows in the source file |
ERROR_LIMIT |
NUMBER |
If the number of error reach this limit, then abort |
Usage Notes¶
Latency for the view may be up to 90 minutes.
The view only includes COPY INTO commands that executed to completion, with or without errors. No record is added if the transaction is rolled back, for example, or if the ON_ERROR = ABORT_STATEMENT copy option is included in the COPY INTO <table> statement and a detected error in a data file aborts the load operation.
When including a WHERE clause that references the
LAST_LOAD_TIME
column, you can specify any day of the week. For example, April 1, 2016 was a Friday; however, specifying Sunday instead does not affect the query results:WHERE last_load_time > 'Sun, 01 Apr 2016 16:00:00 -0800'
Examples¶
Retrieve records for the 10 most recent COPY INTO commands executed:
SELECT file_name, last_load_time FROM snowflake.account_usage.load_history ORDER BY last_load_time DESC LIMIT 10;