- Schema:
QUERY_ACCELERATION_ELIGIBLE view¶
This Account Usage view can be used to identify queries that are eligible for the query acceleration service (QAS).
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
QUERY_ID |
TEXT |
Internal/system-generated identifier for the SQL statement. |
QUERY_TEXT |
TEXT |
Text of the SQL statement. |
START_TIME |
TIMESTAMP_LTZ |
Statement start time. |
END_TIME |
TIMESTAMP_LTZ |
Statement end time. |
WAREHOUSE_NAME |
TEXT |
Name of the warehouse that the query executed on. |
WAREHOUSE_SIZE |
TEXT |
Size of the warehouse when this statement executed. |
ELIGIBLE_QUERY_ACCELERATION_TIME |
NUMBER |
Amount of query execution time (in seconds) eligible for the query acceleration service. |
UPPER_LIMIT_SCALE_FACTOR |
NUMBER |
Upper limit scale factor for the given query. |
QUERY_HASH |
TEXT |
The hash value computed based on the canonicalized SQL text. |
QUERY_HASH_VERSION |
NUMBER |
The version of the logic used to compute |
QUERY_PARAMETERIZED_HASH |
TEXT |
The hash value computed based on the parameterized query. |
QUERY_PARAMETERIZED_HASH_VERSION |
NUMBER |
The version of the logic used to compute |
Usage notes¶
Latency for the view may be up to 180 minutes (three hours).
Query acceleration is supported for the following SQL commands:
SELECT
INSERT
CREATE TABLE AS SELECT (CTAS)
COPY INTO <table>
For more information about query eligibility, see Eligible queries.
This view only includes eligible queries that have not been accelerated. If you have enabled the query acceleration service and previously QAS-eligible queries are now accelerated, they are not included in this view.
Examples¶
Identify the warehouses with the most queries eligible in a given period of time for the query acceleration service:
SELECT warehouse_name, COUNT(query_id) AS num_eligible_queries
FROM SNOWFLAKE.ACCOUNT_USAGE.QUERY_ACCELERATION_ELIGIBLE
WHERE start_time >= '2024-06-01 00:00'::TIMESTAMP
AND end_time <= '2024-06-07 00:00'::TIMESTAMP
GROUP BY warehouse_name
ORDER BY num_eligible_queries DESC;
For more example queries, see Identifying queries and warehouses with the QUERY_ACCELERATION_ELIGIBLE view.