Schema:

ACCOUNT_USAGE

DATA_TRANSFER_HISTORY View

This Account Usage view 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 or Microsoft Azure into the other cloud provider’s network) and/or geographical region within the last 365 days (1 year). The view includes the history for your entire Snowflake account.

Columns

Column Name

Data Type

Description

START_TIME

TIMESTAMP_LTZ

Start of the specified time range in which the data transfer took place.

END_TIME

TIMESTAMP_LTZ

End of the specified time range in which the data transfer took place.

SOURCE_CLOUD

TEXT

Name of the cloud provider where the data transfer originated: AWS or Azure.

SOURCE_REGION

TEXT

Region where the data transfer originated.

TARGET_CLOUD

TEXT

Name of the cloud provider where the data was sent: AWS or Azure.

TARGET_REGION

TEXT

Region where the data was sent.

BYTES_TRANSFERRED

VARIANT

Number of bytes transferred during the START_TIME and END_TIME window.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).