Decompose reporting views/ctas and implement dbt tests

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

Decompose reporting views/ctas and implement dbt tests #366

Closed wrridgeway closed 2 months ago

wrridgeway commented 3 months ago

Some of the reporting views and CTAS are rather unwieldy - let's decompose their CTEs into views that can be tested using dbt. Other views can be refactored using views from our default athena database to decrease the amount of code used.

Views/CTAS to decompose: reporting.res_report_summary reporting.ratio_stats

Views/CTAS to refactor: reporting.vw_assessment_roll reporting.vw_top_5

dfsnow commented 3 months ago

Let's try to break these into testable, re-usable pieces like you did for the shared model input view.