BigQuery Cost Tools
3 free tools · no login · nothing uploaded
BigQuery is unusual among cloud services in that the thing you pay for — bytes scanned, or slot-time — is not the thing you write. A query that looks cheap can read a hundred times more data than it returns, and a partition filter that looks like it prunes can silently fail to.
That gap between what a query says and what it costs is where these tools live. The query analyzer reads the structure of a statement and reports what drives its cost: the columns actually read, the pruning that works and the pruning that only appears to, and the ten-megabyte-per-table floor that makes small queries cost more than their size suggests. Without a schema it prints no dollar figure at all, because a made-up byte count is worse than an honest gap.
The slot advisor answers the other BigQuery question — whether Editions capacity would beat on-demand — by simulating your real hourly demand against every baseline increment, refilling the idle hours the extraction query does not return, and charging them. Baseline slots bill through quiet hours; a model that skips them overstates savings, which is the easiest way to get this decision wrong.
The query pack is the third piece: copy-paste SQL for the cost questions people ask during an incident. Most of it is free to run, because metadata queries scan no billable bytes.
3 tools in bigquery cost
BigQuery Slot vs On-Demand Advisor
Find out whether BigQuery Editions slots would actually save you money.
Paste 30 days of hourly aggregates from your own INFORMATION_SCHEMA and get a modelled recommendation: stay on-demand, or commit N baseline slots with autoscale. Runs entirely in your browser — nothing is uploaded.
BigQuery Query Cost Analyzer
What this query actually costs — computed, not guessed.
Paste a query and get the structural findings that drive its cost: columns read, partition pruning that works and pruning that only looks like it does, and the 10 MB-per-table floor. Add your schema or a dry-run figure and it prices the query exactly. No login, nothing uploaded.
BigQuery FinOps Query Pack
Copy-paste SQL for the cost questions you ask at 4pm during an incident.
A maintained library of INFORMATION_SCHEMA and billing-export queries — one page per question, each with what it returns, how to read it, and what it costs to run. Most of them are free to run because metadata queries scan no bytes.
Other categories
A query at a time, or every query continuously.
Finitizer profiles your whole BigQuery estate — the queries driving scan volume, the tables charging long-term storage at active rates, the reservations that stopped fitting — and ships an AI-rewritten cheaper version of each expensive query.