Telemetry/LongitudinalExamples

Note: There is good background in the example notebook for the longitudinal data set.

Get an overview of the longitudinal data table:

describe longitudinal_v20160229

That table has a row for each client, with columns for the different parts of the ping. Some properties are directly available to query on:

SELECT count(*) AS count
FROM longitudinal_v20160229
WHERE os = 'Linux'

Arrays

Other properties are arrays, which contain one entry for each submission from that client (newest first):

SELECT element_at(reason, 1) AS last_reason
FROM longitudinal_v20160229
WHERE os = 'Linux'

Links:

• Documentation on array functions

Maps

Links:

• Documentation on map functions