dbt compile generates executable SQL from source
analysis files. You can find these compiled SQL files in the
target/ directory of your dbt project.
compile command is useful for:
- Visually inspecting the compiled output of model files. This is useful for validating complex jinja logic or macro usage.
- Manually running compiled SQL. While debugging a model or schema test, it's often useful to execute the underlying
selectstatement to find the source of the bug.
analysisfiles. Read more about analysis files here.