ccao-data / data-architecture

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

Update `row_values_match_after_join` test to handle column aliases #405

Open dfsnow opened 5 months ago

dfsnow commented 5 months ago

[Suggestion, non-blocking] Yup, I support updating the row_values_match_after_join to make this easier. Here's how we do it in the res_class_matches_pardat generic:

https://github.com/ccao-data/data-architecture/blob/e313087555fa3afebd91e16445640947175a1570/dbt/tests/generic/test_res_class_matches_pardat.sql#L50-L78

I'm fine with breaking this out into its own issue to avoid blocking this PR.

_Originally posted by @jeancochrane in https://github.com/ccao-data/data-architecture/pull/400#discussion_r1573025466_