macro return value

[joellabes]

Macros aren’t the same as UDFs - they are rendered once and return a static string of SQL.

If you want to create a UDF in dbt, check out Using dbt to manage user defined functions