- 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) 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, POSTGRES, 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: