cal-itp
Analyst sees a dashboard representing Kuba device checkins over time
User story / feature request
As an Analyst viewing Metabase When I view the Device Health dashboard I see a representation of each fare validator checkin
Acceptance Criteria
Fare validator checkins depend on what data is available in the Kuba API
Notes
Please enter any additional information that will facilitate the completion of this ticket. For example: Are there any constraints not mentioned above? Are there any alternatives you have considered?
As of 3/11: as discussed with Phil from Kuba on the MST call, Kuba will provide API access and documentation in the form of Postman
As of 3/18: received the following postman documentation for the Kuba device monitoring API, waiting on credentials
PADMonitoringAPIs.postman_collection.zip
PAD Monitoring Service API.pdf
Talked to Phil 7/8:
- MST needs to enable access to API, blocked on a commercial agreement
- Phil is talking to Brian
- Phil and Kuba are waiting on ProData
- As per Erika Ehmsen, Capitol Corridor Joint Powers Authority didn't require a contract change for enhanced API access
/cc @HaroldBooker
This dashboard will need to update at least once an hour, so we'll need two things:
- [x] An incremental table that reprocesses the last day
- [x] A DAG that runs hourly to update the table
I asked SBMTD what they would want from a device health dashboard since they work with Kuba data already.
https://github.com/cal-itp/data-analyses/issues/1654 Related ticket about making dashboards using the data.
Just FYI, I believe @KatrinaMKaiser and @vevetron were talking about potentially having the data science team work on creating dashboards or perhpas an exploratory data analysis.
I think this might be resolved. If we want to do more things let's create more specific tickets.