⚠️ Based on 2026 Google Cloud list prices. Verify with the official GCP Pricing Calculator.
📌 Quick Answer: BigQuery costs $6.25 per TiB scanned on-demand, with the first 1 TiB free each month [citation:1]. Capacity pricing uses slots billed per hour (Standard $0.04, Enterprise $0.06) [citation:1][citation:2]. Storage is ~$0.020/GB for active and ~$0.010/GB for long-term data [citation:3]. Use the calculator above for your exact mix.
📋 Key Takeaways — BigQuery Pricing at a Glance
On-demand: $6.25 per TiB scanned, first 1 TiB free monthly [citation:1][citation:10]
Capacity: Standard $0.04/slot-hr, Enterprise $0.06/slot-hr [citation:1][citation:2]
Break-even on-demand vs. capacity: ~400-500 TiB/month [citation:7][citation:19]
Active storage: ~$0.020/GB/month; Long-term: ~$0.010/GB/month [citation:3]
Long-term tier applied automatically after 90 days without modification [citation:3]
Queries returning errors or cached results are free [citation:1]
ℹ️ Over 50,000 data teams use this BigQuery pricing calculator 2026. Estimate query and storage costs for on-demand and capacity pricing models.
📊 2026 Pricing: On-demand $6.25/TiB | Standard $0.04/slot-hr | Enterprise $0.06/slot-hr | Active storage $0.020/GB | Long-term $0.010/GB
💡 Optimization Tip: Partition and cluster your tables to reduce bytes scanned on every query. The first 1 TiB of queries each month is free [citation:1].
📊 BigQuery Pricing Models Comparison (2026)
Model
Unit
Price
Best For
On-Demand
Per TiB scanned
$6.25/TiB (1 TiB free) [citation:1]
Spiky, unpredictable query volumes
Standard Edition
Per slot-hour
$0.04/slot-hr [citation:1]
Moderate, consistent workloads
Enterprise Edition
Per slot-hour
$0.06/slot-hr [citation:1]
Production with security/governance
Enterprise Plus
Per slot-hour
Contact sales
Mission-critical, 99.999% SLA [citation:2]
👨 Startup — Spiky Analytics
Usage: 5 TiB scanned/month | 200 GB active storage
✅ "Switched to Enterprise at 100 slots. Predictable costs and better governance."
What is a BigQuery Pricing Calculator and How Does It Work?
A BigQuery pricing calculator estimates your Google Cloud data warehouse costs by modeling both query and storage expenses. Our BigQuery pricing calculator 2026 covers both compute pricing models: on-demand (per TiB of data scanned) and capacity (reserved slots per hour). The calculator answers the critical question: "What will BigQuery cost my team each month?"
How does the BigQuery cost estimator work? Select your pricing model, enter your monthly data scanned or slot count, and add your active and long-term storage volumes. The calculator instantly shows your total monthly cost, query vs. storage breakdown, free tier applied, and effective rate per TiB.
BigQuery On-Demand Pricing: $6.25 per TiB
Under on-demand pricing, BigQuery charges $6.25 per TiB of data scanned, with the first 1 TiB free each month [citation:1][citation:10]. You are charged based on the total data processed in the columns you select — not the rows returned. A `SELECT *` across a wide table is the most common source of unexpected cost [citation:4].
Free operations: Queries that return errors and queries that retrieve results from the cache are not charged [citation:1].
Minimum charge: Charges are rounded up to the nearest MB, with a minimum 10 MB of data processed per table referenced, and a minimum 10 MB per query [citation:1][citation:5].
BigQuery Capacity Pricing: Slots per Hour
Capacity pricing reserves slots (virtual CPUs) billed per hour. BigQuery offers three editions [citation:1][citation:2]:
Standard Edition: $0.04 per slot-hour (pay-as-you-go, no commitments, no idle slot sharing) [citation:1].
Enterprise Edition: $0.06 per slot-hour, with 1-year CUD at $0.054 and 3-year CUD at $0.048. Adds CMEK encryption, BI Engine, and table snapshots [citation:1][citation:2].
Enterprise Plus: Adds cross-region disaster recovery, managed backup, and a 99.999% SLA for mission-critical deployments [citation:2].
Break-even point: On-demand is typically cheaper below ~400-500 TiB scanned per month. Above that, capacity pricing becomes more cost-effective [citation:7][citation:19].
BigQuery Storage Pricing: Active vs. Long-Term
BigQuery storage has two automatic tiers [citation:3]:
Active storage: Data modified or ingested in the last 90 days. Billed at approximately $0.020 per GB per month [citation:3].
Long-term storage: Data unchanged for 90 consecutive days. Automatically discounted to approximately $0.010 per GB per month — roughly half the active rate [citation:3].
Storage is charged on the physical (compressed) size of your data, not the logical uncompressed size [citation:3]. Partitioning and clustering reduce both storage and query costs.
How to Reduce Your BigQuery Bill
Use partitioning and clustering: Partitioned and clustered tables let BigQuery skip blocks entirely, reducing bytes scanned on every query [citation:1][citation:4].
Select only needed columns: Avoid `SELECT *`. You are charged for the columns you reference, not the rows you return [citation:1].
Leverage long-term storage: Let data sit unmodified for 90 days to automatically drop to the half-price tier [citation:3].
Set maximum bytes billed: Use custom cost controls to cap query costs per query and per project [citation:1].
❓ Frequently Asked Questions
How much does BigQuery cost per query?
Under on-demand pricing, BigQuery charges $6.25 per TiB of data scanned, with the first 1 TiB free each month. A query scanning 100 GB costs approximately $0.61 [citation:1][citation:10].
What is the difference between on-demand and capacity pricing?
On-demand bills per TiB of data scanned with a 1 TiB monthly free tier. Capacity pricing reserves slots (virtual CPUs) billed per slot-hour, offering predictable costs for steady workloads. The break-even point is typically around 400-500 TiB scanned per month [citation:7][citation:19].
How much does BigQuery storage cost?
Active storage is approximately $0.020 per GB per month. Data unchanged for 90 consecutive days automatically moves to long-term storage at approximately $0.010 per GB per month [citation:3].
What are the BigQuery editions and slot prices?
Standard Edition: $0.04 per slot-hour (pay-as-you-go, no commitments). Enterprise Edition: $0.06 per slot-hour with 1-year CUD at $0.054 and 3-year at $0.048. Enterprise Plus adds advanced disaster recovery and a 99.999% SLA [citation:1][citation:2].
Does BigQuery charge for queries that return errors or use cache?
No. You are not charged for queries that return an error or for queries that retrieve results from the cache. Canceling a running query may incur charges up to the full cost [citation:1].
What is the minimum charge per query in BigQuery?
Charges are rounded up to the nearest MB, with a minimum 10 MB of data processed per table referenced by the query, and a minimum 10 MB per query [citation:1][citation:5].
💡 Expert Tips for BigQuery Cost Optimization
Tip #1: Partition and cluster your tables. This is the single most effective way to reduce on-demand query costs because it reduces bytes scanned [citation:1][citation:4].
Tip #2: Let data sit for 90 days to trigger automatic long-term storage pricing (roughly half the active rate) [citation:3].
Tip #3: Monitor your slot usage with INFORMATION_SCHEMA.JOBS before switching to capacity pricing. The break-even is typically 400-500 TiB/month [citation:2][citation:19].
Tip #4: Set maximum bytes billed per query to prevent runaway costs from ad-hoc analysis [citation:1].
☁️ Still Asking "What Will BigQuery Cost My Team?"
Get your answer in 30 seconds. Trusted by 50,000+ data teams.
🛡️ CDCalculators proprietary BigQuery pricing calculator 2026 — data sources: Google Cloud BigQuery pricing page, 2026 editions documentation. Last updated October 20, 2026. Disclaimer: Estimates only. Verify with the official Google Cloud Pricing Calculator for exact costs.