CloudServices/Sync/ReDash: Difference between revisions

Filled out more fields.
(First cut at describing the sync_events_v1 table.)
(Filled out more fields.)
Line 136: Line 136:
|-
|-
| event_map_values || map(varchar, varchar) || Additional data specific to this event.
| event_map_values || map(varchar, varchar) || Additional data specific to this event.
|-
| event_flow_id || varchar || An ID used to identify a pair of commands which span multiple devices (todo: explain this!)
|-
|-
| event_device_id || varchar || If this event is being targeted at a different sync device, this is the ID of the target.
| event_device_id || varchar || If this event is being targeted at a different sync device, this is the ID of the target.
|-
|-
| event_flow_id || varchar || An ID used to identify a pair of commands which span multiple devices (todo: explain this!)
| event_device_version || varchar || If this event is being targeted at a different sync device, this is the Firefox version it is running.
|-
| event_device_version || varchar ||
|-
|-
| event_device_os || varchar ||
| event_device_os || varchar || If this event is being targeted at a different sync device, this is the OS it is running
|-
|-
| submission_date_s3 || varchar ||
| submission_date_s3 || varchar || The date this ping was submitted.
|}
|}


=== Query Examples ===
=== Query Examples ===
Confirmed users
98

edits