Change Details

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-05-31 (inclusive) - [[ 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 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 ]] - backfill 2026-05-01 through 2026-05-31 (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 ]] **After the above, the following model can be run:** - backfill 2020-07-01 through 2026-05-31 (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 ]]

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-05-31 (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 ]] - backfill 2024-09-01 through 2026-05-31 (inclusive) - - [[ 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 ]] - 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 ]] - backfill 2026-05-01 through 2026-05-31 (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 ]] **After the above, the following model can be run:** - backfill 2020-07-01 through 2026-05-31 (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 ]]

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-05-31 (inclusive) - [[ 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 2024-09-01 through 2026-05-31 (inclusive) - - [[ 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 ]] - 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 ]] - backfill 2026-05-01 through 2026-05-31 (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 ]] **After the above, the following model can be run:** - backfill 2020-07-01 through 2026-05-31 (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 ]]