How is Utilizable Warehouse Size calculated?

Field Meaning

This field tells you the smallest warehouse that could have fully handled the query’s workload. It’s always capped at the size of the warehouse the query actually ran on.

Field Calculation

The calculation uses the QUERY_LOAD_PERCENT field from the query_history view, which shows how much of a warehouse’s compute a query actually used. That value is translated into the number of nodes consumed, then mapped back to the equivalent warehouse size.

Example
A query on a Large warehouse (8 nodes) with QUERY_LOAD_PERCENT = 45 is equivalent to using about 4 nodes. Four nodes align with a Medium warehouse, so the utilizable warehouse size is Medium.