Page MenuHomePhabricator

Fix editors_daily data issue for Tuning session reporting
Closed, ResolvedPublic

Description

Hello data engineering,
A high priority item: The editors_daily table is missing data.

This query is showing only 2021-08 and 2021-09 data

SELECT DISTINCT month 
FROM wmf.editors_daily
LIMIT 10

We need to pull product editor metrics for Tuning Session and are not currently able to calculate global north new editor retention and global south new editor retention for August 2021 nor September 2021 due to missing data in this table.

Event Timeline

Iflorez triaged this task as High priority.Oct 12 2021, 6:50 PM
Iflorez created this task.
Iflorez added a subscriber: odimitrijevic.

Closing this ticket as the data is not missing. Documentation for this table notes:

editors_daily data is kept for the two latest calendar months (the month of the latest mediawiki_history snapshot and the previous). Older data may be temporarily available before it is purged, but you should not rely on this.