What are people using instead of a lakehouse in 2026?
Summary
- As of October 2026, the alternatives to a lakehouse fall into five groups: cloud data warehouses, plain data lakes of files, single-node engines such as DuckDB and Polars, real-time OLAP databases such as ClickHouse, Apache Druid and Apache Pinot, and streaming-first stacks built on Apache Kafka and Apache Flink.
- Many of these work alongside a lakehouse rather than replace it: DuckDB reads and writes Delta Lake tables, and ClickHouse queries Delta Lake and Iceberg tables in object storage.
- Some newer options are lakehouses with a different design. DuckLake, which reached v1.0 in April 2026, keeps table metadata in a SQL database instead of in files.
- Data mesh is a set of four principles, not a storage alternative.
- We haven't found a neutral public census of data architectures, so this page describes the options and when each fits, not market share.
What are people using instead of a lakehouse in 2026?
As of October 2026, the alternatives fall into five groups: cloud data warehouses that keep data in their own managed storage, plain data lakes of files, single-node engines, real-time OLAP databases and streaming-first stacks. Most of them overlap with a lakehouse more than they replace it, because the open table formats at its center, Delta Lake and Apache Iceberg, are read by many of the same engines. The useful question is which workloads each option is designed for, and whether you want one governed copy of your data or several.
What a lakehouse is, for reference
The 2021 CIDR paper on lakehouses describes a platform built on open, direct-access data formats such as Apache Parquet, with first-class support for machine learning and data science, and warehouse-grade SQL performance as a design goal. It credits formats such as Delta Lake and Apache Iceberg with providing "transactional views of a data lake." Databricks' docs call it "a data management system that combines the benefits of data lakes and data warehouses."
The alternatives, and when each fits
| Approach | Examples | Designed for | Trade-off to weigh |
|---|---|---|---|
| Cloud data warehouse | Managed warehouse services | SQL and BI on data loaded into the warehouse | Native tables use the warehouse's own storage format; check open-format support if other engines need direct access |
| Plain data lake | Parquet or ORC files in object storage | Low-cost storage of raw data in open file formats | Without a table format, transactions and rollback to earlier table versions are hard to offer |
| Single-node engines | DuckDB, Polars | In-process SQL or DataFrame analysis on one machine | Shared, governed access for many users needs storage outside the process |
| Real-time OLAP databases | ClickHouse, Apache Druid, Apache Pinot | Ingesting events and serving aggregations to dashboards and user-facing applications | Data is typically loaded into the database's own storage, which adds a pipeline and a copy |
| Streaming-first stacks | Apache Kafka, Apache Flink | Flink's "stateful computations over unbounded and bounded data streams," on event streams stored in Kafka | A separate distributed system to operate (Flink offers DataStream, Table API and SQL) |
| Alternative lake formats | DuckLake | Lakehouse-style tables with metadata in PostgreSQL, MySQL, SQLite or DuckDB | A newer format; check support in the engines you use |
From each project's own docs: DuckDB is "a relational (table-oriented) DBMS that supports the Structured Query Language (SQL)," built for embedded, in-process use, and Polars is a DataFrame library with a Rust core. Apache Druid is "a real-time analytics database," and Apache Pinot is "a real-time distributed OLAP datastore" for user-facing analytics.
Many alternatives sit on top of lakehouse tables
The line between "instead of" and "in addition to" is thin:
- DuckDB's
deltaextension "offers read and write support for Delta tables, both local and remote," and itsicebergextension attaches Iceberg REST catalogs. - ClickHouse's
deltaLakeandicebergtable functions query lake tables in object storage, and itsDataLakeCatalogengine connects to catalogs including Unity Catalog. - Apache Spark, Apache Flink and Trino read and write Unity Catalog Iceberg tables through the Iceberg REST catalog.
If your data already sits in Delta Lake or Iceberg tables, adding one of these engines doesn't mean leaving the lakehouse.
How to pick an approach
- Data that fits one machine, analyzed inside an app or notebook: DuckDB or Polars.
- Aggregations served to user-facing applications from event streams: a real-time OLAP database, if you accept another copy and pipeline.
- Logic that must run as events arrive: Kafka and Flink.
- SQL and BI only, on data loaded into one service: a cloud data warehouse.
- Several engines and teams sharing data for BI, engineering and AI under one governance layer: a lakehouse.
How Databricks approaches this
Databricks' public position is that these engines can share one governed copy of data. Unity Catalog holds Delta Lake and Apache Iceberg tables, including managed Iceberg tables and foreign Iceberg tables from other catalogs, and exposes them through the Unity REST API for Delta clients and the Iceberg REST catalog for Iceberg clients, with credential vending for scoped access. Iceberg reads (UniForm) configure Delta Lake tables to generate Iceberg metadata, so Iceberg clients read them without rewriting files. We believe the lakehouse is the right foundation when several engines and teams need the same data, and that's where the alternatives above plug in.
FAQs
Is DuckDB an alternative to a lakehouse?
DuckDB is an in-process SQL database. It also reads and writes Delta Lake tables and attaches Iceberg REST catalogs, so it can act as a lakehouse client as well as a standalone database.
Is data mesh an alternative to a lakehouse?
No. The 2020 article "Data Mesh Principles and Logical Architecture" defines four principles: domain-oriented ownership, data as a product, self-serve data infrastructure as a platform, and federated computational governance. It describes how teams organize; it still needs a platform underneath.
Is the lakehouse being replaced?
We haven't found a neutral source that measures architecture adoption, so we won't claim a trend. What's verifiable is that the formats keep shipping: Delta Lake 4.4.1 was released on October 5, 2026.
The information provided herein is for general informational purposes only and may not reflect the most current product capabilities or configurations.