From delta-skills
Show the commit history of a Delta Lake table — version, timestamp, operation, and row metrics. Use when the user wants to see what changed over time in a Delta table. Triggers on phrases like "show history", "delta table history", "what changed", "commit log", "audit trail".
How this skill is triggered — by the user, by Claude, or both
Slash command
/delta-skills:show-historyThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Show the full commit history of a Delta Lake table by reading all JSON files in `_delta_log`. No Spark, no library — just filesystem access.
Show the full commit history of a Delta Lake table by reading all JSON files in _delta_log. No Spark, no library — just filesystem access.
/delta-skills:show-history path/to/table
/delta-skills:show-history path/to/table --limit 10
Default limit: 20 most recent versions.
TABLE_PATH="$1"
if [ ! -d "$TABLE_PATH/_delta_log" ]; then
echo "ERROR: No _delta_log directory found at $TABLE_PATH"
echo "This does not appear to be a Delta Lake table."
exit 1
fi
ls "$TABLE_PATH/_delta_log/"*.json 2>/dev/null | sort -V
This gives you all commit files in version order. Apply --limit by taking the last N files.
For each commit file, read line by line and find the line containing "commitInfo". Parse:
timestamp — milliseconds since epoch, convert to human-readable UTCoperation — e.g. WRITE, MERGE, DELETE, UPDATE, CREATE TABLE, OPTIMIZE, VACUUM ENDoperationParameters — mode, predicate, etc. (summarize briefly)operationMetrics — key metrics depending on operation type:
numFiles, numOutputRows, numOutputBytesnumTargetRowsInserted, numTargetRowsUpdated, numTargetRowsDeletednumDeletedRowsnumFilesAdded, numFilesRemoved, numRemovedBytesuserName or userId — who made the change (if present)engineInfo — what engine wrote it, e.g. Apache-Spark/3.5.0 Delta-Lake/3.1.0Present as a table, most recent first:
Delta table history: tables/customers
Showing last 10 versions (total: 42 commits)
Version Timestamp Operation Rows Details
─────── ───────────────────── ────────── ────────── ─────────────────────────────
42 2025-03-18 09:12 UTC MERGE +1,204 updated: 11,196 deleted: 0
41 2025-03-17 08:55 UTC MERGE +980 updated: 10,220 deleted: 12
40 2025-03-16 09:01 UTC OPTIMIZE — files: -34 +8 saved: 1.2GB
39 2025-03-15 08:48 UTC MERGE +1,102 updated: 9,887 deleted: 0
38 2025-03-14 09:03 UTC MERGE +1,340 updated: 12,001 deleted: 4
37 2025-03-13 08:59 UTC MERGE +890 updated: 9,450 deleted: 0
36 2025-03-12 08:44 UTC VACUUM END — deleted: 23 files
35 2025-03-11 09:15 UTC MERGE +1,550 updated: 13,200 deleted: 2
34 2025-03-10 08:52 UTC MERGE +1,100 updated: 10,900 deleted: 0
33 2025-03-09 09:05 UTC SCHEMA CHANGE — added column: loyalty_tier (string)
Adapt the "Details" column per operation type:
WRITE → mode: append|overwrite rows: NMERGE → inserted: N updated: N deleted: NDELETE → deleted: N rowsUPDATE → updated: N rowsOPTIMIZE → files: -N +N saved: X MBVACUUM START/END → deleted: N filesCREATE TABLE → schema set, partitioned by: XREPLACE TABLE → note schema or partition changecommitInfo → skip it and note the gapcommitInfo is always the first newline-delimited JSON object in each commit fileoperationMetrics keys vary by engine version — be tolerant of missing keyscommitInfonpx claudepluginhub chanukyapekala/delta-skills --plugin delta-skillsExplores Bauplan lakehouse data using Python SDK: inspect namespaces, tables, schemas, samples, profiling queries; export results to files. Read-only, phased execution produces summary.md.
Queries Databricks Unity Catalog system tables for audit, lineage, billing, compute, jobs; manages volumes with upload, download, list, and directory operations.
Builds, configures, and runs dbt projects on the duckrun adapter — dbt models in DuckDB materialized as Delta Lake tables via delta-rs, locally or on S3/GCS/ADLS/OneLake. Auto-activates for duckrun profiles, models, incremental strategies, and Fabric Lakehouse troubleshooting.