Smart DuckLake table maintain (adaptive rewrite + merge) and catalog-global expire/cleanup
Maintainer(s):
paulosuzart
Installing and Loading
INSTALL lakemon FROM community;
LOAD lakemon;
Example
INSTALL ducklake;
LOAD ducklake;
INSTALL lakemon FROM community;
LOAD lakemon;
ATTACH 'ducklake:metadata.ducklake' AS lake (DATA_PATH 'data_files');
CALL lakemon_table_stats('lake');
CALL lakemon_maintain('lake');
CALL lakemon_maintain_global('lake');
CALL lakemon_maintain('lake', dry_run => true);
CALL lakemon_policy();
About lakemon
lakemon orchestrates native DuckLake maintenance CALLs with a policy layer:
- Catalog SELECT inventory of data files and delete files
- Byte-weighted adaptive rewrite ladder (delete fraction DESC; one ducklake_rewrite_data_files CALL per byte-cut rung)
- Merge size bands (micro / small / medium) with per-tier target_file_size
- Table maintain (lakemon_maintain) vs catalog-global expire/cleanup (lakemon_maintain_global)
- Execute-by-default; pass dry_run => true to plan only
- One result row per step (ok / skip / error / planned)
Requires the core ducklake extension in the same session and an attached DuckLake catalog. Compatible with DuckDB 1.5.* and DuckDB 2.x.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| lakemon_maintain | table | NULL | NULL | |
| lakemon_maintain_global | table | NULL | NULL | |
| lakemon_policy | table | NULL | NULL | |
| lakemon_set_policy | table | NULL | NULL | |
| lakemon_table_stats | table | NULL | NULL | |
| lakemon_version | scalar | NULL | NULL |
Overloaded Functions
This extension does not add any function overloads.
Added Types
This extension does not add any types.
Added Settings
This extension does not add any settings.