DATA_TRANSFER_DAILY_HISTORY view¶

Organization Usage performance

When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in Performance (Organization Usage): bound every scan on history views, list columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.

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 Name	Data Type	Description
SERVICE_TYPE	VARCHAR	Either `DATA_TRANSFER` or INTERNAL_DATA_TRANSFER.
ORGANIZATION_NAME	VARCHAR	Name of the organization .
ACCOUNT_NAME	VARCHAR	Name of the account.
USAGE_DATE	DATE	Date (in the UTC time zone) in which the usage took place.
TB_TRANSFERED	FLOAT	Number of terabytes transferred during the USAGE_DATE.
REGION	VARCHAR	ID of the Snowflake Region where the account is located.
ACCOUNT_LOCATOR	VARCHAR	Account locator for the account.

Usage notes¶

Latency for the view may be up to 24 hours.