To monitor virtual warehouse performance in Snowsight, the correct approach is using theQUERY_HISTORYview or its Snowsight equivalent under the Activity section. QUERY_HISTORY provides detailed metrics on execution time, queueing, credit consumption, compilation time, and warehouse utilization for every executed query. By analyzing this information, users can diagnose issues such as concurrency bottlenecks, under-sized warehouses, long-running queries, or excessive I/O.
SHOW WAREHOUSES returns metadata about warehouse configurations (size, state, scaling policy) but does not provide performance data. LOAD_HISTORY tracks COPY INTO operations only and is not representative of general warehouse workload. DESCRIBE WAREHOUSE shows configuration details but no runtime or historical performance metrics.
Thus, the most accurate and complete way to assess warehouse performance—particularly execution delays, queuing, or excessive credit usage—is by using QUERY_HISTORY.
==================
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit