Extensions

Cost Lens

for BigQuery

New

Know what your query costs before you run it.

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.

Available worldwide ES · EN Local currency v2.4.2
Cost Lens panel in the BigQuery console showing US$2.52, 412 GB and grade D with six findings

What it does

Every query, with its price in plain sight

Live cost next to Run

Bytes to be read, estimated cost and an A–F optimization grade as you type.

Today's and this month's spend

A top bar with your estimated spend for the day and month, plus the free TiB used.

Optimization score

From 0 to 100, with concrete findings and the exact line where the problem is.

Expand SELECT *

Turn SELECT * into the real column list in one click. Undo with Ctrl+Z.

Storage cost

Monthly table cost comparing logical vs. physical billing, with a hint when the other model is cheaper.

A brake before expensive runs

Asks for confirmation before running queries above your cost threshold.

Post-run diagnosis

Slot time, shuffle, spill, billed bytes and the Editions equivalent.

Repository & snippets

Save the queries you choose with a name, tags and notes, in a library with search, filters and favorites.

Export & share

Text, Markdown, PDF or JSON. Back up everything and import files from your team.

How it works

Ready in a minute, nothing to set up

Add it to Chrome

One click in the Chrome Web Store. It's free and needs no account.

Open BigQuery and write your SQL

Next to the Run button you see the bytes, the estimated cost and the optimization grade as you type.

Fix it and keep what works

Follow the findings to cut the cost and save your best queries as snippets in your local repository.

Findings

It tells you why your query is expensive

Cost Lens checks your SQL before you run it and flags the patterns that make BigQuery expensive, with the exact line to fix them.

  • HighSELECT * reads every column
  • MediumTable read without a filter (WHERE)
  • MediumOR in the JOIN condition
  • MediumFunction that prevents partition pruning
  • MediumWildcard table without _TABLE_SUFFIX
  • LowORDER BY without LIMIT in the final result
  • LowRepeated CTEs

In action

See it working

Everything stays in your browser

No servers, no analytics, no data sent to anyone.

Never runs queries

It only reads what the console already shows. You decide when to press Run.

For teams worldwide

English and Spanish, local currency and configurable regional prices.

FAQ

How is the cost calculated?

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.

Does it send my queries anywhere?

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 *".

Which permissions does it need?

Only local storage and access to console.cloud.google.com, where it shows the cost and the panel.

Which languages and currencies does it support?

English and Spanish, following your browser language, with the local currency of your choice.

Can I share queries with my team?

Yes. Export a query as text, Markdown, PDF or JSON, back up your whole library and import files from your teammates.

Stop guessing what each query costs

Add to Chrome
Hi, can I help?