Change Details

We have developed several dbt-jobs as part of Active Moderators metrics and Active UWERs metrics. These models were previously run as tests; but the data in the tables that resulted from those runs should be deleted. After deleting those previous tables, the monthly jobs need a manual backfill. **The following models can be run in parallel:** - backfill 2020-07-01 to 2026-05-31 - [[ 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 ]] - [[ 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 ]] - backfill 2025-03-01 to 2026-04-30 - [[ 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 ]] - backfill 2026-05-01 to 2026-05-31 - [[ 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 ]] **After the above, the following model can be run:** - backfill 2020-07-01 to 2026-05-31 - [[ 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 ]]

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 to 2026-05-31 - [[ 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 ]] - [[ 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 ]] - backfill 2025-03-01 to 2026-04-30 - [[ 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 ]] - backfill 2026-05-01 to 2026-05-31 - [[ 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 ]] **After the above, the following model can be run:** - backfill 2020-07-01 to 2026-05-31 - [[ 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 ]]

We have developed several dbt-jobs as part of Active Moderators metrics and Active UWERs metrics. These models were previously run as tests; but the data in the tables that resulted from those runs should be deleted. After deleting those previous tables, the monthly jobs need a manual backfilly 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 to 2026-05-31 - [[ 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 ]] - [[ 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 ]] - backfill 2025-03-01 to 2026-04-30 - [[ 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 ]] - backfill 2026-05-01 to 2026-05-31 - [[ 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 ]] **After the above, the following model can be run:** - backfill 2020-07-01 to 2026-05-31 - [[ 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 ]]