Page MenuHomePhabricator

Update the content_interactions table with an Airflow job
Open, HighPublic

Description

Among the movement_metric job queries, one inserts data into wmf_product.content_interactions. We should migrate it to an Airflow job.

  • Write updated SQL queries for table creation and updating
  • Write Airflow DAG
  • Build new version of table and check output
  • Update metric queries to use new table
  • Update Superset dashboard to use new table
  • Document new table in DataHub
  • Remove old generation code
  • Drop old table
  • Remove generation code for wmf_product.pageviews_corrected
  • Drop wmf_product.pageviews_corrected