CloudServices/Sync/ReDash

< CloudServices‎ | Sync
Revision as of 23:50, 13 October 2016 by Adavis (talk | contribs) (added descriptions)

The Sync team's telemetry goes through our data pipeline and lands in Presto to be explored in Re:Dash. Below is a description of the data available in the sync_summary table.

Field Names Data Type Description
app_build_id varchar Firefox build ID (e.g. 20160801085519)
app_display_version varchar Firefox version (e.g. 50.0a2)
app_name varchar Platform?
app_version varchar What's the difference with app_display_version?
uid varchar Hashed Sync/FxA ID
deviceid varchar Browser profile id? Not currently captured.
when bigint Linux time stamp of when error occurred.
took bigint ???
failurereason row(name varchar, value varchar) Sync failure reason
status row(sync varchar, service varchar) ??
why varchar ??
engines array(row(name varchar, took bigint, status varchar, failureReason row(name varchar, value varchar), incoming row(applied bigint, failed bigint, newFailed bigint, reconciled bigint), outgoing array(row(sent bigint, failed bigint)))) ??
submission_date_s3 varchar ??