BigQuery Pricing Overview
- Queries (on-demand) - $6.25 per TiB - The first 1 TiB per month is free.
- Pricing | BigQuery: Cloud Data Warehouse | Google Cloud
- Quotas and limits | BigQuery | Google Cloud
- Estimate and control costs | BigQuery | Google Cloud
- Pricing | BigQuery: Cloud Data Warehouse | Google Cloud
- Estimate and control costs | BigQuery | Google Cloud
Compute / Slot Pricing
BigQuery slot capacity:
- is available in 3 editions: Standard, Enterprise, and Enterprise Plus.
- applies to query costs, including BigQuery ML, DML, and DDL statements.
- does not apply to storage costs or BI Engine costs.
- does not apply to streaming inserts and using the BigQuery Storage API.
- can leverage the BigQuery autoscaler.
- is billed per second with a one minute minimum.
Region - Mumbai (asia-south1)
| Edition | Commitment model | Hourly cost | Monthly costs (50 slots) | Details |
|---|---|---|---|---|
| Standard | Pay as you go | $0.046 / slot hour | $1656 = Rs. 1,41,865.46 | No commitment. Billed per second with a 1 minute minimum |
| Enterprise | Pay as you go | $0.069 / slot hour | $2484 = Rs. 2,12,798.19 | Billed per second with a 1 minute minimum |
| 1 yr commit | $0.0552 / slot hour | $1,987 = Rs. 1,70,243 (20% cheaper than pay-as-you-go) | Billed for 1 year | |
| 3 yr commit | $0.0414 / slot hour | $1,490 = Rs. 1,27,683 (40% cheaper than pay-as-you-go) | Billed for 3 years | |
| Enterprise Plus | Pay as you go | $0.115 / slot hour | $4,140 = Rs. 3,54,674 | Billed per second with a 1 minute minimum |
| 1 yr commit | $0.092 / slot hour | $3,312 = Rs. 2,83,739 | Billed for 1 year | |
| 3 yr commit | $0.069 / slot hour | $2,484 = Rs. 2,12,804 | Billed for 3 years |
Standard vs Enterprise
Standard is suitable for ad-hoc and development workloads, while Enterprise adds security, governance, and machine learning features. Enterprise Plus provides the highest level of availability, recovery, and compliance capabilities, ideal for mission-critical applications.
1. BigQuery Standard Edition
Best for: Small to mid-sized teams or projects needing core features without enterprise-level compliance or guarantees.
- SLAs: No formal SLA
- Performance: Standard performance
- Security:
- Basic IAM
- No customer-managed encryption keys (CMEK)
- Data locality: Multi-region or single-region
- Data sharing: Supported via authorized views & datasets
- Backup/Restore: Time travel up to 7 days
- Autoscaling: Yes
- Key Limits:
- No support for fine-grained capacity commitments
2. BigQuery Enterprise Edition
Best for: Medium to large businesses needing SLAs, advanced security, and compliance.
- SLAs: 99.9% availability SLA
- Performance: Enhanced reliability, availability
- Security:
- CMEK supported
- VPC Service Controls integration
- Compliance: Supports industry certifications like HIPAA, FedRAMP, etc.
- Data locality: Regional control
- Time travel: Up to 7 days
- Reservations: Flex slots, capacity commitments