Schema:

ORGANIZATION_USAGE

DATA_TRANSFER_DAILY_HISTORY view

The DATA_TRANSFER_DAILY_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 Amazon Web Services (AWS), Google Cloud Platform, 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 of data transfer for all accounts in your Snowflake organization.

Columns

Column NameData TypeDescription
SERVICE_TYPEVARCHAREither DATA_TRANSFER or INTERNAL_DATA_TRANSFER.
ORGANIZATION_NAMEVARCHARName of the organization .
ACCOUNT_NAMEVARCHARName of the account.
USAGE_DATEDATEDate (in the UTC time zone) in which the usage took place.
TB_TRANSFEREDFLOATNumber of terabytes transferred during the USAGE_DATE.
REGIONVARCHARID of the Snowflake Region where the account is located.
ACCOUNT_LOCATORVARCHARAccount locator for the account.

Usage notes

  • Latency for the view may be up to 24 hours.