dbt builds are failing in GitHub actions

[krishyfishy]

Describe the bug
dbt builds are currently failing in GitHub actions. This is likely because of an incompatibility between newer versions of The Tuva Project and dbt 1.6.3. Also needed here are some alterations to our synthetic data. Related PR is #49 and a related issue is #48.

To Reproduce
Run any GitHub action from main to see failing dbt runs. We are also seeing tests fail in GitHub Actions for some of our synthetic data as it gets run through the input layer.

Expected behavior
We expect CI to run without issue and tests to pass when running synthetic data through the input layer.

Screenshots

Environment

• Package version (e.g. 0.6.0):
• Data warehouse (e.g. Snowflake):

Additional context
A fix to this issue would likely come from updating dbt to a later version than 1.6.3.

[utsavpaudel]

I could not reproduce the issue mentioned. Likely @sarah-tuva has pushed a fix in tuva-public-resources/versioned_tuva_synthetic_data/0.14.0.
The S3 files updated date is May 28 which is the same date they have updated logic in https://github.com/tuva-health/generate_synthetic_data/pull/33.

@jansenpa waiting for confirmation from you that you aren't having issues anymore - before closing this issue.

[saugat-maitri]

@utsavpaudel I believe the dbt build failure in dbt version 1.6.3 is due to a casting issue in the asc__generate_encounter_id model. This issue can be resolved either by fixing the casting logic directly or by merging PR #49, which upgrades the dbt version in GitHub workflows to 1.8.6 and adds require-dbt-version: '>=1.8.6' to dbt_project.yml.

[utsavpaudel]

#55 and #53 (comment) solves this issue