We plan to remove Help Panel-related data as we've reached the end of our data retention period, and before we do that we need to back up the Homepage-related data. This task tracks that work. Morten will back up the relevant data to a separate table in the Data Lake.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | • Rileych | T213990 [EPIC] Growth: Newcomer homepage | |||
| Resolved | nettrom_WMF | T217803 Homepage: experiment | |||
| Resolved | nettrom_WMF | T234857 Homepage: back up HelpPanel data |
Event Timeline
Comment Actions
Ran the following query to back up the data:
CREATE TABLE nettrom_growth.homepage_helppanel_backup STORED AS RCFILE AS SELECT * FROM event_sanitized.helppanel WHERE year = 2019 AND event.editor_interface IN ("homepage_help", "homepage_mentorship");
The number of events stored in the backup table corresponds to the number of relevant events in event_sanitized.helppanel.