Free cost calculator
BigQuery cost calculator
Estimate your monthly BigQuery bill from bytes scanned, slot usage and storage, and see whether on-demand or editions pricing is cheaper for you.
How this is calculated
On-demand = (queries × GB scanned × days, converted to TiB, minus the free 1 TiB) × price per TiB.
Editions = average slots × busy hours × days × price per slot-hour.
Storage = active GiB (minus the free 10 GiB) × active price + long-term GiB × long-term price. 1 TB = 931.3 GiB.
Not included: streaming and Storage Write API ingestion, BI Engine, cross-region transfer, minimum slot commitments and the one-minute slot minimum.
Guides to cut this bill
- BigQuery cost optimization →
- Partitioning and clustering →
- How pruning actually works →
- SQL anti-patterns that cost money →
Comparing platforms instead? Try theside-by-side cost estimatoror see all calculators.
FAQ
How much does a BigQuery query cost?
With on-demand pricing you pay for the bytes each query scans: $6.25 per TiB in US multi-region, with the first 1 TiB each month free. A query that scans 10 GB costs about 6 cents. The dry-run estimate in the console shows the bytes before you run it.
When are BigQuery editions cheaper than on-demand?
Editions charge per slot-hour (about $0.04 Standard, $0.06 Enterprise, $0.10 Enterprise Plus in the US) no matter how many bytes you scan. They win when you scan a lot of data with steady, predictable slot usage. The calculator shows the slot-hours at which both cost the same.
How is BigQuery storage billed?
Logical storage costs about $0.02 per GiB per month while active and halves to $0.01 for tables or partitions not modified for 90 days. The first 10 GiB each month is free. Physical (compressed) billing is an option that can be cheaper for well-compressed data.
Does partitioning really lower the bill?
Yes, on on-demand pricing it is usually the biggest lever. A filter on the partition column prunes partitions before scanning, so a daily query over one partition of a two-year table scans about 1/730 of the bytes.