Skip to content

%model magic adds Macro definition to SQL #345

@eakmanrq

Description

@eakmanrq

Repro:
Macro:

from sqlglot import expressions as exp

from sqlmesh.core.macros import macro, MacroEvaluator


@macro()
def test_macro(
    evaluator: MacroEvaluator,
    column: exp.Column,
) -> exp.Expression:
    return column

Model:

MODEL (
  name db.test,
);

SELECT
  @test_macro(cola),
  ds AS ds
FROM tb

Output:

MODEL (
  name db.test,
  kind INCREMENTAL_BY_TIME_RANGE (
    time_column (ds, '%Y-%m-%d')
  ),
  dialect duckdb
);

def test_macro(evaluator, column):
    return column;

SELECT
  @test_macro(cola) AS test_macro,
  ds AS ds
FROM tb

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugSomething isn't working

    Type

    No type

    Projects

    Status

    Done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions