How to view compiled SQL from macros?

Archive
1

Do we have any ways to view the compiled SQL when we calling macros?

2

Create a model (or analysis), call the macro in the model/analysis, compile the model/analysis with dbt compile, and view the compiled code in the target/compiled directory.

Or if you’re using the dbt Cloud IDE, you can call the macro and click the “Compile” button to view the code.

1 Like