- Schema:
DATA_TRANSFER_HISTORY view¶
The DATA_TRANSFER_HISTORY view in the ORGANIZATION_USAGE schema 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 another cloud provider’s network) and/or geographical region within a specified date range. The function returns the history for your entire Snowflake organization.
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization where the usage took place. |
ACCOUNT_NAME |
TEXT |
Name of the account where the usage took place. |
ACCOUNT_LOCATOR |
TEXT |
Name of the account locator. |
REGION |
VARCHAR |
Name of the region where the account is located. |
USAGE_DATE |
DATE |
Date (in the UTC time zone) of this transfer history record. |
SOURCE_CLOUD |
TEXT |
Name of the cloud provider for the platform 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 for the platform 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 usage date. |
TRANSFER_TYPE |
VARCHAR |
Type of operation that caused the transfer. COPY, COPY_FILES, DATA_LAKE, REPLICATION, EXTERNAL_FUNCTION, INTERNAL. |
Usage notes¶
Latency for the view may be up to 24 hours (1 day).
The data is retained for 365 days (1 year).