Further analytics updates for Metabase pipeline - Githubissues

cal-itp / benefits

Transit benefits enrollment, minus the paperwork.

https://docs.calitp.org/benefits

GNU Affero General Public License v3.0

28 stars 9 forks source link

Further analytics updates for Metabase pipeline #2521

Closed thekaveman closed 2 weeks ago

thekaveman commented 2 weeks ago

Collecting a running list of cleanup tasks, found during work on #2436

Acceptance Criteria

`event_properties_claims_provider`

[x] convert cdt-logingov-ial2 to cdt-logingov

`event_properties_eligibility_verifier` and `user_properties_eligibility_verifier`

Convert the following to cdt-logingov

[x] (MST) CDT claims via Login.gov
[x] (SBMTD) CDT claims via Login.gov
[x] CDT claims via Login.gov (MST)
[x] CDT claims via Login.gov (SBMTD)
[x] OAuth claims via Login.gov
[x] senior

Convert the following to cdt-vagov

[x] (MST) VA.gov - Veteran
[x] VA.gov - Veteran (MST)
[x] veteran

Convert the following to https://mst-courtesy-cards-eligibility-server-prod-azcscsbmembwcugk.z01.azurefd.net/verify

[x] (MST) Courtesy Card Eligibility Server Verifier (prod)
[x] MST Courtesy Card Eligibility Server Verifier
[x] courtesy_card

Convert the following to https://sbmtd-mobility-pass-eligibility-server-prod-h3d3djedb7ahfqeg.z01.azurefd.net/verify

[x] (SBMTD) Mobility Pass Eligibility Server Verifier (prod)
[x] SBMTD Mobility Pass Eligibility Server Verifier (prod)
[x] mobility_pass

`event_properties_enrollment_group`

[x] Fix COALESCE to use json_extract_column rather than json_extract_flattened_column (this is not a list value)

Additional context