⌘+k ctrl+k
0.4 (stable)
Search Shortcut cmd + k | ctrl + k
ducklake_macro

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_id refers to a schema_id from the ducklake_schema table.
  • macro_id is the numeric identifier of the macro. macro_id is incremented from next_catalog_id in the ducklake_snapshot table.
  • macro_name is the name of the macro, e.g., my_macro.
  • begin_snapshot refers to a snapshot_id from the ducklake_snapshot table. The macro exists starting with this snapshot id.
  • end_snapshot refers to a snapshot_id from the ducklake_snapshot table. The macro exists up to but not including this snapshot id. If end_snapshot is NULL, the macro is currently valid.