Backfill the EnrollmentEvents table from Amplitude/Metabase data - Githubissues

cal-itp / benefits

Transit benefits enrollment, minus the paperwork.

https://docs.calitp.org/benefits

GNU Affero General Public License v3.0

27 stars 9 forks source link

Backfill the EnrollmentEvents table from Amplitude/Metabase data #2436

Open thekaveman opened 3 weeks ago

thekaveman commented 3 weeks ago

This is blocked until https://github.com/cal-itp/data-infra/pull/3468 is complete and merged.

We want to take this historical enrollment record from Amplitude/Metabase and backfill our newly created local EnrollmentEvent table in the app.

The general approach could be something like:

Download all enrollment events from Metabase as JSON
Transform into a Django fixture JSON structure
Download the production database locally
Use manage.py loaddata <fixtures> to load the fixtures in
Re-upload and overwrite the production database

Acceptance criteria

[ ] All historical enrollments (156 as of 10/08/2024) are represented accurately within the prod Admin interface EnrollmentEvents table.
[ ] The Amplitude/Metabase property event_time is used for the EnrollmentEvent.enrollment_datetime value
[ ] EnrollmentEvent.enrollment_method is DIGITAL for all backfilled events

thekaveman commented 1 day ago

Blocked until https://github.com/cal-itp/data-infra/pull/3518 is merged.