data-infra
data-infra copied to clipboard
Payments: Updates to fct_payments_rides_v2
The following modifications are suggested:
- [x] add agency_id from routes.txt or ageny_name from agencies.txt
- [ ] add a description for earliest_tap:
The earliest transaction associated with a customer_id.
- [ ] remove extra lat/long geometry in table
- [ ] add
on_
to on tap fields?