RealCloudCost

google cloud / analytics / bigquery

What BigQuery really costs

Scanning 10 TiB a month and storing 1.5 TB in BigQuery costs $0.00 a month, or $0 a year.

google cloud list prices · checked 17 november 2026 · sources

Start from a typical setup then change anything in the form below

spec sheet us-10tibchecked 2026-11-17

BigQuery US

  1. 01Queries (TiB scanned) [1]$0.00largest
  2. 02Storage [1]$0.00largest
  3. 03Streaming inserts [1]$0.00largest
Total, a month$0.00

a year $0

setup formyou write in blue

Your setup change any box, the sheet follows

the sheet on the right updates as you writethe sheet above updates as you write

Why the bill is bigger than expected

You pay for what queries read, not what they return. On-demand queries are billed per TiB of the columns they scan. Selecting only the columns you need, and partitioning tables by date, can cut the bill several times over.

Old data costs half. A table or partition not changed for 90 days moves to long-term storage at about half the price, automatically, with no change in speed.

Physical storage can be cheaper. Physical billing charges for compressed bytes at about twice the per-GB price. It pays off when your data compresses more than about 2 to 1. Enter the physical size if you choose it.

Sources

  1. [1]BigQuery on-demand analysis, storage and streaming insert prices, with the free tier. Google Cloud Billing Catalog API, read 2026-11-17.
  2. [2]The page to check it against. cloud.google.com/bigquery/pricing, read 2026-11-17.

On-demand pricing, list prices in USD before tax. Stored is the average over the month, in GiB. The free tier is 1 TiB of queries and 10 GiB of storage a month. Not counted: capacity pricing (editions and slots), the Storage Write API, BI Engine, BigQuery ML and data transfer. The calculator runs in your browser; nothing you type is sent anywhere.