Schema:: ACCOUNT_USAGE

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_HASH`. 1
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 `QUERY_PARAMETERIZED_HASH`. 1

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)