CloudServices/Sync/ReDash: Difference between revisions

CloudServices/Sync/ReDash (view source)

Revision as of 18:15, 20 June 2017

1,045 bytes added , 20 June 2017

→‎telemetry.sync_bmk_validation_problems: added data to table

Adavis

53

edits

@@ Line 205: / Line 205: @@
 {| class="wikitable"
 |-
-! Header text !! Header text !! Header text
+! Field name !! Data type !! Description
 |-
-| Example || Example || Example
+| app_build_id || varchar || Firefox build ID (e.g. 20160801085519)
 |-
-| Example || Example || Example
+| app_version || varchar || Firefox version (e.g. 50.0a2) - corresponds to the MOZ_APP_VERSION configure value
 |-
-| Example || Example || Example
+| app_display_version || varchar || The application version as shown in the about dialog. Almost always identical to app_version. Corresponds to the  MOZ_APP_VERSION_DISPLAY configure value.
 |-
-| Example || Example || Example
+| app_name || varchar || Will always be the string "Firefox" in desktop submitted pings.
 |-
-| Example || Example || Example
+| app_channel || varchar || The update channel (e.g. "release", "nightly", etc) - corresponds to the  MOZ_UPDATE_CHANNEL config variable.
 |-
-| Example || Example || Example
+| uid || varchar || Hashed Sync/FxA ID
 |-
-| Example || Example || Example
+| deviceid || varchar || Hashed FxA device ID.
 |-
-| Example || Example || Example
+| submission_day || integer || Date data was added to Presto (e.g. 20170324)
 |-
-| Example || Example || Example
+| sync_day || integer || Date of sync. (e.g. 20170320)
 |-
-| Example || Example || Example
+| when || bigint || Unix timestamp of when sync occurred. Make sure to put in "quotes" since when is a reserved SQL word. Note that because this is taken from the client's clock, the time may be wildly inaccurate.
 |-
-| Example || Example || Example
+| status || row(sync varchar, service varchar) || The status of sync after completion, or null is both statuses record success.
 |-
-| Example || Example || Example
+| engine_name || string || Should always be '''bookmarks''' in this table.
 |-
-| Example || Example || Example
+| engine_status || varchar || The status of this engine after sync completed, or null if the status reflects success.
 |-
-| Example || Example || Example
+| engine_failure_reason || row(name varchar, value varchar) || Details of any errors recorded during the sync of this engine, or null on success.
 |-
 | Example || Example || Example