Draft: Import canonical_data.countries through Airflow (!7) · Merge requests · repos / movement-insights / canonical-data · 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.

Take the 2024 Developer Satisfaction Survey ^{(privacy statement)} to help identify areas for improvement and measure satisfaction within the Wikimedia developer community.

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

Neil Shah-Quinn (WMF) requested to merge github/fork/aquwikimedia/T338033_update_disallowed_countries_list_for_geoeditors into main Jun 13, 2023

Created by: aquwikimedia

We would like to mutualize static data from analytics-refinery: https://github.com/wikimedia/analytics-refinery/blob/master/static_data/mediawiki/geoeditors/blacklist/country_codes.tsv with the data in country/coutries.tsv .

In this patch, you will find the HQL script to create the table and the Python script to be triggered by Airflow.

The airflow job is in this patch: repos/data-engineering/airflow-dags!428 (merged)

As we are going to use the countries data in this repo around analytics-refinery, it will perform the changes:

6 countries were not allowed to be released and are going to be released by this change: Burundi, Equatorial Guinea, Lybia, Singapore, Somalia, Tajikistan
5 countries were allowed to be released and are going to be disallowed by this change: Bangladesh, Honduras, Kuwait, Nicaragua, Oman

The mutualization job in analytics-refinery: https://gerrit.wikimedia.org/r/c/analytics/refinery/+/929723

Edited Dec 02, 2024 by Neil Shah-Quinn (WMF)