T341330 add monthly wd rest api metrics dag + dir doc files (!631) · Merge requests · repos / data-engineering / Airflow DAGs · GitLab

How to register an account on GitLab. Due to spam, new accounts are locked until approved by an admin or the approver bot. Your GitLab account gets automatically approved within one hour if you are a member of Trusted Contributors in Gerrit, or a member of the Trusted-Contributors group in Phabricator and linked your Developer account to your Phabricator account. If none of these apply, you can file an unlock request to expedite access.

Support: mw:GitLab, how to host a project on GitLab, #wikimedia-gitlab on libera.chat, #GitLab on Phabricator.

🚨THIS IS A REPLICA🚨 -- You probably want to use the production gitlab, https://gitlab.wikimedia.org. Data on this instance is likely to be overwritten at short notice. Login with hardware 2FA key does not work, please use one-time passwords.

Andrew McAllister (WMDE) requested to merge T341330-wd-rest-api-monthly-metrics into main Mar 22, 2024

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 as outlined in the tests section of the Airflow DAGs project readme
I have tested the jobs for this DAG using a process in wmde/analytics/hql/airflow-jobs/wd_rest_api_metrics/_test_monthly

Description

Adds a monthly DAG that will calculate reporting metrics for the Wikidata REST API
- total_user_agents
- total_filtered_user_agents (filter out outlier activity UAs)
- total_ips
The assosciated jobs can be found at wmde/analytics/hql/airflow-jobs/wd_rest_api_metrics

Any feedback would be much appreciated!

Related task

T341330

Edited Mar 26, 2024 by Andrew McAllister (WMDE)