Change Details

Migrate specifically ETL notebooks from the following repos: Scope of this task: Tables: * editor_month (currently neilpquinn) * new_editor (currently cchen) * Superset: repo_active_editors (will be renamed active editors) (currently cchen) Related notebook: https://github.com/wikimedia-research/Editing-movement-metrics to analytics/wmf-product/jobs using the instructions found here: https://gerrit.wikimedia.org/r/plugins/gitiles/analytics/wmf-product/jobs/+/refs/heads/master/movement_metrics/ (Visualization notebooks should be separate from ETL notebooks.) FYI: Readers-movement-metrics : done in T291956 Remaining Tasks: [] 1) Notification (email/Slack) re: soon to come changes to neilpquinn.editor_month - @Mayakp.wiki [] 2) Backfill new_editors - @Iflorez T287420 (related: Also: Irene is the owner that’s inserted data for the past few months, can we change the owner of new_editors to analytics-product and give analytics-product jurisdiction over changes on that data moving forward? Or does Irene remain the only one who can make changes? (FYI: T285503) Potential future Idea to fix the above: backfill > make a copy > delete the table with mixed upload owners > create new table from saved copy) [] 3) Create product Repo_active_editors ETL @Mayakp.wiki 3a) Creating - add diversity for new and returning active editors 3b) Need help : refactor combine all inserts : refactoring

Migrate specifically ETL notebooks from the following repos: Scope of this task: Tables: * editor_month (currently neilpquinn) * new_editor (currently cchen) * Superset: repo_active_editors (will be renamed active editors) (currently cchen) Related notebook: https://github.com/wikimedia-research/Editing-movement-metrics to analytics/wmf-product/jobs using the instructions found here: https://gerrit.wikimedia.org/r/plugins/gitiles/analytics/wmf-product/jobs/+/refs/heads/master/movement_metrics/ (Visualization notebooks should be separate from ETL notebooks.) FYI: Readers-movement-metrics : done in T291956 Remaining Tasks: [] 1) Notification (email/Slack) re: soon to come changes to neilpquinn.editor_month - @Mayakp.wiki [] 2) Backfill new_editors - @Iflorez T287420 (related: Also: Irene is the owner that’s inserted data for the past few months, can we change the owner of new_editors to analytics-product and give analytics-product jurisdiction over changes on that data moving forward? Or does Irene remain the only one who can make changes? (FYI: T285503) Potential future Idea to fix the above: backfill > make a copy > delete the table with mixed upload owners > create new table from saved copy) [] 3) Create product Repo_active_editors ETL @Mayakp.wiki

Migrate specifically ETL notebooks from the following repos: Scope of this task: Tables: * editor_month (currently neilpquinn) * new_editor (currently cchen) * Superset: repo_active_editors (will be renamed active editors) (currently cchen) Related notebook: https://github.com/wikimedia-research/Editing-movement-metrics to analytics/wmf-product/jobs using the instructions found here: https://gerrit.wikimedia.org/r/plugins/gitiles/analytics/wmf-product/jobs/+/refs/heads/master/movement_metrics/ (Visualization notebooks should be separate from ETL notebooks.) FYI: Readers-movement-metrics : done in T291956 Remaining Tasks: [] 1) Notification (email/Slack) re: soon to come changes to neilpquinn.editor_month - @Mayakp.wiki [] 2) Backfill new_editors - @Iflorez T287420 (related: Also: Irene is the owner that’s inserted data for the past few months, can we change the owner of new_editors to analytics-product and give analytics-product jurisdiction over changes on that data moving forward? Or does Irene remain the only one who can make changes? (FYI: T285503) Potential future Idea to fix the above: backfill > make a copy > delete the table with mixed upload owners > create new table from saved copy) [] 3) Create product Repo_active_editors ETL @Mayakp.wiki 3a) Creating - add diversity for new and returning active editors 3b) Need help : refactor combine all inserts : refactoring