cal-itp / data-infra

Cal-ITP data infrastructure
https://docs.calitp.org/data-infra
GNU Affero General Public License v3.0
48 stars 13 forks source link

User Story: notifications of changes in Fares v2 status for certain feeds #2202

Open evansiroky opened 1 year ago

evansiroky commented 1 year ago

Summary

  1. As a MSD representative making sure we maximize the amount of feeds with Fares v2 data
  2. I want to be notified at least daily if any feeds drop or add Fares v2 data completely
  3. So that I can reach out to the respective vendor to ensure their commitment to maintain this data is being followed-through upon

Acceptance Criteria

  1. When a feed associated with a particular vendor drops or adds Fares v2 in entirety from its feed
  2. A notification email should be sent that notes which feeds had the data added or dropped

Also, here are a few points that need to be addressed:

  1. This effort is currently associated with a single vendor

Tester [Stakeholder]

1.

Sprint Ready Checklist

    • [ ] Acceptance criteria defined
    • [ ] Team understands acceptance criteria
    • [ ] Team has defined solution / steps to satisfy acceptance criteria
    • [ ] Acceptance criteria is verifiable / testable
    • [ ] External / 3rd Party dependencies identified
evansiroky commented 1 year ago

I tentatively have a solution for this with the 2 following Metabase questions that have email alerts setup:

q1, q2

If this solution seems to work, I will close this issue.