How does BigQuery on-demand pricing work?

On-demand pricing charges $6.25 per TB of data scanned by queries (first 1 TB per month is free). You pay nothing when idle and there are no commitments. Costs scale linearly with query volume, making it ideal for unpredictable or growing workloads. Using partitioned and clustered tables can dramatically reduce bytes scanned.

What are BigQuery Editions?

Editions (Standard, Enterprise, Enterprise Plus) use slot-based pricing where you purchase compute capacity in 100-slot increments on autoscale, 1-year, or 3-year commitments. This provides predictable costs regardless of data scanned. Enterprise adds features like CMEK and BI Engine, while Enterprise Plus adds multi-region failover.

What is the difference between active and long-term storage?

Tables or partitions not modified for 90 consecutive days are automatically reclassified as long-term storage at roughly 50% of the active storage price. There is no change in performance or availability. The estimator lets you specify your active vs. long-term split to give a more accurate storage cost.

BigQuery Cost Estimator

StorageGCP

Estimate BigQuery costs for on-demand and Editions pricing with storage tiers, streaming inserts, and break-even analysis.

BigQuery Configuration

Example Presets

Pricing Model

Query Data Scanned (TB/month)

First 1 TB/month free. $6.25 per TB after that.

Storage

Active Storage (GB)

$0.02/GB-month

Long-term Storage (GB)

$0.01/GB-month (90+ days untouched)

Ingestion & API

Streaming Inserts (GB/month)

$0.012 per 200 MB (min 1 KB/row)

Storage API Reads (TB/month)

$1.10 per TB read

Raw Output

Output will appear here...

About This Tool

The BigQuery Cost Estimator calculates monthly Google BigQuery costs for both on-demand and Editions (Standard, Enterprise, Enterprise Plus) pricing models. It factors in storage costs for active and long-term data, query compute costs by bytes scanned or slot-hours consumed, streaming insert fees, and Storage API read charges. The tool includes a break-even analysis that shows when switching from on-demand to Editions flat-rate pricing becomes more economical based on your query volume. It is the go-to calculator for data analysts and engineers planning BigQuery deployments at any scale.

When to Use This Tool

•Estimating on-demand query costs for a business intelligence team running 500 queries per day scanning 5 TB total.
•Calculating the break-even point between on-demand per-TB pricing and Enterprise Edition slot reservations.
•Modeling the cost impact of enabling streaming inserts versus batch loading for a real-time analytics pipeline.
•Projecting long-term storage savings as data ages past 90 days and automatically moves to the long-term storage rate.

Frequently Asked Questions

How does BigQuery on-demand pricing work?: On-demand pricing charges $6.25 per TB of data scanned by queries (first 1 TB per month is free). You pay nothing when idle and there are no commitments. Costs scale linearly with query volume, making it ideal for unpredictable or growing workloads. Using partitioned and clustered tables can dramatically reduce bytes scanned.
What are BigQuery Editions?: Editions (Standard, Enterprise, Enterprise Plus) use slot-based pricing where you purchase compute capacity in 100-slot increments on autoscale, 1-year, or 3-year commitments. This provides predictable costs regardless of data scanned. Enterprise adds features like CMEK and BI Engine, while Enterprise Plus adds multi-region failover.
What is the difference between active and long-term storage?: Tables or partitions not modified for 90 consecutive days are automatically reclassified as long-term storage at roughly 50% of the active storage price. There is no change in performance or availability. The estimator lets you specify your active vs. long-term split to give a more accurate storage cost.

Disclaimer: This tool runs entirely in your browser. No data is sent to our servers. Always verify outputs before using them in production. AWS, Azure, and GCP are trademarks of their respective owners.