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.

TIMESTAMP_LTZ

Date and time (in the UTC time zone) of the load record. For bulk data loads, this is the time when the file started loading. For Snowpipe, this is the time when the file finished loading.

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.

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_ID

NUMBER

Internal/system-generated identifier for the target table.

TABLE_NAME

TEXT

Name of the target table.TABLE_NAME

TABLE_SCHEMA_ID

NUMBER

Internal, Snowflake-generated identifier of the schema for the table.

TABLE_SCHEMA_NAME

TEXT

Name of the schema in which the target table resides.

TABLE_CATALOG_ID

NUMBER

Internal/system-generated identifier for the database of the table.

TABLE_CATALOG_NAME

TEXT

Name of the database in which the target table resides.

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.

TIMESTAMP_LTZ

Date and time when the INSERT request for the file loaded through the pipe was received; NULL for COPY statement loads.

FIRST_COMMIT_TIME

TIMESTAMP_LTZ

Date and time when the first chunk of the file is committed. Snowpipe may load a file in multiple chunks that are separately committed.

## Usage Notes¶

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

• 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.

## Examples¶

Retrieve records for the 10 most recent COPY INTO commands executed:

select * from snowflake.account_usage.copy_history