Rates last reviewed: June 2025.

How BigQuery Pricing Works

BigQuery offers two main pricing models: on-demand (pay per TB scanned) and flat-rate slot reservations (fixed monthly fee for a pool of slots). Storage is charged separately. This page explains BigQuery editions, slot crossover math, streaming pricing, long-term storage, and the real-world cost traps Google users often miss.

BigQuery Editions: Standard, Enterprise, Enterprise Plus

BigQuery is offered in Standard, Enterprise, and Enterprise Plus editions. Standard covers essential analytics, Enterprise adds advanced security and BI integrations, and Enterprise Plus unlocks higher availability, governance, and dedicated support. Edition choice can affect slot pricing, feature availability, and the range of supported enterprise workloads.

On-demand pricing

On-demand charges per TB scanned by queries. A commonly cited list price is $6.25 / TB scanned, though exact regional prices and discounts vary. On-demand is simple and often cheapest for unpredictable or low-volume workloads.

Flat-rate slots (reservations)

Flat-rate pricing lets you buy slots (a unit of query processing capacity) for a fixed monthly price. For example, a 100-slot reservation may be priced at ~$2,000/month in some public references. Slots are cost-effective when you have consistent, high-volume query workloads and want predictable billing.

Example crossover point

If on-demand is $6.25/TB scanned and a 100-slot reservation costs $2,000/month, the break-even point is around 320 TB/month.

320 TB × $6.25/TB = $2,000

Below that volume, on-demand is usually more economical. Above 320 TB/month, slot reservations are often the better choice if your workload is steady and high-concurrency.

Storage costs

BigQuery storage rates are typically modeled at around $0.02/GB/month for active storage and $0.01/GB/month for long-term storage. Storage in BigQuery includes table storage and long-term storage for data older than 90 days.

What drives your BigQuery bill

1. Large scan volumes

On-demand costs scale directly with TB scanned. Poorly selective queries or scanning wide non-partitioned tables will increase costs quickly. Use partitioning, clustering, and LIMIT/filtering to reduce scanned bytes.

2. Repeated exploratory queries

Ad-hoc exploration that re-scans large datasets frequently can dominate costs. Encourage query practices that reuse result tables, use cached results, and limit full-table scans.

3. Over-provisioned slot reservations

Buying more slots than necessary wastes money. Monitor slot utilization and right-size reservations. BigQuery flexibility like flex slots and reassignment can help for seasonal demand.

4. Streaming inserts and frequent small writes

High-frequency streaming inserts can increase costs and operational overhead. Batch small writes where possible and use streaming wisely.

Streaming insert pricing

Streaming inserts are billed separately from query scanning and storage. The standard rate is $0.01 per 200 MB of streaming data. If you are ingesting many small rows or streaming high event volumes, this cost can add up quickly and should be modeled separately from your query charges.

Long-term storage optimization

BigQuery automatically downgrades table storage to long-term storage after 90 days of no modifications. Long-term storage is typically priced around $0.01/GB-month, roughly half of active storage. This can be a meaningful optimization for data that is written and then mainly queried rather than updated frequently.

Practical tips

• Use partitioned tables and query pruning to reduce scanned bytes.
• Cache intermediate results or materialized views for repeated analytics.
• Compare on-demand vs slots at your typical monthly TB scanned; use slots for steady high-volume workloads.
• Monitor query costs with audit logs and cost dashboards to find hotspots.

Example: quick cost snapshot

Illustrative: scanning 100 TB/month on on-demand at $6.25/TB = $625/month. A 100-slot reservation at $2,000/month would be more expensive in this low-volume example; slots become competitive above a certain TB/month threshold depending on your query shape and concurrency.

Estimate your BigQuery costs

Because BigQuery has dual pricing, model both on-demand scanned TB and a reservation baseline to see which is cheaper for your workload.

Estimate your BigQuery bill with your actual TB scanned and slot usage

Note: Public list prices are illustrative. Always confirm exact rates and available commitment options in Google Cloud Console or your Google account representative.