bdit_data-sources
bdit_data-sources copied to clipboard
854 miovision `open_issues` for tracking and communication
What this pull request accomplishes:
- adds
miovision_api.open_issues
, a view which referencesanomalous_ranges
in a format that will be easier to share with outside parties (adds intersection / classification names+ids common to Miovision) andlast_week_volume
to find the volume (if any) from the last 7 days. - adds a new task to
miovision_check
DAG that runs weekly on Friday (execution date of Thursday) to report on any open ended issues with volumes so that they don't get stale.
Issue(s) this solves:
- #854
What, in particular, needs to reviewed:
What needs to be done by a sysadmin after this PR is merged
- [ ] create view in miovision_api (+ delete from gwolofs + edit DAG code to pull from correct schema)
- [x] test DAG: https://bditto.slack.com/archives/C04BWRWVB3L/p1712696273255669
- [x] add
api_name
to view in place ofintersection_name
once #871 gets merged