- 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 transfer. ‘COPY’, ‘REPLICATION’, EXTERNAL_FUNCTION’. |
Usage Notes¶
Latency for the view may be up to 120 minutes (2 hours).