Skip to content

cianfhoghlaim/cianchosaint / .agents/skills/iceberg-lakekeeper

iceberg-lakekeeper

Verified

Cianfhoghlaim 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 (region garage)
  • Warehouse: s3://lakehouse-bucket/iceberg/

Two read paths, one write path

  • Read fast path — DuckDB ATTACH ... (TYPE iceberg, SECRET, ENDPOINT); supports AT (VERSION => snap) and AT (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 iceberg extension is now core; no INSTALL/LOAD boilerplate needed.

Anti-patterns

  • Do NOT import pyiceberg from a code path that already has DuckDB; the DuckDB iceberg extension is faster and JVM-free for read-only flows.
  • Do NOT pin treeverse/lakekeeper anywhere — the project moved to lakekeeper/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 = true in production; it may violate ACID.
  • Do NOT register a pyiceberg-core extra 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).
writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deploymentStars: 322kUpdated Claude CodeCodexVerifiedInstall
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: 198kUpdated Claude CodeCodexVerifiedInstall
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: 119kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall