Observing the lake
Trusted by data engineers
Features
Lake Overview
Track total files, rows, writes, and deletions across snapshots. See how your lake evolves with interactive time-series charts — scoped to lake, schema, or table level.
247
12 schemas
3,200
48.6K MB total
892M
across all schemas
1,024
847 eligible to expire
234.1M
~230M per metadata
847
avg 0.6 MB
1.2B
rows ever inserted
9.8M
4.2% of inserts
| Column | Type | Nullable |
|---|---|---|
| PK event_id | UUID | NO |
| user_id | INT64 | NO |
| created_at | TIMESTAMP | NO |
| event_type | VARCHAR | YES |
Per-Table Detail
Click any table to see columns, types, partitions, live row count, churn percentage, and file distribution. Run targeted maintenance directly from the detail drawer.
Maintenance
Lakemon surfaces exactly which tables need maintenance and why — then lets you run it with a confirmation dialog showing the exact SQL that will execute.
Lake Maintenance
847 snapshots older than 48h eligible for expiry
Table Candidates
2 tables| Schema | Table | Action | Reason | |
|---|---|---|---|---|
| analytics | events | Merge Files | 45 small files | |
| warehouse | fact_orders | Rewrite Files | 12% row churn |
SQL Preview
CALL ducklake_merge_adjacent_files('dlw', 'events', schema => 'analytics', ...) Why Lakemon
DuckLake is powerful. Keeping it healthy shouldn't require a folder of ad-hoc queries and tribal knowledge.
-- TODO: find fragmented tables (run weekly)
SELECT schema_name, table_name,
count(*) as file_count
FROM ducklake_files
WHERE status = 'active'
GROUP BY 1, 2
HAVING count(*) > 50
-- and snapshots... where's that other script?
-- churn query is in Notion I think
Every. Single. Week.
Instant. Every time you open it.
Write SQL per table
Auto-flagged small files
Snapshots silently grow
One-click expire
Scattered notebooks
Single dashboard
Guess what needs compaction
Impact-ranked candidates
Row churn invisible
Per-table churn %
| Manual SQL | Lakemon | |
|---|---|---|
| Small files detection | Write queries per table | Auto-scanned, flagged per table |
| Snapshot hygiene | Forgotten, keeps growing | Eligible counts + one-click expire |
| Lake health overview | Scattered SQL scripts | Single dashboard view |
| Maintenance execution | Write SQL by hand | Preview SQL, confirm, run |
| File compaction | Guess which tables | Candidates ranked by impact |
| Row churn tracking | Not visible | Per-table churn % with alerts |
How it works
Point Lakemon at your DuckLake. Read-only by default — no data is ever modified without your explicit confirmation.
See schema stats, table health, small files, deletion queues, and snapshots in a single dashboard. Drill into any table.
Run compaction, rewrite, expire, and cleanup operations with one click. Preview the exact SQL before execution.
FAQ
Free and open source. Connects to any DuckLake instance via DuckDB.
macOS · Linux · Windows