53
edits
Changes
update
=== Table Described ===
The Sync team's telemetry goes through our data pipeline and lands in Presto to be explored in [https://sql.telemetry.mozilla.org/ Re:Dash]. Below is a description of the data available in the '''sync_summary''' table.
| deviceid || varchar || Browser profile id? Not currently captured.
|-
| when || bigint || Linux time stamp of when error occurred. Make sure to put in "quotes" since when is a reserved SQL word.
|-
| took || bigint || ???
| status || row(sync varchar, service varchar) || ??
|-
| why || varchar || ??Always null because XYZ and is meant for ABC
|-
| 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)))) || ??
