- Schema:
DATA_
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, 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 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 | VARCHAR | Name of the cloud provider where the data transfer originated: Amazon Web Services (AWS), Google Cloud Platform, or Microsoft Azure. |
| SOURCE_REGION | VARCHAR | Region where the data transfer originated. |
| TARGET_CLOUD | VARCHAR | Name of the cloud provider where the data was sent: AWS, Google Cloud Platform, or Microsoft Azure. |
| TARGET_REGION | VARCHAR | Region where the data was sent. |
| BYTES_TRANSFERRED | VARIANT | Number of bytes transferred during the START_TIME and END_TIME window. |
| TRANSFER_TYPE | VARCHAR | Type of operation that caused the transfer. COPY, COPY_FILES, DATA_LAKE, EXTERNAL_ACCESS, EXTERNAL_FUNCTION, INTERNAL, REPLICATION, SNOWPARK_CONTAINER_SERVICES. |
Usage notes¶
- Latency for the view may be up to 120 minutes (2 hours).
-
If you want to reconcile the data in this view with a corresponding view in the ORGANIZATION USAGE schema, you must first set the timezone of the session to UTC. Before querying the Account Usage view, execute: