Writing

Notes on warehouse cost and what actually fits

Field notes from building ducklens, an open cost-fit scorer for Snowflake and BigQuery. What the query data says about how much of a bill actually needs a warehouse, and what it does not.

July 2026 · 8 min read

I ran ducklens over 69 million real Snowflake queries

Snowflake published telemetry for about 70 million real queries, including how much each one spilled to disk. Spill is what decides whether a query needs a warehouse or a single machine. Here is what the whole trace says once you account for the disk a real box has.

Read ->

More notes soon.