1275005 - Create a prototype for the bug triage dashboard based on re:dash

Status: RESOLVED FIXED

(Cloud Services Graveyard :: Metrics: Pipeline, defect, P1)

Description

[Mauro Doglio [:mdoglio]]

Let's start to explore/validate the available data using a prototype based on re:dash

Comment 1

[Mauro Doglio [:mdoglio]]

Here [1] is the code I used to extract the bug data from the bugzilla rest api; the code assigns a release cycle and channel to each bug, based on the release calendar found at [2]

[1] https://gist.github.com/maurodoglio/68673e5b9c04c7212b69414db87e5e67
[2] https://wiki.mozilla.org/RapidRelease/Calendar

Comment 2

[Mauro Doglio [:mdoglio]]

I setup up a new redash instance and I loaded the data exported with the script above.
The instance is available at http://ec2-54-201-73-200.us-west-2.compute.amazonaws.com.
I configured the re:dash authentication to work with the mozilla email accounts via Google+.

Comment 3

[Mauro Doglio [:mdoglio]]

Attachment: regression_bugs.csv

Here is the content of the regression_bugs table in csv format.

Comment 4

[Mauro Doglio [:mdoglio]]

The data etl script now lives here [1].
A visualization of the regression bugs grouped by release cycle and release channel is here [2] 

[1] https://github.com/maurodoglio/bz2db/blob/master/update_bugs.py
[2] https://sql.telemetry.mozilla.org/queries/567#955