- Schema:
QUERY_ACCELERATION_ELIGIBLE View¶
This Account Usage view can be used to identify queries that are eligible for the query acceleration service.
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. 1 |
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. 1 |
QUERY_PARAMETERIZED_HASH_VERSION |
NUMBER |
The version of the logic used to compute |
- 1(1,2,3,4)
This column is present only when the 2023_06 behavior change bundle is enabled. This column is part of the query hash feature.
Usage Notes¶
Latency for the view may be up to 180 minutes (3 hours).
Query acceleration is supported for the following SQL commands:
SELECT
INSERT (when the statement contains a SELECT statement)
CREATE TABLE AS SELECT (CTAS)