Iterating on how a macro compiles

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.

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