- Schema:
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 the transfer. COPY, COPY_FILES, DATA_LAKE, EXTERNAL_ACCESS, EXTERNAL_FUNCTION, INTERNAL, REPLICATION, SNOWPARK_CONTAINER_SERVICES. |
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;