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