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:**
- backfill 2020-07-01 through 2026-06-30 (inclusive)
- [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/blob/main/models/movement-insights-contributors-metrics/base/base_moderator_actions_history.sql?ref_type=heads | base_moderator_actions_history.sql ]]
- [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/blob/main/models/movement-insights-contributors-metrics/base/base_moderator_actions_logging.sql?ref_type=heads | base_moderator_actions_logging.sql ]]
- [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/blob/main/models/movement-insights-contributors-metrics/base/base_moderator_actions_reverts.sql?ref_type=heads | base_moderator_actions_reverts.sql ]]
- [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/blob/main/models/movement-insights-contributors-metrics/base/base_moderator_actions_suppression.sql?ref_type=heads | base_moderator_actions_suppression.sql ]] (although source data for this model don't exist prior to 2017-10)
- [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/blob/main/models/movement-insights-contributors-metrics/base/base_moderator_actions_checkuser.sql?ref_type=heads | base_moderator_actions_checkuser.sql ]] (although source data for this model don't exist prior to 2024-09)
- backfill 2025-03-01 through 2026-04-30 (inclusive)
- [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/blob/main/models/movement-insights-contributors-metrics/base/base_moderator_actions_html_historical.sql?ref_type=heads | base_moderator_actions_html_historical.sql ]] (source data for this model don't exist prior to 2025-03; source data for this model may exist after 2026-04, but we do not want those data due to duplication with the model below)
- backfill 2026-05-01 through 2026-06-30 (inclusive)
- [[ https://gitlab.wikimedia.org/repos/data-engineering/dbt-jobs/-/blob/main/models/movement-insights-contributors-metrics/base/base_moderator_actions_html.sql?ref_type=heads | base_moderator_actions_html.sql ]] (source data from this model exist prior to 2026-05 but we do not want those data due to data quality and duplication with the model above)
**After the above, the following model can be run:**
- backfill 2020-07-01 through 2026-06-30 (inclusive)
- [[ 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 ]]