- 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. |
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)