Data Engineering
Data Warehouse Cost Calculator
Select warehouse and enter monthly query volume and storage to compute estimated monthly cost with optimization recommendations.
Calculations run locally in your browserTool
Example — Representative default scenario — BigQuery on-demand · 12 TiB queried · 12 TB stored.
Query cost
$75.00
12 TiB × $6.25/TiB
Storage cost
$245.76
12 TB × $0.020/GB
Total monthly
$320.76
BigQuery
Cost/TB queried
$26.73
blended rate
About this tool
Data Warehouse Cost Calculator
The Data Warehouse Cost Calculator estimates monthly costs from query volume and storage across BigQuery, Snowflake, and Redshift with optimization recommendations.
• Estimate BigQuery monthly cost before migrating to on-demand pricing
• Compare Snowflake vs BigQuery cost at a given query volume
• Calculate warehouse cost as a percentage of data team budget
• Model cost savings from partition pruning reducing TB scanned
Affiliate disclosure
Developer-friendly cloud infrastructure. DigitalOcean provides cloud compute, networking, and managed databases with predictable pricing.
Store data on DigitalOcean
External site · Independent provider · We may receive a commission · Not a recommendation
FAQ
What does this tool tell you?
The Data Warehouse Cost Calculator estimates monthly costs from query volume and storage across BigQuery, Snowflake, and Redshift with optimization recommendations.
What affects the result most?
BigQuery: $6.25/TiB on-demand (raised from $5 in July 2023; first 1 TiB/month free) or capacity-based Editions; $0.02/GB-month storage. Snowflake: per-credit pricing, 1 credit ≈ $2-4 depending on edition and region. Redshift: per-node per-hour (RA3) or Redshift Serverless (per-RPU-hour).
How should I use the result?
The calculation is deterministic — the same inputs always produce the same output — so the most useful workflow is to vary one input at a time and see which factor moves the result most. That tells you where to focus your attention before committing to a decision.
Related tools