Among the movement_metric job queries, one inserts data into wmf_product.content_interactions.
This is relatively low priority, since it is only used by the readers metrics Superset dashboard. However, in the long run, all recurring jobs should be migrated to Airflow.
- Write updated SQL queries for table creation and updating
- Confirm new query output matches old
- Write Airflow job
- Test job on analytics client
- Get job merged
- Deploy job
- Create new table (wmf_readership.content_interactions_monthly)
- Unpause job
- Backfill table
- Update metric queries to use new table
- Update Superset dashboard to use new table
- Document new table in DataHub