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:** - [[ 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 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 UWERSs 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 ]]