Schema:
ACCOUNT_USAGE

COPY_HISTORY View

This Account Usage view can be used to query Snowflake data loading history for the last 365 days (1 year). The view displays load activity for both COPY INTO <table> statements and continuous data loading using Snowpipe. The view avoids the 10,000 row limitation of the LOAD_HISTORY View.

Columns

Column Name Data Type Description
FILE_NAME TEXT Name of the source file and relative path to the file.
STAGE_LOCATION TEXT Name of the stage where the source file is located.
LAST_LOAD_TIME TIMESTAMP_LTZ Date and time of the load record.
ROW_COUNT NUMBER Number of rows loaded from the source file.
ROW_PARSED NUMBER Number of rows parsed from the source file;``NULL`` if STATUS is ‘LOAD_IN_PROGRESS’.
FILE_SIZE NUMBER Size of the source file loaded through the pipe; NULL for COPY statement loads.
FIRST_ERROR_MESSAGE TEXT First error of the source file.
FIRST_ERROR_LINE_NUMBER NUMBER Line number of the first error.
FIRST_ERROR_CHARACTER_POS NUMBER Position of the first error character.
FIRST_ERROR_COLUMN_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.
STATUS TEXT Status: loaded, load failed, or partially loaded.
TABLE_CATALOG_NAME TEXT Name of the database in which the target table resides.
TABLE_SCHEMA_NAME TEXT Name of the schema in which the target table resides.
TABLE_NAME TEXT Name of the target table.
PIPE_CATALOG_NAME TEXT Name of the database in which the pipe resides.
PIPE_SCHEMA_NAME TEXT Name of the schema in which the pipe resides.
PIPE_NAME TEXT Name of the pipe defining the load parameters; NULL for COPY statement loads.
PIPE_RECEIVED_TIME TIMESTAMP_LTZ Date and time when the INSERT request for the file loaded through the pipe was received; NULL for COPY statement loads.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).
  • The view only displays objects for which the current role for the session has been granted access privileges.