← ClaudeAtlas

duckdb-lakehouselisted

Use DuckLake 1.1, Iceberg, Delta, and Unity Catalog from DuckDB 2.0. Covers catalog choice, attach options, snapshots and time travel, maintenance, and write limits. Use when the user mentions DuckLake, Iceberg, Delta, a lakehouse catalog, or asks which open table format to use.
srimon12/duckdb-2-skills · ★ 1 · AI & Automation · score 65
Install: claude install-skill srimon12/duckdb-2-skills
# Lakehouse catalogs For raw Parquet or CSV on object storage without a catalog, hand off to `duckdb-files`. This skill governs table formats and catalogs: DuckLake, Iceberg, Delta Lake, and Unity Catalog. Run SQL with `duckdb`. Extensions (`ducklake`, `iceberg`, `delta`, `unity_catalog`) autoload on first use when installation is permitted; otherwise execute `INSTALL AND LOAD <extension>;`. ## Identify the path first Before selecting an extension, identify the path format by inspecting directory signals. If no signal matches, list the directory and halt. Never glob data files when a catalog is authoritative. | Signal | Format | First move | | --- | --- | --- | | `_delta_log/` | Delta | Run `delta_scan` or `ATTACH ... (TYPE delta)` | | `metadata/version-hint.text` and `metadata/*.metadata.json` | Iceberg | Run `iceberg_scan` or attach a REST catalog | | `ducklake:` URI or `ducklake_*` metadata tables | DuckLake | Run `ATTACH 'ducklake:...'` | | Parquet or CSV files only | Plain files | Hand off to `duckdb-files` | ## Choose the format | Format | Concurrent writers | Catalog | Time travel | DuckDB write support | Best fit | | --- | --- | --- | --- | --- | --- | | Native `.duckdb` | Single process | None | No | Full DDL and DML | Single-process analytics, embedded app state | | DuckLake | Multi-writer (catalog DB) | DuckDB file, SQLite, or PostgreSQL | Snapshot ID or timestamp | DDL, DML, `MERGE`, ACID transactions | DuckDB-native lakehouse, multi-writer ACID | | Iceberg