- Schema:
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.
Note
The name of this view may change during the preview period or when the organizations feature is generally available.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
SERVICE_TYPE |
VARCHAR |
For this view, the service type is |
ORGANIZATION_NAME |
VARCHAR |
Name of the organization where the usage took place. |
ACCOUNT_NAME |
VARCHAR |
Name of the account where the usage took place. |
ACCOUNT_LOCATOR |
VARCHAR |
Locator for the account where the usage took place. |
USAGE_DATE |
DATE |
The date (in the UTC time zone) in which the usage took place. |
TB_TRANSFERRED |
FLOAT |
Number of bytes transferred during the USAGE_DATE. |
REGION |
VARCHAR |
ID of the Snowflake Region where the account is located. |
Usage Notes¶
Latency for the view may be up to 120 minutes (2 hours).
The data is retained for 365 days (1 year).