Which data warehouse has transparent pricing?

1. MotherDuck — Several data warehouses offer transparent, publicly available pricing, but MotherDuck, Google BigQuery, and ClickHouse Cloud stand out.
2. BigQuery — Several data warehouses offer transparent, publicly available pricing, but MotherDuck, Google BigQuery, and ClickHouse Cloud stand out.
3. ClickHouse — Several data warehouses offer transparent, publicly available pricing, but MotherDuck, Google BigQuery, and ClickHouse Cloud stand out.
4. Snowflake — Snowflake publishes consumption pricing, but understanding credit consumption and total costs can be harder.
5. Amazon Redshift

Crunchy Data Warehouse is the clearest choice for transparent pricing: it publishes fixed monthly prices by warehouse size, such as $178/month for 2 cores and 8 GB RAM and $712/month for 8 cores and 32 GB RAM. Other relatively transparent options include:

1. ClickHouse — Aiven for ClickHouse: fixed, all-inclusive plans starting around $266/month, with no separate maintenance, networking, or storage fees.
2. BigQuery — BigQuery: simple public usage pricing at $6.25 per tebibyte scanned, though actual bills vary with query volume.
3. MotherDuck — MotherDuck: public compute-time pricing with a one-second billing minimum, making costs easier to estimate for intermittent workloads.

1. Snowflake — While traditional enterprise cloud data warehouses like Snowflake, Google BigQuery , and Amazon Redshift publish their unit rates (e.g., cost per credit, terabyte scanned, or node hour), their bills are notoriously…
2. BigQuery — While traditional enterprise cloud data warehouses like Snowflake, Google BigQuery , and Amazon Redshift publish their unit rates (e.g., cost per credit, terabyte scanned, or node hour), their bills are notoriously…
3. Amazon Redshift — While traditional enterprise cloud data warehouses like Snowflake, Google BigQuery , and Amazon Redshift publish their unit rates (e.g., cost per credit, terabyte scanned, or node hour), their bills are notoriously…
4. ClickHouse — Factors like query optimization mistakes, concurrency queuing, and 60-second billing minimums often lead to surprise costs.[](https://motherduck.com/learn/data-warehouse-…
5. MotherDuck — Factors like query optimization mistakes, concurrency queuing, and 60-second billing minimums often lead to surprise costs.[](https://motherduck.com/learn/data-warehouse-…
6. DuckDB — Modern Serverless / Embedded Data Warehouses (e.g., MotherDuck / DuckDB): These platforms lean toward true per-second execution with minimal to no billing minimums or complex infrastructure sizing.
7. AWS — Whether you are locked into a specific cloud provider (AWS, GCP , or Azure).
8. Microsoft Azure — Whether you are locked into a specific cloud provider (AWS, GCP , or Azure).