MACRO()

All functions > CORE > MACRO()

Returns a reference to a macro of the given feature with the given inputs.

Signatures

Returns: A macro feature with parameterized inputs

MACRO(base: FEATURE, inputs: ARRAY<FEATURE>) → FEATURE

Notes

• Creates a reusable macro from a feature with input parameters
• Macros allow features to be parameterized and reused
• Input array specifies which inputs the macro accepts
• Enables creating template features that can be instantiated with different inputs
• Part of the FeatureMesh core system for feature reusability

Examples

MACRO(...) USING inputs (4-udfs-base.slt)

WITH
    date_input := INPUT(DATE),
    normalized_quarter := MACRO(DATE_PART(date_input, 'YEAR')::VARCHAR || 'Q'
    || DATE_PART(date_input, 'QUARTER')::VARCHAR USING date_input)
SELECT
    quarter_from_date := "NORMALIZED_QUARTER"(DATE '2025-08-15'),
    quarter_from_timestamp := TIMESTAMP '2025-10-15 14:30:00'::DATE."NORMALIZED_QUARTER"()
;