Among the movement_metric job queries, one inserts data into wmf_product.new_editors. We should migrate it to an Airflow job.
- Write updated SQL queries for table creation and updating
- Confirm new query output matches old
- Write Airflow job
- Test job on analytics client
- Write tests
- Get job merged
- Deploy job
- Create new table (wmf_contributors.new_editor)
- Unpause job
- Backfill table using a duplicate-free snapshot of mediawiki_history (T369851)
- Update metric queries to use new table
- Document new table in DataHub