Page MenuHomePhabricator

Drop GettingStarted* data
Closed, ResolvedPublic

Description

Per T306879: Finish decommissioning the GettingStarted* instruments, the following tables can be dropped:

[0]
show tables in event_sanitized like 'gettingstarted*';

gettingstartedredirectimpression
[1]
show tables in event like 'gettingstarted*';

gettingstartedredirectimpression

Event Timeline

Should we also remove the tables and data from the event database?

phuedx renamed this task from Drop sanitized GettingStarted* data to Drop GettingStarted* data.May 26 2022, 9:26 AM
phuedx updated the task description. (Show Details)

Should we also remove the tables and data from the event database?

Yes. AFAICT they're both empty.

Milimetric added a subscriber: Milimetric.
drop table event_sanitized.gettingstartedredirectimpression;
drop table event.gettingstartedredirectimpression;

sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event_sanitized/gettingstartedredirectimpression
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event/gettingstartedredirectimpression
Milimetric triaged this task as Medium priority.