Best Cloud Data Warehouse Software in 2026
Cloud warehouse, lakehouse and real-time analytics platforms: Snowflake, Databricks, Google BigQuery, Amazon Redshift, Microsoft Fabric, ClickHouse Cloud, MotherDuck, Firebolt, Starburst and SingleStore.
- Verified 11 Nov 2026Every profile shows where facts came from
- Unknowns labelledGaps are stated, never guessed
- No paid placementNo affiliate links, ratings or reviews
- Not a rankingAlphabetical by default; fit notes, not scores
What is Cloud Data Warehouse Software?
A cloud data warehouse stores and queries large volumes of structured data for analytics. Lakehouses add open file formats and ML on the same data; real-time databases serve sub-second queries on fresh data; federation engines query data where it lives.
Also called Data Warehouse
Nearly every platform here is usage-priced: credits, DBUs, TiB scanned, RPU-hours, capacity units or compute-hours. The same workload can cost very different amounts depending on minimum billing periods, idle time and query patterns.
This category covers enterprise warehouses (Snowflake, Redshift, BigQuery), lakehouses (Databricks, Microsoft Fabric, Starburst), real-time analytics (ClickHouse Cloud, Firebolt, SingleStore) and serverless DuckDB (MotherDuck).
Much of the pricing detail comes from a vendor-published comparison (labelled). Profiles are research aids, not rankings.
Best cloud data warehouse and lakehouse platforms by need.
Shortlists built from what each sourced profile documents, listed alphabetically, not ranked. Open a profile for limits, prices and sources.
Best free cloud data warehouse and lakehouse platforms
5 of 10 profiles document a free plan.
Cloud data warehouse and lakehouse platforms for small businesses
1 of 10 profiles are documented mainly for small and mid-size teams.
Cloud data warehouse and lakehouse platforms for enterprises
9 of 10 profiles are documented for large enterprises.
Cloud Data Warehouse Software compared: browse and filter
Search and filters update this list on the page and do not create new URLs, so every profile stays crawlable and linkable.
Amazon Redshift
Amazon Web Services · AWS data warehouse
AWS's data warehouse, with Redshift Serverless at $0.375 per RPU-hour (4-RPU minimum) and provisioned nodes from about $0.25 an hour.
- Free trial
- RPU-hours or nodes
- Cloud
- AWS warehouse
- Independent sources
Best for AWS-centric teams needing a warehouse close to S3
Key capabilities- Rate
- Minimum
- Billing floor
- Nodes
PricingServerless $0.375 per RPU-hour (4-RPU minimum, $1.50/hour base, 60-second minimum); provisioned $0.25-$13.04 per node-hour.Figures reported by independent sources; vendor page not reviewed directlyClickHouse Cloud
ClickHouse · Real-time analytics database
A managed version of the open-source ClickHouse column store for fast real-time analytics, from $0.2181 per compute unit-hour (Basic) with a $300, 30-day trial.
- Free trial
- Compute + storage
- Cloud or OSS
- Real-time analytics
- Independent sources
Best for Teams building real-time dashboards on event data
Key capabilities- Basic
- Scale
- Enterprise
- Storage
PricingPer compute unit-hour: Basic $0.2181, Scale $0.2985, Enterprise $0.3903; storage $25.30/TB-month; OSS free.Figures reported by independent sources; vendor page not reviewed directlyDatabricks
Databricks · Data intelligence lakehouse
A lakehouse platform for data engineering, BI and AI billed in DBUs, with SQL Serverless around $0.70 per DBU (US Premium list) and a 14-day trial.
- Free trial
- DBU usage
- Cloud
- Lakehouse
- Independent sources
Best for Teams combining BI, data engineering and ML on one copy of data
Key capabilities- SQL Serverless
- EU
- Enterprise tier
- Format
PricingSQL Serverless ~$0.70/DBU (US Premium list); EU ~30% higher; Enterprise tier >$1.00/DBU; cloud infrastructure extra on classic.Figures reported by independent sources; vendor page not reviewed directlyFirebolt
Firebolt · High-performance cloud warehouse
A cloud data warehouse for low-latency analytics with per-second billing; a small compute node is about $0.92 an hour, with $200 in free credits.
- Free credits
- Per-second compute
- Cloud
- Low-latency warehouse
- Independent sources
Best for Teams serving high-concurrency, low-latency dashboards
Key capabilities- 1x S node
- Continuous
- Storage
- Billing
Pricing1x S compute-optimised node ~$0.92/hour (~$672/month continuous); storage ~$0.0264/GB-month; $200 free credits.Figures reported by independent sources; vendor page not reviewed directlyGoogle BigQuery
Google Cloud · Serverless data warehouse
Google Cloud's serverless data warehouse at $6.25 per TiB scanned on demand, with 1 TiB of queries and 10 GB of storage free each month.
- Free tier
- Per TiB scanned
- Cloud
- Serverless warehouse
- Independent sources
Best for Google Cloud teams wanting serverless analytics
Key capabilities- On demand
- Editions
- Default slots
- Queries
PricingOn demand $6.25 per TiB scanned; Editions sell reserved slots; free 1 TiB queries and 10 GB storage a month.Figures reported by independent sources; vendor page not reviewed directlyMicrosoft Fabric
Microsoft · Unified analytics on OneLake
Microsoft's unified analytics platform on OneLake, billed by capacity units; an F2 capacity is about $263 a month pay-as-you-go, with a 60-day trial.
- Free trial
- Capacity units
- Cloud
- Unified analytics
- Independent sources
Best for Microsoft 365 and Azure organisations standardising on Power BI
Key capabilities- PAYG
- Always on
- 1-year reserved
- Storage
PricingF2 ~$0.36/hour PAYG (2 CUs at $0.18/CU-hour), ~$263/month if always on; 1-year reserved F2 ~$156/month; 1-minute minimum.Figures reported by independent sources; vendor page not reviewed directlyMotherDuck
MotherDuck · Serverless DuckDB warehouse
A serverless cloud data warehouse built on DuckDB, billed per second from $0.60 per compute-hour, with a free tier of 10 GB and 10 compute hours a month.
- Free tier
- Per-second compute
- Cloud
- DuckDB warehouse
- Vendor source
Best for Small and mid-size teams and apps wanting fast, cheap analytics
Key capabilities- Compute
- Billing
- Storage
- Storage
Pricing$0.60 to $24.00 per compute-hour by Duckling size (per second, 1-second minimum); storage $0.04/GB-month; free 10 GB + 10 Pulse hours a month.Figures reported by independent sources; vendor page not reviewed directlySingleStore
SingleStore · Real-time distributed SQL
A real-time distributed SQL database for transactions and analytics, with a free shared workspace and managed Standard from $0.99 an hour.
- Free tier
- Hourly / credits
- Cloud
- Real-time HTAP
- Independent sources
Best for Apps needing real-time analytics on fresh operational data
Key capabilities- Shared
- Standard
- Enterprise
- Credit rate
PricingShared free workspace; Standard from $0.99/hour; Enterprise from $1.49/hour; credits at $3.96 in examples; storage ~$0.023-$0.025/GB-month.Figures reported by independent sources; vendor page not reviewed directlySnowflake
Snowflake · Cloud data platform
A cloud data platform billed by compute credits ($2 to $4 a credit by edition) plus storage, with a 30-day trial including $400 of credits.
- Free trial
- Credits + storage
- Cloud
- Data warehouse
- Independent sources
Best for Enterprises running large batch analytics and data sharing
Key capabilities- Standard
- Enterprise
- Business Critical
- XS warehouse
PricingCredits $2 (Standard), $3 (Enterprise), $4 (Business Critical); XS warehouse ~$2/hour on Standard; storage ~$23-$40/TB-month.Figures reported by independent sources; vendor page not reviewed directlyStarburst
Starburst · Trino-based federated query
A Trino-based platform for federated queries across many data sources, with a free Galaxy tier and paid credits from $0.50.
- Free tier
- Credits
- Cloud or self-managed
- Federated query
- Independent sources
Best for Teams querying data across many sources without copying it
Key capabilities- Free
- Pro
- Enterprise
- Mission-Critical
PricingGalaxy Free $0 (3 clusters); Pro from $0.50/credit; Enterprise $0.75; Mission-Critical $1.00; $500 30-day trial.Figures reported by independent sources; vendor page not reviewed directly
No listings match these filters.
Listings are ordered alphabetically by default. They are not ranked, and there are no user ratings or paid placements.
Cloud Data Warehouse Software compared on key criteria.
Summaries come from each profile; open a profile for sources and caveats.
| Product | Pricing model | Entry rate | Free tier | Architecture | Best for |
|---|---|---|---|---|---|
| Amazon Redshift | RPU-hour / node-hour | $0.375/RPU-hour | Trial credits | Cloud warehouse | AWS teams |
| ClickHouse Cloud | Compute + storage | $0.2181/unit-hour (Basic) | OSS free; $300 trial | Real-time column store | Real-time analytics |
| Databricks | DBU usage | ~$0.70/DBU (SQL Serverless) | No; 14-day trial | Lakehouse | BI + ML |
| Firebolt | Per-second nodes | ~$0.92/hour (1x S) | $200 credits | Cloud warehouse | Low-latency apps |
| Google BigQuery | Per TiB / slots | $6.25/TiB scanned | Yes (1 TiB/mo) | Serverless warehouse | Google Cloud |
| Microsoft Fabric | Capacity (F-SKU) | ~$0.36/hour (F2) | No; 60-day trial | Lakehouse (OneLake) | Microsoft shops |
| MotherDuck | Per-second compute | $0.60/compute-hour | Yes (10 GB, 10 hrs) | Serverless DuckDB | Interactive analytics |
| SingleStore | Hourly / credits | $0.99/hour (Standard) | Yes (shared) | Real-time distributed SQL | Real-time apps |
| Snowflake | Credits + storage | $2/credit (Standard) | No; 30-day trial | Cloud warehouse | Enterprise analytics |
| Starburst | Credits | $0.50/credit (Pro) | Yes (Galaxy Free) | Federated / lakehouse | Federation |
Which Cloud Data Warehouse Software option fits which situation.
- Amazon RedshiftMay suit AWS-centric teams needing a warehouse close to S3
- ClickHouse CloudMay suit Teams building real-time dashboards on event data
- DatabricksMay suit Teams combining BI, data engineering and ML on one copy of data
- FireboltMay suit Teams serving high-concurrency, low-latency dashboards
- Google BigQueryMay suit Google Cloud teams wanting serverless analytics
- Microsoft FabricMay suit Microsoft 365 and Azure organisations standardising on Power BI
- MotherDuckMay suit Small and mid-size teams and apps wanting fast, cheap analytics
- SingleStoreMay suit Apps needing real-time analytics on fresh operational data
- SnowflakeMay suit Enterprises running large batch analytics and data sharing
- StarburstMay suit Teams querying data across many sources without copying it
Based on each profile's documented strengths and limits. These are fit notes, not rankings: test options against your own requirements.
Key features and capabilities of Cloud Data Warehouse Software.
The capabilities that define the category. Not every product offers all of them, and depth varies a lot between entry-level and enterprise tools.
Elastic compute
Scale queries up and down.
SQL analytics
Standard SQL.
Separation of storage and compute
Efficient costs.
Data sharing
Share without copying.
Semi-structured data
JSON and nested data.
Security and governance
Access controls and masking.
ML and AI functions
In-warehouse AI.
Ecosystem integrations
ETL and BI tools.
How businesses use Cloud Data Warehouse Software.
- 01
Central analytics store
Single source of truth.
- 02
BI backend
Power dashboards.
- 03
Data sharing
Share with partners.
- 04
ML feature data
Feed models.
- 05
Historical archive
Retain data cost-effectively.
Who uses Cloud Data Warehouse Software and what problems it solves.
Data and analytics teams
Centralise data for BI and reporting.
Data engineers
Run ELT and transformations at scale.
ML and AI teams
Train and serve models on governed data.
Product engineers
Power customer-facing analytics.
What Cloud Data Warehouse Software changes in practice.
Practical outcomes teams report when the category is implemented well. Results depend on adoption, data quality and process, so we do not quote percentages.
Scalability
Handle growth.
Performance
Fast queries.
Pay for use
Elastic pricing.
Less admin
Managed service.
Features and criteria to evaluate in Cloud Data Warehouse Software.
Billing unit
Credits, DBUs, TiB, RPUs, CUs or hours.
Minimum billing
Per-second versus 60-second minimums.
Concurrency
Many users or apps at once.
Open formats
Iceberg, Delta and lock-in.
Ecosystem
Cloud provider, BI and ELT tools.
Governance
Security, compliance and access.
How to choose Cloud Data Warehouse Software: a step-by-step approach.
- 1
Profile workloads
Batch ETL, BI, ad hoc and apps.
- 2
Estimate volumes
Data size, scans and concurrency.
- 3
Run a proof of concept
Your real queries and data.
- 4
Model the bill
Include idle time and minimums.
- 5
Check ecosystem fit
Cloud, BI and ELT tools.
- 6
Set cost guardrails
Budgets, quotas and auto-suspend.
Questions to ask before you buy
- How is compute billed and controlled?
- Which clouds and regions are supported?
- How is governance handled?
- Which tools integrate?
Common mistakes when choosing Cloud Data Warehouse Software.
Ignoring minimum billing
60-second minimums add up for spiky loads.
Leaving compute warm
Idle clusters cost money.
Unbounded scans
Per-TiB pricing punishes bad queries.
Choosing federation as a warehouse
Federation still pays for source compute.
Skipping a proof of concept
Benchmarks rarely match your workload.
Cloud Data Warehouse Software key terms explained.
- Credit
- Snowflake's compute billing unit.
- DBU
- Databricks Unit of compute.
- Slot
- BigQuery's unit of query capacity.
- RPU
- Redshift Processing Unit for Serverless.
- Lakehouse
- Warehouse features on open data lake formats.
- HTAP
- Hybrid transactional and analytical processing.
Cloud Data Warehouse Software comparisons.
7 side-by-side comparisons with a feature table, pricing, strengths and limits, and best-fit scenarios. No winner is declared in any of them.
Alternatives to popular cloud data warehouse and lakehouse platforms.
Every product in this category has a guide comparing its main alternatives and competitors on pricing, free plan, features and fit.
Cloud Data Warehouse Software questions and answers
What is the best free cloud data warehouse and lakehouse platforms?
5 of the 10 cloud data warehouse and lakehouse platforms profiles here document a free plan: ClickHouse Cloud, Google BigQuery, MotherDuck, SingleStore and Starburst. Free plans and tiers usually cap users, records or usage, so check each profile for limits. The list is alphabetical, not a ranking.
What is the best cloud data warehouse and lakehouse platforms for small businesses?
Products documented mainly for small and mid-size teams include MotherDuck. MotherDuck may suit small and mid-size teams and apps wanting fast, cheap analytics. The best fit depends on your sales or work process and budget, so trial two or three.
Which cloud data warehouse and lakehouse platforms suits large enterprises?
9 profiles are documented for large enterprises: Amazon Redshift, ClickHouse Cloud, Databricks, Firebolt, Google BigQuery, Microsoft Fabric, SingleStore, Snowflake and 1 more. Larger rollouts should also check SSO, permissions, audit logs, data residency and contract terms on each profile.
Where can I find alternatives to a specific data platform?
Every product in this category has its own alternatives guide, for example ClickHouse Cloud alternatives, Google BigQuery alternatives and Snowflake alternatives. Each guide compares the main competitors on pricing, free plan, features and fit.
What is the best cloud data warehouse?
Snowflake suits enterprise batch analytics; Databricks suits BI plus ML; BigQuery suits Google Cloud; Redshift suits AWS; ClickHouse and Firebolt suit real-time dashboards. This list is not a ranking.
Snowflake or Databricks?
Snowflake bills $2 to $4 per credit by edition; Databricks SQL Serverless lists around $0.70 per DBU. Snowflake leans to warehousing, Databricks to lakehouse and ML.
Which data warehouses have free tiers?
BigQuery (1 TiB of queries a month), MotherDuck, Starburst Galaxy Free and SingleStore's shared workspace.
How is BigQuery priced?
$6.25 per TiB scanned on demand, or reserved slots through Editions.
Narrow your Cloud Data Warehouse Software shortlist.
Open a profile for sources and pricing, read an alternatives guide, or talk to Stack18 if off-the-shelf is not the answer.
Logos provided by Logo.dev. Product names and logos are trademarks of their respective owners and appear for identification only; they do not imply endorsement.