Klar ios
metric-hub
Pre-defined data sources for klar_ios
. These data sources are defined in metric-hub
baseline
Client ID column: client_info.client_id
Submission Date column: None
Definition:
(
SELECT
p.*,
DATE(p.submission_timestamp) AS submission_date
FROM `moz-fx-data-shared-prod.{dataset}.baseline` p
)
events
Client ID column: client_info.client_id
Submission Date column: None
Definition:
(
SELECT
p.* EXCEPT (events),
DATE(p.submission_timestamp) AS submission_date,
event
FROM
`moz-fx-data-shared-prod.{dataset}.events` p
CROSS JOIN
UNNEST(p.events) AS event
)
metrics
Client ID column: client_info.client_id
Submission Date column: None
Definition:
(
SELECT
p.*,
DATE(p.submission_timestamp) AS submission_date
FROM `moz-fx-data-shared-prod.{dataset}.metrics` p
)
mobile_search_clients_engines_sources_daily
Client ID column: client_id
Submission Date column: submission_date
Definition:
(
SELECT *
FROM `mozdata.search.mobile_search_clients_engines_sources_daily`
WHERE app_name = 'Klar' and os = 'iOS'
)