Live cost next to Run
Bytes to be read, estimated cost and an A–F optimization grade as you type.
Cost Lens
for BigQuery
Cost Lens shows the estimated cost of every BigQuery query right inside the Google Cloud console, next to the Run button, and tells you why a query is expensive. It also saves your best SQL as snippets in a local repository.
What it does
Bytes to be read, estimated cost and an A–F optimization grade as you type.
A top bar with your estimated spend for the day and month, plus the free TiB used.
From 0 to 100, with concrete findings and the exact line where the problem is.
Turn SELECT * into the real column list in one click. Undo with Ctrl+Z.
Monthly table cost comparing logical vs. physical billing, with a hint when the other model is cheaper.
Asks for confirmation before running queries above your cost threshold.
Slot time, shuffle, spill, billed bytes and the Editions equivalent.
Save the queries you choose with a name, tags and notes, in a library with search, filters and favorites.
Text, Markdown, PDF or JSON. Back up everything and import files from your team.
How it works
One click in the Chrome Web Store. It's free and needs no account.
Next to the Run button you see the bytes, the estimated cost and the optimization grade as you type.
Follow the findings to cut the cost and save your best queries as snippets in your local repository.
Findings
Cost Lens checks your SQL before you run it and flags the patterns that make BigQuery expensive, with the exact line to fix them.
In action
No servers, no analytics, no data sent to anyone.
It only reads what the console already shows. You decide when to press Run.
English and Spanish, local currency and configurable regional prices.
It uses the dry run the BigQuery console already performs, the table's storage figures and the prices you configure (on-demand, Editions and storage). These are estimates: the billed amount may differ because of cache, per-table minimums, free tiers, discounts or regional pricing.
No. Everything runs and is stored in your browser: no servers, no analytics and no data sharing. The extension never runs or sends queries; it only writes into the editor when you press "Expand *".
Only local storage and access to console.cloud.google.com, where it shows the cost and the panel.
English and Spanish, following your browser language, with the local currency of your choice.
Yes. Export a query as text, Markdown, PDF or JSON, back up your whole library and import files from your teammates.
Google, Google Cloud and BigQuery are trademarks of Google LLC. Cost Lens is an independent extension and is not affiliated with, sponsored or endorsed by Google. Developed by valladares.org.