CX Translators daily DAG (!1288) · 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.

The source project of this merge request has been removed.

Fetches the cx_translators data (a MariaDB extension table) and loads to wmf_product.cx_translators in Data Lake.
- https://www.mediawiki.org/wiki/Extension:ContentTranslation/cx_translators_table
The data is intended to be reused by other pipeline to calculate aggregate metrics.
The DAG uses a Python job repo (script) to fetch from MariaDB extension replicas and load to Data Lake.

Testing results

Verified the results using:

sudo -u analytics-privatedata spark3-sql -e "select * from ``kcvelaga.af``_test_cx_translators limit 5"

sudo -u analytics-privatedata spark3-sql -e "select count(DISTINCT translator_user_id) from kcvelaga.af_test_cx_translators"

Spark master: local[*], Application Id: local-1746605135187
count(DISTINCT translator_user_id)
202283
Time taken: 4.498 seconds, Fetched 1 row(s)