- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
QUERY_
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 QUERY_ACCELERATION_HISTORY view in the ORGANIZATION_USAGE schema is used for querying the history of queries accelerated by the query acceleration service. The information returned by the view includes the warehouse name and the credits consumed by the query acceleration service.
Columns¶
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_NAME | VARCHAR | Name of the account (user-defined). |
| ACCOUNT_LOCATOR | VARCHAR | Account locator of the account (system-defined). |
| REGION | VARCHAR | Name of the region where the account is located. |
| USAGE_DATE | DATE | Date (in the UTC time zone) when queries were accelerated. |
| CREDITS_USED | NUMBER | Number of credits billed for the query acceleration service during the USAGE_DATE. |
| WAREHOUSE_ID | NUMBER | Internal/system-generated identifier for the warehouse that the queries were executed on. |
| WAREHOUSE_NAME | VARCHAR | Name of the warehouse that the queries were executed on. |
Usage notes¶
- Latency for the view may be up to 24 hours (1 day).