Closed Bug 1526048 Opened 7 years ago Closed 7 years ago

Repair devtools dashboards

Categories

(Data Science :: Dashboard, task)

Product:
Data Science
Component:
Dashboard
Type:
task
Priority:
Not set
Severity:
normal
Points:
1

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: tdsmith, Assigned: tdsmith)

Details

Brief description of the request:

Several of the plots at https://sql.telemetry.mozilla.org/dashboard/-devtools-panels and https://sql.telemetry.mozilla.org/dashboard/-devtools-inspector have stopped updating.

This seems to be linked to a Presto change last fall that caused expressions of the form date_parse(submission_date_s3, '%Y-%m-%dT00:00:00.000Z') to stop working as expected.

It works to replace these with e.g. date_parse(substr(submission_date_s3, 1, 10), '%Y-%m-%d').

:mbalfanz flagged the console and inspector plots as particularly urgent so I went ahead and updated those but won't have time for the others today.

It would be great to throw these queries in a repo controlled by stmocli.

Assignee: nobody → cdowhygelund
Status: NEW → ASSIGNED
Assignee: cdowhygelund → tdsmith

New SQL pushed to stmo.

Status: ASSIGNED → RESOLVED
Closed: 7 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.