Schema:

ORGANIZATION_USAGE

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 data transfer operation. COPY, COPY_FILES, 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).