Page MenuHomePhabricator

Determine if any intermediate tables managed by the movement_metrics ETL job can be removed
Closed, ResolvedPublic

Description

It's possible that some tables managed by the movement_metrics ETL job are no longer useful and can be removed. We should audit them to determine if this is the case.

tabledecisionnotes
wmf_product.active_editorskeepused only for Superset dashboards
wmf_product.content_interactionskeepused only for Superset dashboards
wmf_product.editor_monthkeepneeded for calculating active editors
wmf_product.global_markets_pageviewsremoveWe removed all Global North/Global South metrics in T359692.
wmf_product.new_editorskeepneeded for calculating new editor retention
wmf_product.pageviews_correctedremove eventuallycan be removed after we start getting pageview metrics from the updated `content_interactions table as decided in T360491

Event Timeline

nshahquinn-wmf created this task.
nshahquinn-wmf moved this task from Incoming to Backlog on the Movement-Insights board.
nshahquinn-wmf updated the task description. (Show Details)