Schema:

ACCOUNT_USAGE

WAREHOUSE_LOAD_HISTORY view¶

This Account Usage view can be used to analyze the workload on your warehouse within a specified date range.

See also:

WAREHOUSE_METERING_HISTORY view

Columns¶

Note

For the output columns of this view, the query load value is the ratio of the total execution time (in seconds) of all queries in a specific state in an interval by the total time (in seconds) for that interval.

For example, if 276 seconds was the total time for 4 queries in a 5 minute (300 second) interval, then the query load value is 276 / 300 = 0.92.

Column Name

Data Type

Description

START_TIME

TIMESTAMP_LTZ

The start of the specified time range (in the UTC time zone) in which the warehouse usage took place.

END_TIME

TIMESTAMP_LTZ

The end of the specified time range (in the UTC time zone) in which the warehouse usage took place.

WAREHOUSE_ID

NUMBER

Internal/system-generated identifier for the warehouse.

WAREHOUSE_NAME

TEXT

Name of the warehouse.

AVG_RUNNING

NUMBER(38,9)

Query load value for queries executed.

AVG_QUEUED_LOAD

NUMBER(38,9)

Query load value for queries queued because the warehouse was overloaded.

AVG_QUEUED_PROVISIONING

NUMBER(38,9)

Query load value for queries queued because the warehouse was being provisioned.

AVG_BLOCKED

NUMBER(38,9)

Query load value for queries blocked by a transaction lock.

Usage notes¶

  • Latency for the view may be up to 180 minutes (3 hours).

  • Load history is shown in 5-minute intervals.