tuva icon indicating copy to clipboard operation
tuva copied to clipboard

Ambiguous column name error in elation_connector file elation_stage__medication_fill.sql

Open galletsophie opened this issue 3 months ago • 0 comments

Describe the bug I get an error for the elation_connector file elation_stage__medication_fill.sql. ambiguous column name 'DAYS_SUPPLY'

To Reproduce

  1. Clone elation_connector repo, install dbt, add profiles.yml to connect to your data
  2. In terminal, dbt deps, dbt seed then dbt run (or dbt run --select elation_stage__medication_fill)
  3. 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

galletsophie avatar Mar 19 '24 19:03 galletsophie