This Information Schema view enables you to retrieve the history of data loaded into tables using the COPY INTO <table> command. The view displays one row for each file loaded.

Note

The view only includes COPY INTO commands that executed to completion, with or without errors.

## Columns¶

Column Name

Data Type

Description

SCHEMA_NAME

TEXT

Schema of target table

FILE_NAME

TEXT

Name of source file

TABLE_NAME

TEXT

Name of target table

TIMESTAMP_LTZ

STATUS

TEXT

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 errors reaches this limit, then abort

## Usage Notes¶

• Snowflake retains historical data for COPY INTO commands executed within the previous 14 days only.

• The historical data for COPY INTO commands is removed from the system when a table is dropped.

• This view returns an upper limit of 10,000 rows. To avoid this limitation, use the COPY_HISTORY function (Information Schema) or view (Account Usage).

• 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 the history of data loaded into the MYDB.PUBLIC.MYTABLE table since April 1, 2016, assuming that April 1 occurred within the previous 14 days:

USE DATABASE mydb;


Retrieve records for the 10 most recent COPY INTO commands executed against the MYDB database:
USE DATABASE mydb;