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.

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).

Back to top