CloudServices/Sync/ReDash: Difference between revisions
< CloudServices | Sync
Jump to navigation
Jump to search
(modified table and input first data) |
(filled up table) |
||
| Line 3: | Line 3: | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
! Field Names!!Data Type !!Description | ! Field Names!! Data Type !! Description | ||
|- | |- | ||
| app_build_id || varchar || Firefox build ID | | app_build_id || varchar || Firefox build ID | ||
|- | |- | ||
| | | app_display_version || varchar || | ||
|- | |- | ||
| | | app_name || varchar || | ||
|- | |- | ||
| | | app_version || varchar || | ||
|- | |- | ||
| | | uid || varchar || | ||
|- | |- | ||
| | | deviceid || varchar || | ||
|- | |- | ||
| | | when || bigint || | ||
|- | |- | ||
| | | took || bigint || | ||
|- | |- | ||
| | | failurereason || row(name varchar, value varchar) || | ||
|- | |- | ||
| | | 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 || | ||
|} | |} | ||
Revision as of 23:43, 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 |
| app_display_version | varchar | |
| app_name | varchar | |
| app_version | varchar | |
| uid | varchar | |
| deviceid | varchar | |
| when | bigint | |
| took | bigint | |
| failurereason | row(name varchar, value varchar) | |
| 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 |