CloudServices/Sync/ReDash: Difference between revisions
< CloudServices | Sync
Jump to navigation
Jump to search
(filled up table) |
(added descriptions) |
||
| Line 5: | Line 5: | ||
! Field Names!! Data Type !! Description | ! Field Names!! Data Type !! Description | ||
|- | |- | ||
| app_build_id || varchar || Firefox build ID | | app_build_id || varchar || Firefox build ID (e.g. 20160801085519) | ||
|- | |- | ||
| app_display_version || varchar || | | app_display_version || varchar || Firefox version (e.g. 50.0a2) | ||
|- | |- | ||
| app_name || varchar || | | app_name || varchar || Platform? | ||
|- | |- | ||
| app_version || varchar || | | app_version || varchar || What's the difference with app_display_version? | ||
|- | |- | ||
| uid || varchar || | | uid || varchar || Hashed Sync/FxA ID | ||
|- | |- | ||
| deviceid || varchar || | | deviceid || varchar || Browser profile id? Not currently captured. | ||
|- | |- | ||
| when || bigint || | | when || bigint || Linux time stamp of when error occurred. | ||
|- | |- | ||
| took || bigint || | | took || bigint || ??? | ||
|- | |- | ||
| failurereason || row(name varchar, value varchar) || | | failurereason || row(name varchar, value varchar) || Sync failure reason | ||
|- | |- | ||
| status || row(sync varchar, service varchar) || | | status || row(sync varchar, service varchar) || ?? | ||
|- | |- | ||
| why || 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)))) | | 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 || | | submission_date_s3 || varchar || ?? | ||
|} | |} | ||
Revision as of 23:50, 13 October 2016
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 | ?? |