Page MenuHomePhabricator

Homepage: back up HelpPanel data
Closed, ResolvedPublic

Description

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.

Event Timeline

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.

nettrom_WMF closed this task as Resolved.Oct 15 2019, 3:55 PM

This work is done.