Stack Gems
Menu
← Catalog

DuckLake

MIT lakehouse table format on SQL + Parquet — a DuckDB extension

Databases / Lakehouse · OSS/MIT · 3.3k

Reviewed 2026-10-08 · last push 2026-10-17 · repo checked 2026-10-19

What's Good

MIT (Stichting DuckDB Foundation). DuckLake v1.0 is out; `INSTALL ducklake;` then `ATTACH 'ducklake:metadata.ducklake' AS lake (DATA_PATH 'files/');` and use plain SQL. Catalog can be DuckDB, PostgreSQL, SQLite, or MySQL; Parquet on local disk or S3-compatible storage; multiple clients against one catalog. The first lakehouse table format on Stack Gems. ★~3k.

The Catch

Needs a separate catalog database you run and back up (DuckDB file for one writer, Postgres/MySQL for multi-client). Engines outside DuckDB support it far less widely than Iceberg or Delta Lake — check your Spark/Trino/warehouse story before committing. Younger format with a shorter production track record. Vs the duckdb gem: DuckDB is the engine; DuckLake is the table format and catalog layer on top.

Verdict

MIT SQL-catalog lakehouse format when DuckDB is your engine and Iceberg’s catalog stack feels heavy — confirm multi-engine support first.

Embed

Maintainer? Add the badge to your README. It is free, links to this review, and there is no paid version.

Reviewed on Stack Gems

Markdown

[![Reviewed on Stack Gems](https://stackgems.com/badge/ducklake.svg)](https://stackgems.com/gems/ducklake)

HTML

<a href="https://stackgems.com/gems/ducklake"><img src="https://stackgems.com/badge/ducklake.svg" alt="DuckLake reviewed on Stack Gems" height="20"></a>