For calculating Unique Editor metrics by Country (T314147) the Data Engineering team updated editors_daily table and now the user_fingerprint_or_id has been changed to user_fingerprint_or_name .
the update_global_markets_active_editors.hql query in the movement_metrics job should be updated to use this new column name, otherwise it will fail on Sep 7, 2022.
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| movement_metrics: Update global market active editors query | analytics/wmf-product/jobs | master | +5 -1 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | • EChetty | T310224 New Data Pipeline for Unique Editor metrics by Geo (Country & Region) | |||
| Resolved | xcollazo | T314147 Data Pipeline for Unique Editor metrics by Country | |||
| Resolved | kzimmerman | T316293 August 2022 Wikimedia movement metrics | |||
| Resolved | Mayakp.wiki | T316398 Update PA job for changes to editors_daily table |
Event Timeline
Comment Actions
Change 826911 had a related patch set uploaded (by Mayakpwiki; author: Mayakpwiki):
[analytics/wmf-product/jobs@master] movement_metrics: Update global market active editors query
Comment Actions
Change 826911 merged by Bearloga:
[analytics/wmf-product/jobs@master] movement_metrics: Update global market active editors query
Comment Actions
This is complete. The query was changed and job is running without failing.
Pending - remove the global market active editor query completely and update the job. This will be done in T316580