Add migration DAG for CX report (!613) · 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.

Aleksandar Mastilovic requested to merge feature/report-updater-cx into main Feb 16, 2024

Phab ticket: T356424

Migrate CX report from ReportUpdater to an Airflow DAG.

Original report updater query location: analytics-reportupdater-queries/cx/

This report directly populates a Hive table amire80.cx_abuse_filter_daily located in /user/amire80/data/cx_abuse_filter_daily on HDFS.

The HQL file referenced by this DAG is located in analytics-refinery/hql/reportupdater_queries/cx/

Gerrit review for the HQL file: https://gerrit.wikimedia.org/r/c/analytics/refinery/+/1003928