Content Translation suggestions daily DAG (!1209) · 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 ("LDAP") to your Phabricator account. If none of these apply, file an unlock request to expedite access. Only if you are WMF staff: Create your GitLab account, have "Wmf" group membership in IDM, link your Developer account ("LDAP") to your Phabricator account, and get automatically approved.

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

KCVelaga requested to merge kcvelaga/airflow-dags-fork-kcv:cx-suggestions-daily-dag into main Apr 03, 2025

DAG to aggregate metrics related to user interactions with Content Translation suggestions menu, daily.
Additionally, fetches and updates the exclude user tables, to be reused in the aggregations query.

The DAG has been tested using the development instance

Verified the output data:

sudo -u analytics-privatedata spark3-sql -e "select * from kcvelaga.test_cx_exclude_users"

sudo -u analytics-privatedata spark3-sql -e "select * from kcvelaga.test_cx_suggestions_menu_interactions_daily"