warehouse_queries
warehouse_queries provides information about queries running on each warehouse.
The following fields are provided in warehouse_queries:
| Field | Description |
|---|---|
| WAREHOUSE_ID | ID of the warehouse. |
| WAREHOUSE_NAME | Name of the warehouse. |
| QUERY_ID | ID of the query. |
| STATE | State of the query (e.g., PENDING, RUNNING, FINISHED). |
| EST_COSTS_SLOTS | Estimated cost slots for the query. |
| ALLOCATE_SLOTS | Allocated slots for the query. |
| QUEUED_WAIT_SECONDS | Time in seconds the query waited in the queue. |
| QUERY | The SQL query string. |
| QUERY_START_TIME | Start time of the query. |
| QUERY_END_TIME | End time of the query. |
| QUERY_DURATION | Duration of the query. |
| EXTRA_MESSAGE | Extra message. |