This table stores macro definitions. Each macro is associated with a schema and tracks its lifecycle through snapshots.
| Column name | Column type |
|---|---|
schema_id |
BIGINT |
macro_id |
BIGINT |
macro_name |
VARCHAR |
begin_snapshot |
BIGINT |
end_snapshot |
BIGINT |
schema_idrefers to aschema_idfrom theducklake_schematable.macro_idis the numeric identifier of the macro.macro_idis incremented fromnext_catalog_idin theducklake_snapshottable.macro_nameis the name of the macro, e.g.,my_macro.begin_snapshotrefers to asnapshot_idfrom theducklake_snapshottable. The macro exists starting with this snapshot id.end_snapshotrefers to asnapshot_idfrom theducklake_snapshottable. The macro exists up to but not including this snapshot id. Ifend_snapshotisNULL, the macro is currently valid.
© 2026 DuckDB Foundation, Amsterdam NL