Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AHRQ data mart giving error when tuva_marts_enabled = false #668

Open
VJBHUM opened this issue Nov 18, 2024 · 4 comments
Open

AHRQ data mart giving error when tuva_marts_enabled = false #668

VJBHUM opened this issue Nov 18, 2024 · 4 comments
Assignees
Labels
bug Something isn't working

Comments

@VJBHUM
Copy link

VJBHUM commented Nov 18, 2024


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_measures__pqi_summary' (models\ahrq_measures\pqi\final\ahrq_measures__pqi_summary.sql) depends on a node named 'pqi__measures' which is disabled


Environment - Required

  • Tuva project package version (e.g. 0.6.0): [">=0.12.0","<0.13.0"]
  • dbt version (e.g. 1.7): 1.8.8
  • dbt type (e.g. dbt cloud or dbt CLI): dbt CLI
  • Data warehouse (e.g. Snowflake): postgres=1.8.2

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.

@VJBHUM VJBHUM added the bug Something isn't working label Nov 18, 2024
@sarah-tuva
Copy link
Member

sarah-tuva commented Nov 18, 2024

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
Copy link
Author

VJBHUM commented Nov 19, 2024

Cool. Thanks Sarah.

@sarah-tuva
Copy link
Member

@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.

enabled: "{{ var('quality_measures_pqi',var('tuva_marts_enabled',True)) }}"

enabled: "{{ var('quality_measures_pqi',var('tuva_marts_enabled',True)) }}"

@sarah-tuva sarah-tuva changed the title Demo project AHRQ data mart giving error when tuva_marts_enabled = false Nov 19, 2024
@sarah-tuva
Copy link
Member

Updated the title to better reflect the issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants