Iterating on how a macro compiles

Archive
1

hi there,

I found it quite time-consuming to troubleshoot a macro.
1 I create a macro, then call it in a SQL file,
2 then run dbt compile
3 then check the target folder and see the result.

Is a simple way to troubleshoot a macro?
And is there any website recommended to macro learning? Thanks.

2

Do you have access to dbt cloud? It comes with an IDE where you can preview code compilation in the same context as you write it, without needing to go though a dbt compile step.

1 Like