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.

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)