53
edits
CloudServices/Sync/ReDash: Difference between revisions
update
(fixed formatting) |
(update) |
||
| Line 1: | Line 1: | ||
=== 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. | 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. | ||
| Line 17: | Line 19: | ||
| deviceid || varchar || Browser profile id? Not currently captured. | | deviceid || varchar || Browser profile id? Not currently captured. | ||
|- | |- | ||
| when || bigint || Linux time stamp of when error occurred. | | when || bigint || Linux time stamp of when error occurred. Make sure to put in "quotes" since when is a reserved SQL word. | ||
|- | |- | ||
| took || bigint || ??? | | took || bigint || ??? | ||
| Line 25: | Line 27: | ||
| status || row(sync varchar, service varchar) || ?? | | status || row(sync varchar, service varchar) || ?? | ||
|- | |- | ||
| why || 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)))) || ?? | | 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)))) || ?? | ||