Passing column's value into a UDF

Archive
1

I’m trying to write a UDF using DBT macro. Let’s say,
SELECT col1, f_funcA(col1) FROM table1

In f_funcA macro, how can I get the value from column col1?

1 Like
2

Hi, have you found the solution to this? I am trying the same.

I have built a macro that needs to be passed the value of a source column. This macro is used as a look up from a dict object that I have built, and it would return the value back to the model. Unfortunately, I am unable to get the column value to be passed to the macro.