Platforms and engines for analytical SQL at scale: cloud data warehouses, lakehouse platforms, analytical databases and distributed query engines.
All data warehousing & analytics listings
Amazon Redshift
AWS data warehouse as provisioned RG and RA3 clusters or Redshift Serverless billed per RPU-hour.
Azure Synapse Analytics
Azure analytics service with dedicated and serverless SQL pools and Spark; supported, but Microsoft points new work to Fabric.
ClickHouse
Apache 2.0 columnar database for real-time analytics, self-hosted or as the managed ClickHouse Cloud.
Databricks
Lakehouse platform for Spark, SQL warehouses and ML on Delta Lake and Iceberg tables, on AWS, Azure and Google Cloud.
DuckDB
Free MIT-licensed in-process analytics database that queries Parquet, CSV and lake tables with no server.
Firebolt
Low-latency analytics database with PostgreSQL-style SQL, per-second billing and a free self-hosted Core.
Google BigQuery
Serverless Google Cloud data warehouse billed per TiB processed or by slot capacity, with a monthly free tier.
Microsoft Fabric
Microsoft SaaS analytics platform: OneLake, Spark, T-SQL warehouse, pipelines and Power BI on one F SKU capacity.
SingleStore
Commercial distributed SQL database with rowstore and columnstore tables for real-time and mixed workloads.
Snowflake
Managed cloud data warehouse on AWS, Azure and Google Cloud, billed per second in credits for virtual warehouses.
StarRocks
Apache 2.0 MPP analytics engine for sub-second queries on native tables and Iceberg, Hudi, Delta and Paimon.
Trino
Apache 2.0 distributed SQL query engine for federated and lakehouse queries across many data sources.
Comparisons
A cloud data warehouse against a lakehouse platform, and where they now overlap.
Multi-cloud credits-based warehousing against Google's serverless warehouse.
What separates analytical warehouses from operational databases.
Snowflake against AWS's own data warehouse, provisioned or Serverless, for teams on AWS.
A lakehouse platform against Google's serverless warehouse.
A lakehouse platform against AWS's data warehouse.
Google's and AWS's native data warehouses: per-TiB and slot pricing against node-hours and Serverless RPUs.
Snowflake against Azure Synapse dedicated SQL pools, and Microsoft's guidance to start new warehouses on Fabric.
Two lakehouse-based analytics platforms with different pricing and scope.
An open source columnar database against a managed cloud warehouse.
Open source real-time analytics against Google's serverless warehouse.
A columnar analytics database against a lakehouse platform.
Local in-process analytics against a cloud data warehouse.
Local in-process analytics against Google's serverless warehouse.
An analytics server for many users against an in-process engine for local and file-based analysis.
Alternatives and buyer guides
How we research listings: our editorial method. Other categories: the full SQL tools directory.
Compare before you choose
See the head to head comparisons or browse every category in the tools directory.