DuckLake

DuckLake is an open lakehouse format that stores table data as Parquet files and keeps all table metadata in a SQL catalog database. Built on plain SQL and Parquet, it separates metadata from file storage so snapshots, schema changes, and statistics live in a transactional database rather than scattered metadata files.

The DuckLake extension lets DuckDB read and write these tables directly using standard SQL. Tables support time travel between versions, schema evolution, and a change data feed, and the catalog can run on DuckDB, PostgreSQL, or SQLite while the data stays in Parquet.

DuckLake comes from the DuckDB team and installs as a DuckDB extension.