• Dependencies
  • new column: mediawiki_history.event_user_is_permanent as per T356701#10237761

• HQL logic that needs to change
  • Since this logic copies user_is_anonymous from its source table, wmf.editors_daily, our task here is probably to copy the two new fields: is_temporary and is_permanent as well. This means downstream jobs might be affected.
• HQL table creation scripts that need to change
  • <<links>>
• Deployment plan script
  • <<plan steps>>
• Airflow DAG that schedules the HQL logic
  • https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/blob/main/analytics/dags/geoeditors/geoeditors_edits_monthly_dag.py

Testing notes

List of affected downstream pipelines that we discover