Schema:

ACCOUNT_USAGE

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.

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: loaded, load failed, or partially loaded.

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.

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

  • 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 * FROM snowflake.account_usage.load_history
  ORDER BY last_load_time DESC
  LIMIT 10;