Closed Bug 1395268 Opened 7 years ago Closed 7 years ago

Add isWebExtension to addons dataset and backfill

Categories

(Data Platform and Tools Graveyard :: Datasets: Addons, enhancement, P1)

enhancement

Tracking

(Not tracked)

RESOLVED WONTFIX

People

(Reporter: bmiroglio, Assigned: amiyaguchi)

References

Details

With 57, much of my current analysis calls for filtering to WebExtensions, however this dataset doesn't have it :(. The plan is to add the field addon_aggregates which is derived from the addons dataset.
Blocks: 1395275
The isWebExtension field is in the addons dataset from 20160609. I'd want this backfilled from 20161104 to 20170608 so it can be reflected in the addon_aggregates dashboard: https://sql.telemetry.mozilla.org/dashboard/add-on-okrs_1
Assignee: nobody → amiyaguchi
Points: --- → 2
Priority: -- → P2
Priority: P2 → P1
It looks like the `isWebExtension` field was added to Firefox 55 (hitting release on 2017-08-08) in bug 1357460 and subsequently added to the addons_v2 table in bug 1360177. Make sure to add `.option("mergeSchema", "true")` when calling the parquet reader to get the up to date schema.
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → WONTFIX
Product: Data Platform and Tools → Data Platform and Tools Graveyard
You need to log in before you can comment on or make changes to this bug.