1549591 - Firefox TV DAU/WAU/MAU dashboard stuck at 2/28/19

Status: RESOLVED FIXED

(Data Science :: Dashboard, task, P3)

Description

[Chenxia Liu [:liuche]]

Brief Description of the request (required):

The DAU/WAU/MAU part of the FFTV dashboard is stuck on 2/28 and there is no more data after it.
https://sql.telemetry.mozilla.org/dashboard/firefox-fire-tv

Business purpose for this request (required):

Basic metrics for app usage

Requested timelines for the request or how this fits into roadmaps or critical decisions (required):

We'd like this to be fixed soon because this is one of our basic metrics - the DAUs chart seems to work (but the data source is somewhere different)

Links to any assets (e.g Start of a PHD, BRD; any document that helps describe the project):

Firefox TV basic metrics

Name of Data Scientist (If Applicable):

Su Hong

Comment 1

[Tim Smith (inactive) 👨‍🔬 [:tdsmith]]

Looks like Firefox Reality was also affected.

Comment 2

[Tim Smith (inactive) 👨‍🔬 [:tdsmith]]

Resolving this as a duplicate of the Reality data pipeline bug since I believe these have the same cause and should have the same resolution (the airflow job should point to v3 of the dataset).

Comment 3

[Tim Smith (inactive) 👨‍🔬 [:tdsmith]]

:relud says the query should be updated: https://bugzilla.mozilla.org/show_bug.cgi?id=1548166#c5

Comment 4

[[e-mail]]

We'll need to confer with data engineering on this one. Adding Emily Thompson to this bug for follow-up

Comment 5

[Mark Reid [:mreid]]

The immediate issue here has been fixed (the core_client_count dataset now contains recent data). Do we want to tackle the query change here as well?

Comment 6

[Emily Thompson]

It seems that this bug can be closed? What query change did you mean Mark?

Comment 7

[Mark Reid [:mreid]]

I'm good with closing this out - the query change is in response to comment 3.