creationdate is null for all rows in mobile_clients

RESOLVED FIXED

Status

Cloud Services
Metrics: Pipeline
P1
normal
RESOLVED FIXED
10 months ago
9 months ago

People

(Reporter: gfritzsche, Assigned: frank)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

Attachments

(2 attachments)

(Reporter)

Description

10 months ago
Looking into this, the job for mobile_clients [0] uses the wrong field name `creationDate`.
Per the docs [1] and prior validation [2], this should use the field `created`.

0: https://github.com/mozilla-services/data-pipeline/blob/master/reports/mobile_clients/mobile-clients.ipynb
1: http://gecko.readthedocs.io/en/latest/toolkit/components/telemetry/telemetry/data/core-ping.html
2: https://gist.github.com/georgf/56449b46623ce2493b01a82d0dd08e6e

Comment 1

10 months ago
please update with priority and scope
Assignee: nobody → fbertsch
(Assignee)

Updated

10 months ago
Points: --- → 1
Priority: -- → P1
(Assignee)

Comment 2

10 months ago
Created attachment 8824635 [details] [review]
PR
Attachment #8824635 - Flags: review?(mdoglio)
(Assignee)

Comment 3

10 months ago
I don't think this is used for anything at the moment, so we won't worry about backfill.

Updated

10 months ago
Attachment #8824635 - Flags: review?(mdoglio) → review+

Comment 4

10 months ago
The mobile_clients job failed three times last night. :frank can you please check what's going on?
(Assignee)

Comment 5

10 months ago
Created attachment 8825532 [details] [review]
Fix Improper Creation Dates
Attachment #8825532 - Flags: review?(mdoglio)

Updated

9 months ago
Attachment #8825532 - Flags: review?(mdoglio) → review+
(Assignee)

Comment 6

9 months ago
This is running successfully and data has been backfilled.
Status: NEW → RESOLVED
Last Resolved: 9 months ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.