tuva
tuva copied to clipboard
Ambiguous column name error in elation_connector file elation_stage__medication_fill.sql
Describe the bug
I get an error for the elation_connector file elation_stage__medication_fill.sql.
ambiguous column name 'DAYS_SUPPLY'
To Reproduce
- Clone elation_connector repo, install dbt, add profiles.yml to connect to your data
- In terminal,
dbt deps
,dbt seed
thendbt run
(ordbt run --select elation_stage__medication_fill
) - You should get the error.
Expected behavior
Running smoothly.
I solved it locally by replacing line 31 ,days_supply
with , fill.days_supply
Screenshots If applicable, add screenshots to help explain your problem.
Environment
- Package version (e.g. 0.6.0):
- package: tuva-health/the_tuva_project version: 0.7.11
- package: dbt-labs/dbt_utils version: 1.1.1
- Data warehouse (e.g. Snowflake): snowflake
Additional context Thank you