canmove, Confirmed users, Bureaucrats and Sysops emeriti
2,798
edits
Mobile/Metrics/Redash: Difference between revisions
m
→Data Tables / Schemas
MarkFinkle (talk | contribs) m (→Useful Queries) |
MarkFinkle (talk | contribs) |
||
| Line 41: | Line 41: | ||
sessions varchar sessions associated with the event (JSON array) | sessions varchar sessions associated with the event (JSON array) | ||
experiments varchar a/b experiments associated with the event (JSON array) | experiments varchar a/b experiments associated with the event (JSON array) | ||
channel varchar channel name (partition) | |||
submission varchar submission as a string 'YYYYMMDD' (partition) | |||
The <code>android_addons_v1</code> table holds add-on and lightweight theme data. This table only has data for clients that have either: at least one add-on installed, or an active lightweight theme. Clients that have no add-ons installed and have no active lightweight theme are not included in the table. Use a <code>left join</code> to <code>android_clients_v1</code> or <code>android_events_v1</code> to create a recordset with all clients included, but nulls for clients not in the <code>android_addons_v1</code> table. | |||
clientid varchar unique identifier | |||
submissiondate timestamp when the telemetry record was received by the server | |||
addons varchar list of installed add-ons, or null (JSON array) | |||
lwt varchar active lightweight theme, or null | |||
channel varchar channel name (partition) | channel varchar channel name (partition) | ||
submission varchar submission as a string 'YYYYMMDD' (partition) | submission varchar submission as a string 'YYYYMMDD' (partition) | ||