The problem I’m having
I wrote a jinja loop to simplify a script:
{% set table_dict = {
“test”: {“report”: “Report”, “data_lag”: “No Lag”, “source”: “_test”},
}%}
{% for table_name, value in table_dict.items() %}
_{{ table_name }} as (
select
‘{{ table_name }}’ as data_src,
‘{{ value[“report”] }}’ as report,
‘{{ value[“data_lag”] }}’ as data_lag,
{{ filename_date(‘“filename”’) }} as current_refresh,
{{ filename_date(‘“filename”’) }} as pull_dt,
‘Monthly’ as updated
from {{ source('ops', '{{ value["source"] }}') }} limit 1
),
{% endfor %}
It errors out with a compilation error:
16:56:37 Running with dbt=1.7.13
16:56:37 Registered adapter: duckdb=1.7.4
16:56:37 Encountered an error:
Compilation Error
Model ‘’ (models\reports) depends on a source named ‘ops.{{ values.get(source) }}’ which was not found
It seems that dbt compiles source first and promptly errors out. I’ve verified that everything compiles correctly when not trying to insert the string into source. Is this something I can fix? It would be really helpful.