ccao-data / data-architecture

Codebase for CCAO data infrastructure construction and management
https://ccao-data.github.io/data-architecture/
5 stars 3 forks source link

Configure high availability on all dbt tables #462

Closed jeancochrane closed 1 month ago

jeancochrane commented 1 month ago

This PR updates all of our dbt tables to be high availability by default. This change should prevent downtime when building a new version of a table.

I tested this by running the build-and-test-dbt workflow on CI on two models, reporting.ratio_stats (a Python model) and proximity.dist_pin_to_hospital (a SQL model), and confirmed that I could query both tables while they were being rebuilt.

Closes #460.