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.
Thanks!
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