BigQuery, Snowflake and Databricks Cost Tools
Free tools for BigQuery, Snowflake and Databricks: what drives the bill and what to fix first.
7 free tools · 38 reference pages · no login
Pick by question
- What is driving my BigQuery bill and what should I fix first?BigQuery Cost Check
- Should I move to Editions slots, and how many?BigQuery Slot vs On-Demand Advisor
- Why is this BigQuery query expensive, and what did optimizing it save?BigQuery Query Cost Analyzer
- Is there ready-made SQL for my BigQuery cost question?BigQuery FinOps Query Pack
- What would my BigQuery workload cost on Snowflake or Databricks?Warehouse Cost Translator
- What could I save by changing a Snowflake warehouse's auto-suspend?Snowflake Cost Calculator
- What does a Databricks workload cost with the cloud VMs included?Databricks Cost Calculator
Tools
Calculator
Snowflake Cost Calculator
See what changing a Snowflake warehouse's auto-suspend setting could save, at list price or your own credit price.
Databricks Cost Calculator
See the full cost of a Databricks workload, including the cloud VMs underneath, at list or your own DBU rate.
Reads your own data
BigQuery Cost Check
Run three read-only queries in your BigQuery console and get a priced list of fixes in about ten minutes.
BigQuery Slot vs On-Demand Advisor
Find out whether BigQuery Editions slots would cost less than on-demand pricing, using 30 days of your own job history.
BigQuery Query Cost Analyzer
Paste a BigQuery query to see what makes it expensive, or compare its bytes before and after an optimization.
Warehouse Cost Translator
See what your BigQuery workload would cost moved to Snowflake or Databricks, from your own job history.
What drives the cost
Data platforms bill in units that are not the work you asked for: bytes or slot time on BigQuery, credits for an awake warehouse on Snowflake, and DBUs plus the VMs under them on Databricks.
BigQuery: you pay for what a query reads
A query that looks cheap can read a hundred times more data than it returns, and a partition filter can silently fail to prune. The Cost Check reads your whole bill with three read-only queries and ranks what to fix first. The query analyzer shows what drives one query's cost. Without a schema it shows no dollar figure rather than guess.
BigQuery: slots or on-demand
The slot advisor tests your real hourly demand against each baseline size. Baseline slots bill through quiet hours too, and a model that skips them overstates the saving.
Query pack: SQL for a cost incident
The query pack is copy-paste SQL for the questions people ask during a cost incident. Most queries cost under a cent to run.
Snowflake: you pay while it is awake
A warehouse that serves a steady trickle of short queries never gets to sleep, so it bills a full day for a couple of hours of work. That idle time is often the biggest line on the bill, and a credit report does not show it.
Databricks: two bills for one job
Databricks bills DBUs, and your cloud provider bills the VMs underneath, except on serverless, where the DBU rate includes them. The same notebook also costs several times more on All-Purpose compute than on Jobs compute.
List rates, or your own
The Snowflake and Databricks calculators default to each vendor's published list rates and accept your own negotiated rate.
Reference libraries
Pages behind these tools, one per column, recipe, pattern or SKU. They are worth reading on their own and they are what the tools above check against.
BigQuery FinOps query pack 24 pages
Copy-paste INFORMATION_SCHEMA queries for common BigQuery bill questions: cache hit rate, cost by label, spend anomalies, slot contention.
BigQuery cost anti-patterns 14 pages
Query shapes that scan more than needed, each with what it costs and the rewrite that fixes it.
Other categories
Model one warehouse here. Measure BigQuery continuously.
Finitizer does this for BigQuery today. Snowflake and Redshift support is on the way.
See how Finitizer works