We have developed several dbt-jobs as part of Active Moderators metrics and Active UWERs metrics. They need manual backfilling.
Note: Before the backfilling, [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/merge_requests/114 | MR !114 ]] should be merged.
Note: These models were previously run as tests, and data tables resulted from those runs. The models have been revised since then. So before backfilling, all of the current data in the tables should be deleted.
**The following models can be run in parallel:**
2020-07 onwards for
- base_moderator_actions_history
- base_moderator_actions_logging
- base_moderator_actions_reverts
- base_moderator_actions_suppression
2024-09 onwards for
- base_moderator_actions_checkuser
2025-03-01 through 2026-04-30
- base_moderator_actions_html_historical
2026-05-01 through 2026-06-30
- base_moderator_actions_html
**After the above, the following backfill can be run:**
- backfill 2020-07-01 onwards
- [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/blob/main/models/movement-insights-contributors-metrics/base/base_moderator_actions.sql?ref_type=heads | base_moderator_actions.sql ]]