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)