PSI added the dbt model time_to_revert_bad_faith_edits and scheduled it to update monthly via AirFlow, in T425105.
We now need to set up a dashboard on Superset so the team can view the data.
| Title | Reference | Author | Source Branch | Dest Branch | |
|---|---|---|---|---|---|
| Calculate start_date from end_date in time_to_revert_bad_faith_edits | repos/data-engineering/dbt-jobs!60 | tchanders | psi-start-date | main | |
| Remove start_date variable from product-safety-and-integrity.yaml | repos/data-engineering/airflow-dags!2234 | tchanders | psi-remove-date-variable | main |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | MaCollins-WMF | T424713 DE4 - Same-day handling of bad-faith content | |||
| Resolved | Tchanders | T425527 Set up Superset dashboard for monitoring DE4 metric time to revert bad-faith edits | |||
| Resolved | Tchanders | T425105 Add model for DE4 metric (time to revert bad-faith edit) to dbt-jobs |
The dashboard is available here: https://superset.wikimedia.org/superset/dashboard/788
- The dashboard has charts for English, German, Spanish, Japanese, and French Wikipedias
Given that we will track multiple metrics in this dashboard, we combine all 5 wikis for the same metric in one chart, to make the dashboard easier to read
tchanders opened https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/merge_requests/2234
Remove start_date variable from product-safety-and-integrity.yaml
tchanders opened https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/merge_requests/60
Calculate start_date from end_date in time_to_revert_bad_faith_edits
amastilovic merged https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/merge_requests/60
Calculate start_date from end_date in time_to_revert_bad_faith_edits
amastilovic merged https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/merge_requests/2234
Remove start_date variable from product-safety-and-integrity.yaml
There is still discussion over whether this metric needs any more changes, so let's leave this task open until those are resolved.
We should backfill the dashboard too (T424713) but that's not worth doing while the metric might still change.