Schema:

ACCOUNT_USAGE

COPY_FILES_HISTORY view¶

This Account Usage view includes information about compute credit usage, number of bytes copied, and number of files copied for the following operations:

  • Using COPY FILES to copy files from a source stage to an output stage.

  • Cloning named internal stages.

See also:

COPY FILES , CREATE <object> … CLONE

Columns¶

Column name

Data type

Description

DATABASE_ID

NUMBER

ID of the database from which the files are copied. You can map this to the ENTITY_ID in the METERING_HISTORY view view.

DATABASE_NAME

VARCHAR

Name of the database from which the staged files are copied.

SUB_SERVICE_TYPE

VARCHAR

Type of service that is copying files, which can be one of the following:

JOB_ROOT_ENTITY_ID

NUMBER

Entity ID for the root job; varies by SUB_SERVICE_TYPE. For COPY STAGE FILES, indicates the ID of the stage from which files are copied. For SCHEMA CLONE, indicates the schema ID. For DATABASE CLONE, indicates the database ID.

START_TIME

TIMESTAMP_LTZ

The date and beginning of the hour (in the local time zone) in which the copy operation took place.

END_TIME

TIMESTAMP_LTZ

The date and end of the hour (in the local time zone) in which the copy operation took place.

CREDITS_USED

NUMBER

Number of compute credits used by warehouses and serverless compute resources between the START_TIME and END_TIME.

BYTES_COPIED

NUMBER

Number of bytes copied from the root entity (stage, schema, or database) between the START_TIME and END_TIME.

FILES_COPIED

NUMBER

Number of files copied from the root entity (stage, schema, or database) between the START_TIME and END_TIME.