- 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.
While the feature is in preview, we may make some behavior changes. We will notify you about any changes before implementing them.
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 data transfer operation. ‘COPY’, ‘REPLICATION’, EXTERNAL_FUNCTION’. |
Usage Notes¶
Latency for the view may be up to 24 hours (1 day).
The data is retained for 365 days (1 year).