Schema:

ACCOUNT_USAGE

DATA_TRANSFER_HISTORY View¶

This Account Usage view can be used to query the history of data transferred from Snowflake tables into a different cloud storage provider’s network (i.e. from Snowflake on AWS, Google Cloud Platform, or Microsoft Azure into the other cloud provider’s network) and/or geographical region within the last 365 days (1 year). The view includes the history for your entire Snowflake account.

Columns¶

Column Name

Data Type

Description

START_TIME

TIMESTAMP_LTZ

Start of the specified time range in which the data transfer took place.

END_TIME

TIMESTAMP_LTZ

End of the specified time range in which the data transfer took place.

SOURCE_CLOUD

TEXT

Name of the cloud provider where the data transfer originated: Amazon Web Services (AWS), Google Cloud Platform, or Microsoft Azure.

SOURCE_REGION

TEXT

Region where the data transfer originated.

TARGET_CLOUD

TEXT

Name of the cloud provider where the data was sent: AWS, Google Cloud Platform, or Microsoft Azure.

TARGET_REGION

TEXT

Region where the data was sent.

BYTES_TRANSFERRED

VARIANT

Number of bytes transferred during the START_TIME and END_TIME window.

TRANSFER_TYPE

VARCHAR

Type of operation that caused transfer. COPY, COPY_FILES, EXTERNAL_ACCESS, EXTERNAL_FUNCTION, REPLICATION.

Usage Notes¶

  • Latency for the view may be up to 120 minutes (2 hours).

  • If you want to reconcile the data in this view with a corresponding view in the ORGANIZATION USAGE schema, you must first set the timezone of the session to UTC. Before querying the Account Usage view, execute:

    ALTER SESSION SET TIMEZONE = UTC;
    
    Copy