- Schemas:
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:
Columns¶
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,2) |
Average number of queries executed. |
AVG_QUEUED_LOAD |
NUMBER(38,2) |
Average number of queries queued because the warehouse was overloaded. |
AVG_QUEUED_PROVISIONING |
NUMBER(38,2) |
Average number of queries queued because the warehouse was being provisioned. |
AVG_BLOCKED |
NUMBER(38,2) |
Average number of 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.