The problem I’m having
I would like to partially compile dbt model.
so, I tried to set variable values like this.
mymodel.sql
select *
from {{ ref('mymodel') }}
where dt between '{{ start_date }}' and '{{ end_date }}'
What I’ve already tried
dbt compile --vars '{"start_date": "2022-12-01", "end_date": "{{end_date}}" }'
expected compiled result
select *
from dw.mymodel
where dt between '2022-12-01' and '{{ end_date }}'
but I got
select *
from dw.mymodel
where dt between '2022-12-01' and ''