How to generate the SQL for an incremental model in full_refresh mode

If I have an incremental model, how do I generate the code that would be passed to the database if I ran it as a full refresh? I know I could run dbt run --full_refresh --select model_name_here in my own branch and look in /target/compiled, but I’d prefer to do this without actually running anything against the database.


What you are looking for is the [dbt compile] command. This will compile your model without actually running it, something like a dry run.

You can use the --select argument to only compile the desired models dbt compile --full_refresh --select model_name_here. Results will be saved in the target folder inside your dbt project


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.