ducklake_macro_parameters

Search Shortcut cmd + k | ctrl + k

Documentation / Specification / Tables

This table stores the parameters for each macro implementation.

Column name	Column type
`macro_id`	`BIGINT`
`impl_id`	`BIGINT`
`column_id`	`BIGINT`
`parameter_name`	`VARCHAR`
`parameter_type`	`VARCHAR`
`default_value`	`VARCHAR`
`default_value_type`	`VARCHAR`

macro_id refers to a macro_id from the ducklake_macro table.
impl_id refers to an impl_id from the ducklake_macro_impl table.
column_id is the positional index of the parameter within the implementation.
parameter_name is the name of the parameter.
parameter_type is the DuckLake type of a scalar parameter. Set to unknown if the parameter type is not specified. Nested parameter types include their child types, e.g., INTEGER[] or STRUCT(i INTEGER) for the duckdb dialect.
default_value is the default value of the parameter. Set to the text NULL if no default is specified.
default_value_type is the DuckLake type of a literal default value, or expression for a SQL expression. Set to unknown if no default is specified.

A NULL::DATE default is stored as the text NULL with type date. The string literal 'NULL' uses type varchar. Nested defaults and string-typed NULL defaults are stored as SQL expressions, e.g., CAST(NULL AS VARCHAR) with type expression.

Legacy list and struct parameter types without child types are loaded as untyped parameters.

DuckLake Home Manifesto Blog