Cost Lens for BigQuery

Cost of every BigQuery query in a top bar, detection of poorly optimized SQL and a local library of queries and snippets.

Cost Lens shows the estimated cost of every BigQuery query right inside the Google Cloud console, before you press Run, and tells you why a query is expensive. WHAT IT DOES • Live cost next to the Run button: bytes to be read, estimated cost and an optimization grade (A–F). • Top bar with today's and this month's estimated spend and your use of the free monthly TiB. • Optimization score (0–100) with concrete findings and the exact line: SELECT *, tables read without WHERE, OR in JOIN conditions, functions that prevent partition pruning, wildcard tables without _TABLE_SUFFIX, ORDER BY without LIMIT, repeated CTEs and more. • A confirmation before running queries above your cost threshold. • Post-run diagnosis from "Execution details": slot time, shuffle, spill, billed bytes and the Editions equivalent. • Repository and snippets: save only the queries you choose, with a name, tags and notes. Runs and spend are tracked for saved queries. • Full-screen library with search, project and tag filters, bulk actions and favorites (★). • Export a query as text, Markdown, PDF or JSON, back up everything and import files from teammates. • English and Spanish (follows your browser language), local currency and configurable prices (on-demand or Editions). PRIVACY Everything runs and is stored in your browser. No servers, no analytics, no data sent to anyone. The extension only reads the BigQuery editor and validator; it never runs, edits or sends queries. NOTES Costs are estimates based on the BigQuery dry run and the prices you configure; the amount billed by Google may differ (cache, 10 MB per-table minimum, discounts, reservations). 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.