T371258 Convert device type edits to monthly + add mobile metrics

Contributor checklist

• I have written tests for this DAG that will be merged into data-engineering/airflow-dags/tests/wmde
• I have locally ran the above tests and code quality checks as outlined in the tests section of the Airflow DAGs project readme
• I have tested the jobs for this DAG in my local database using the process defined in wmde/analytics/hql/airflow_jobs/wd_device_type_edits/_test_monthly
• I have tested the included DAGs in my local database using the process outlined in TEST_AIRFLOW_DAGS.md and the test variable files provided for each DAG
• All Hive tables that are needed by the included DAG jobs have been created and are accessible by the analytics-wmde Airflow user
  • wmde.wd_device_type_edits_monthly

Description

• T371258: Continuing this task, WMDE decided that we needed a bit more information for reporting, so this DAG and the corresponding jobs has been changed to include metrics that are based on the UI and the device of the user. This allows us to capture those users who are editing Wikidata using the desktop UI on a mobile device.

Test outputs

• wmde.wd_device_type_edits_monthly

month	total_wd_edits	total_mobile_edits_mobile_ui	total_mobile_edits_desktop_ui	total_desktop_edits_desktop_ui	total_edits_other
2024-09-01	13667908	27990	112461	1889530	11637927