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

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

1 Like