search

tuva-health / tuva

Main repo including core data model, data marts, reference data, terminology, and the clinical concept library
https://thetuvaproject.com/
192 stars 50 forks source link

AHRQ data mart giving error when tuva_marts_enabled = false #668

Open VJBHUM opened 4 days ago

VJBHUM commented 4 days ago

Describe the bug - Required Running demo project with tuva_marts_enabled: false Running with dbt=1.8.8 and postgres=1.8.2 dbt build command results into Compilation Error Model 'model.the_tuva_project.ahrq_measurespqi_summary' (models\ahrq_measures\pqi\final\ahrq_measures__pqi_summary.sql) depends on a node named 'pqimeasures' which is disabled

Environment - Required

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Additional context Add any other context about the problem here.

sarah-tuva commented 4 days ago

Thanks for submitting this bug. We will look into it. Is there a reason you are running the demo with all the marts disabled? There may be another way to accomplish what you are trying to do.

VJBHUM commented 3 days ago

Cool. Thanks Sarah.

sarah-tuva commented 3 days ago

@bradmontierth can you take this bug? I think the issue is related to the AHRQ seeds. The enabled variable for the seeds doesn't match the data mart models.

https://github.com/tuva-health/tuva/blob/42913694811dcf2e58dc4fc955269fe4ed2947d7/seeds/value_sets/ahrq_measures/pqi__seeds.yml#L12

https://github.com/tuva-health/tuva/blob/42913694811dcf2e58dc4fc955269fe4ed2947d7/seeds/value_sets/ahrq_measures/pqi__seeds.yml#L38

sarah-tuva commented 3 days ago

Updated the title to better reflect the issue.