1503895 - Add fuzzyfox pref to main_summary

Status: RESOLVED FIXED

(Data Platform and Tools :: General, enhancement, P2)

Description

[Tom Ritter [:tjr]]

In Bug 1432429 we added fuzzyfox to DEFAULT_ENVIRONMENT_PREFS in https://searchfox.org/mozilla-central/rev/eac6295c397133b7346822ad31867197e30d7e94/toolkit/components/telemetry/app/TelemetryEnvironment.jsm#181

This is flowing into crashstats fine, and I can find crashes associated with it.  I'd like to be able to start doing telemetry queries on it, starting with "How many clients have enabled this pref"

I was told to file a bug to have it added to main_summary so I can query it.


[Rest of the notes mostly for my own reference]

And then I can
> SELECT APPROX_DISTINCT(client_id) FROM main_summary WHERE user_pref_my_pref IS NOT NULL AND submission_date_s3 = 'some date in the recent past'

And for trends:
> SELECT DATE_PARSE(submission_date_s3, '%Y%m%d') AS submission_day, COUNT(DISTINCT client_id) AS clients FROM main_summary WHERE submission_date_s3 > '20181010' AND user_pref_my_pref IS NOT NULL GROUP BY 1

Comment 1

[GitHub Bugzilla PR Linker]

Attachment: Link to GitHub pull-request: https://github.com/mozilla/telemetry-batch-view/pull/498

Comment 2

[Mark Reid [:mreid]]

This column should start to appear in tomorrow's data.