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.

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)