We have developed several dbt-jobs as part of Active Moderators metrics and Active UWERs metrics. The models need to be operationalized to automatically update each month.

I have submitted an airflow-dags MR: https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/merge_requests/2304

dbt models ready for operationalization:

• base_moderator_actions_checkuser.sql
• base_moderator_actions_history.sql
• base_moderator_actions_logging.sql
• base_moderator_actions_reverts.sql
• base_moderator_actions_suppression.sql
• base_moderator_actions_html.sql
• base_moderator_actions.sql
• Note: I have already requested a manual backfill of these models (T429995)

dbt model that does not need to be operationalized, because it's a set of purely historical data from Mar 2025-Apr 2026:

• base_moderator_actions_html_historical.sql
• Note: I have already requested a manual backfill of this model (T429995)

dbt model that will be ready for operationalization once MR !117 is merged:

• active_moderators_monthly.sql