cianfhoghlaim/cianchosaint / .agents/skills/iceberg-lakekeeper
iceberg-lakekeeper
VerifiedCianfhoghlaim canonical reference for Apache Iceberg 1.4+ tables, the Iceberg REST catalog spec, and the Lakekeeper (Rust, lakekeeper.io) catalog implementation that backs `infrastructure/stacks/lakehouse`. Use when designing time-travel / hidden-partitioning / schema-evolution flows, wiring PyIceberg / DuckDB / Spark / Trino against the `lakehouse-lakekeeper:8181` REST endpoint, choosing between DuckDB ATTACH and PyIceberg for read paths, or extending the `cianfhoghlaim-pipeline` lakehouse ingestion with Iceberg features (sort orders, Z-order, V3 Variant, encryption.key-id, soft-delete, undrop, vended credentials).
Iceberg + Lakekeeper (Cianfhoghlaim canonical)
Versions (verified 2026-06-29)
- PyIceberg 0.11.1 (2026-03-03) —
pip install "pyiceberg[s3fs,pyarrow,duckdb,pyiceberg-core]" - Apache Iceberg Java 1.11.0 (spec latest)
- Lakekeeper v0.12.4 (2026-06-17) —
quay.io/lakekeeper/catalog:v0.12.4 - DuckDB iceberg extension — core (auto-loads on first use)
Cianfhoghlaim wiring (current)
- Catalog endpoint:
http://lakehouse-lakekeeper:8181(lakehouse-net) - Postgres backend (shared with DuckLake/Nimtable) at
lakehouse-postgres:5432 - S3 backend:
http://lakehouse-garage:3900(regiongarage) - Warehouse:
s3://lakehouse-bucket/iceberg/
Two read paths, one write path
- Read fast path — DuckDB
ATTACH ... (TYPE iceberg, SECRET, ENDPOINT); supportsAT (VERSION => snap)andAT (TIMESTAMP => ...)natively. No JVM. Lakekeeper is in the docs' "Iceberg REST Catalogs" list. - Read BAML / Arrow path — PyIceberg 0.11.1
load_catalog("cianfhoghlaim", type="rest", uri=...)→ returns PyArrow fragments; use this when feeding the BAML extraction pipeline. - Write path — PyIceberg 0.11.1 only (DuckDB iceberg write support is still beta for v2 schema ops); commit to Lakekeeper via
/v1/transactions/commit.
What changed since Wave 1 (2026-06-28)
- Lakekeeper is at v0.12.4 — major v0.12.0 added V3 Variant, Idempotency Keys, Instance Admins, OPA batch opt, jemalloc, structured logs (BREAKING), Spark 4 IT.
- Env var rename:
LAKEKEEPER__OPENID_PROVIDER_URI→LAKEKEEPER__OPENID_PROVIDERS(multi-IdP). - DuckDB
icebergextension is now core; noINSTALL/LOADboilerplate needed.
Anti-patterns
- Do NOT import
pyicebergfrom a code path that already has DuckDB; the DuckDBicebergextension is faster and JVM-free for read-only flows. - Do NOT pin
treeverse/lakekeeperanywhere — the project moved tolakekeeper/lakekeeper. The P1B-08 README still references the old org and needs the Phase 1B refactor to update. - Do NOT use
unsafe_enable_version_guessing = truein production; it may violate ACID. - Do NOT register a
pyiceberg-coreextra for pipelines that only scan (DuckDB handles that without the Rust core). - Do NOT skip
LAKEKEEPER__PG_ENCRYPTION_KEY— Lakekeeper v0.12.1+ refuses to start without it.
Sources
- PyIceberg: https://py.iceberg.apache.org/
- Lakekeeper: https://github.com/lakekeeper/lakekeeper (renamed from treeverse/lakekeeper)
- Lakekeeper image:
quay.io/lakekeeper/catalog:v0.12.4 - See also:
.agents/skills/ducklake/SKILL.md— DuckLake reads from the same lakehouse-net Postgres; use DuckLake for SQL-DDL-style append/merge on the same data; use Iceberg REST + PyIceberg for v2/v3 features (V3 Variant, soft-delete, undrop, vended creds, branch/tag).
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deployment | Stars: 322k | Updated | Claude CodeCodex | Verified | Install |
| xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved. | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |