Data Governance, Data Warehouse, Databricks, Databricks Sql, Data Observability.
waiting_for_compute_duration_ms, count(*) as count_queries_waiting_for_compute, warehouse_id from query_history where end_window = ( select max(end_window) from query_history ) and metrics.query_compilation_start_timestamp - metrics.overloading_queue_start_timestamp > 1000 group by warehouse_id