Use case

Databases for Lakehouse

Warehouse-style SQL directly over open table formats (Iceberg, Delta) on object storage. The leading options are Snowflake, Google BigQuery and DuckDB.

42 active · ordered by fit for this category, then WhichDB Score

SnowflakeColumnar / OLAPmanaged

Fully managed cloud data warehouse with separate storage and compute, now spanning AI and apps.

74.4
Google BigQueryColumnar / OLAPmanaged

Google's serverless, pay-per-query data warehouse built on Dremel and Colossus.

65.3
DuckDBColumnar / OLAPopen source

In-process columnar SQL database: the SQLite of analytics, running inside your app or notebook.

63.7
Amazon RedshiftColumnar / OLAPmanaged

AWS's MPP columnar data warehouse, available as provisioned RA3 clusters or Serverless.

55.8
MotherDuckColumnar / OLAPmanaged

Serverless cloud data warehouse built on DuckDB, with hybrid local-plus-cloud execution.

37.7
Apache DataFusionColumnar / OLAPopen source

Extensible Rust query engine library on Apache Arrow for building databases and data systems.

31.6
Databricks SQLColumnar / OLAPmanaged

Serverless SQL warehouses on the Databricks lakehouse, powered by the Photon C++ engine.

20.8
Apache DorisColumnar / OLAPopen source

Real-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access.

15.9
StarRocksColumnar / OLAPopen source

MPP OLAP database with a fast vectorized engine, real-time upserts and native lakehouse queries.

15.6
DatabendColumnar / OLAPopen source

Rust-built cloud data warehouse on object storage, open source with a managed Databend Cloud.

15.4
Apache PaimonColumnar / OLAPopen source

Streaming lakehouse table format with LSM-based upserts and changelogs, born in Apache Flink.

14.2
pg_mooncakeColumnar / OLAPopen source

Postgres extension that mirrors tables into Iceberg columnstores for real-time analytics via DuckDB.

11.2
Apache FlussColumnar / OLAPopen source

Columnar streaming storage for Flink with primary-key tables and tiering into the lakehouse.

8.4
FireboltColumnar / OLAP

Low-latency analytical database with a Postgres-compliant dialect, as cloud service or self-hosted Core.

7.8
Azure Synapse AnalyticsColumnar / OLAPmanaged

Azure analytics service combining MPP dedicated SQL pools, serverless SQL and Spark.

7.4
Microsoft Fabric Data WarehouseColumnar / OLAPmanaged

T-SQL warehouse in Microsoft Fabric that stores every table as Delta Parquet in OneLake.

6.7
VeloDBColumnar / OLAPmanaged

Commercial cloud and enterprise distribution of Apache Doris from its core maintainers.

2.3
IBM Db2 WarehouseColumnar / OLAP

IBM's MPP analytics edition of Db2 with BLU columnar acceleration, as software or SaaS.

0.0
Apache Spark SQLRelationalopen source

Spark's SQL and DataFrame engine for large-scale batch, streaming and lakehouse processing.

50.3
TrinoRelationalopen source

Fast distributed SQL query engine for federated analytics across lakes and databases.

49.9
Teradata VantageRelational

The original MPP data warehouse, now VantageCloud with open table formats and in-database analytics.

38.5
PrestoRelationalopen source

Distributed SQL query engine from Meta for interactive queries over data lakes and many sources.

37.7
Apache HiveRelationalopen source

The original SQL-on-Hadoop warehouse, now mostly valued for its Metastore and Iceberg support.

30.1
Apache ImpalaRelationalopen source

Low-latency MPP SQL engine for Hadoop, Kudu and Iceberg tables, developed largely by Cloudera.

29.0
Amazon AthenaRelationalmanaged

Serverless AWS query service running Trino-based SQL directly over data in S3.

19.5
RisingWaveRelationalopen source

An Apache-licensed, Postgres-compatible streaming database that stores state on S3 and writes Iceberg.

17.4
pg_lakeRelationalopen source

Postgres extensions from Snowflake that read and write Iceberg tables and lake files, executed via DuckDB.

15.2
pg_duckdbRelationalopen source

PostgreSQL extension that embeds DuckDB's vectorized engine for fast analytics and data-lake queries.

14.9
SailRelationalopen source

Rust-native, Spark Connect-compatible engine for SQL, DataFrame and streaming jobs without the JVM.

14.5
DremioRelational

Iceberg-native lakehouse query engine with reflections for acceleration, owned by SAP since 2026.

12.7
Deep LakeVectoropen source

Activeloop's tensor-native data engine for AI: vectors, multimodal data and versioning on object storage.

12.2
e6dataRelationalmanaged

Lakehouse compute engine that runs SQL on Iceberg, Delta and Hudi in your own cloud account.

7.4
Apache CloudberryRelationalopen source

Open-source MPP warehouse forked from Greenplum and rebased on a newer PostgreSQL kernel.

6.8
PuppyGraphGraph

Zero-ETL graph query engine that runs Cypher and Gremlin directly on your lakehouse and SQL tables.

5.6
ArroyoRelationalopen source

A Rust stream processor with SQL pipelines, now owned by Cloudflare and powering Cloudflare Pipelines.

5.4
Oracle Autonomous DatabaseRelationalmanaged

Self-driving Oracle Database on Exadata: auto-patching, auto-scaling, and Select AI, on OCI and other clouds.

0.0
StarburstRelational

Commercial Trino platform: self-managed Starburst Enterprise and the Starburst Galaxy SaaS.

0.0
LanceDBVectoropen source

Embedded, serverless retrieval database on the Lance columnar format for multimodal AI data.

27.5
FelderaRelationalopen source

An incremental SQL engine grounded in DBSP theory that updates any SQL query from changes only.

15.8
Databricks LakebaseRelationalmanaged

Databricks' serverless Postgres built on Neon tech, with branching and sync to Delta tables in Unity Catalog.

0.8
MySQL HeatWaveRelationalmanaged

Oracle's managed MySQL with an in-memory columnar engine for analytics, lakehouse, ML and vector search.

0.5
Crunchy BridgeRelationalmanaged

Crunchy Data's developer-friendly managed Postgres across AWS, GCP and Azure, now owned by Snowflake.

0.2

deprecated, discontinued & research · 1

license legend · Open source (permissive) · Open source (copyleft) · Source-available · Proprietary