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.
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.