Page MenuHomePhabricator

Rerun trust_safety_metrics queries for March 2025
Closed, ResolvedPublic

Description

The duplicate revisions and excess reverts in the 2025-03 snapshot of MediaWiki History (T391708) affected the March aggregates from the trust_safety_metrics DAG. This subsequently affects the dashboards that displays the data.

  • Rerun all the queries to generate the monthly and daily aggregates, found in product-analytics/data-pipelines/trust_safety_metrics on GitLab
    • generate_admin_action_daily.hql
    • generate_admin_action_monthly.hql
    • generate_admin_monthly.hql
    • generate_admin_request_monthly_table.hql
    • generate_block_daily.hql
    • generate_block_monthly.hql
    • generate_new_admin_monthly.hql

Event Timeline

nettrom_WMF updated the task description. (Show Details)

Might be easier to do this through Airflow. Waiting for the DAG errors to go away first, though.

This has been completed by rerunning the Airflow DAGs for that snapshot. Thanks to the Data Engineering ops team!