[session length] Drop test data, tables and dashboards; and clean production data
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	mforns
	Apr 15 2021, 1:56 PM

Description

There were some Hive tables that we used for session length testing that are not necessary any more.
Those tables had associated data in HDFS, as well as Superset charts and dashboards.
I removed all of them.

Also, the production intermediate table wmf.session_length_daily had some incorrect data up to March 18th (included),
because of T277515 and https://gerrit.wikimedia.org/r/c/mediawiki/extensions/WikimediaEvents/+/672722.
I deleted the data from early March 2021 up to the 18th, included.

Related Objects

Mentioned Here: T277515: [Session Length] Missing sessions

Event Timeline

mforns created this task.Apr 15 2021, 1:56 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 15 2021, 1:56 PM

mforns moved this task from Inbox to Sign-off on the Better Use Of Data board.Apr 15 2021, 1:56 PM

This is done!

kzimmerman triaged this task as Medium priority.Apr 21 2021, 6:23 PM

kzimmerman closed this task as Resolved.Apr 23 2021, 10:53 PM

[session length] Drop test data, tables and dashboards; and clean production dataClosed, ResolvedPublicActions

Description

Related Objects

Event Timeline

[session length] Drop test data, tables and dashboards; and clean production data
Closed, ResolvedPublic
Actions