53
edits
Changes
→telemetry.sync_bmk_validation_problems: added data to table
{| class="wikitable"
|-
! Header text Field name !! Header text Data type !! Header textDescription
|-
| Example app_build_id || Example varchar || ExampleFirefox build ID (e.g. 20160801085519)
|-
| Example app_version || Example varchar || ExampleFirefox version (e.g. 50.0a2) - corresponds to the MOZ_APP_VERSION configure value
|-
| Example app_display_version || Example varchar || ExampleThe application version as shown in the about dialog. Almost always identical to app_version. Corresponds to the MOZ_APP_VERSION_DISPLAY configure value.
|-
| Example app_name || Example varchar || ExampleWill always be the string "Firefox" in desktop submitted pings.
|-
| Example app_channel || Example varchar || ExampleThe update channel (e.g. "release", "nightly", etc) - corresponds to the MOZ_UPDATE_CHANNEL config variable.
|-
| Example uid || Example varchar || ExampleHashed Sync/FxA ID
|-
| Example deviceid || Example varchar || ExampleHashed FxA device ID.
|-
| Example submission_day || Example integer || ExampleDate data was added to Presto (e.g. 20170324)
|-
| Example sync_day || Example integer || ExampleDate of sync. (e.g. 20170320)
|-
| Example when || Example bigint || ExampleUnix 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 status || Example row(sync varchar, service varchar) || ExampleThe status of sync after completion, or null is both statuses record success.
|-
| Example engine_name || Example string || ExampleShould always be '''bookmarks''' in this table.
|-
| Example engine_status || Example varchar || ExampleThe status of this engine after sync completed, or null if the status reflects success.
|-
| Example engine_failure_reason || Example row(name varchar, value varchar) || ExampleDetails of any errors recorded during the sync of this engine, or null on success.
|-
| Example || Example || Example
