- Schema:
DATA_
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 | VARCHAR | Name of the account where the usage took place. |
| ACCOUNT_LOCATOR | VARCHAR | 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 | VARCHAR | 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 | VARCHAR | Region where the data transfer originated. |
| TARGET_CLOUD | VARCHAR | Name of the cloud provider for the platform where the data was sent: AWS, Google Cloud Platform, or Microsoft Azure. |
| TARGET_REGION | VARCHAR | 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).