Firefox desktop
metric-hub
Pre-defined data sources for firefox_desktop
. These data sources are defined in metric-hub
browser_launched_to_handle_events
Client ID column: None
Submission Date column: None
Definition:
(
SELECT
*
FROM `mozdata.telemetry.events`
WHERE event_category = 'browser.launched_to_handle'
)
active_users_aggregates_v1
Client ID column: NULL
Submission Date column: submission_date
Definition:
(
SELECT *
FROM `moz-fx-data-shared-prod.telemetry.active_users_aggregates`
WHERE app_name = 'Firefox Desktop'
)
main
Client ID column: None
Submission Date column: None
Definition:
(
SELECT
*,
DATE(submission_timestamp) AS submission_date,
environment.experiments
FROM `moz-fx-data-shared-prod.telemetry_stable.main_v5`
)
crash
Client ID column: None
Submission Date column: None
Definition:
(
SELECT
*,
DATE(submission_timestamp) AS submission_date,
environment.experiments
FROM mozdata.telemetry.crash
)
events_memory
Client ID column: None
Submission Date column: DATE(submission_date)
Definition:
(
SELECT
*
FROM `moz-fx-data-shared-prod.telemetry.events`
WHERE
event_category = 'memory_watcher'
AND event_method = 'on_high_memory'
AND event_object = 'stats'
)
search_clients_engines_sources_daily
Client ID column: None
Submission Date column: submission_date
Definition:
mozdata.search.search_clients_engines_sources_daily
clients_daily
Client ID column: client_id
Submission Date column: submission_date
Definition:
mozdata.telemetry.clients_daily
search_clients_daily
Client ID column: None
Submission Date column: None
Definition:
mozdata.search.search_clients_engines_sources_daily
main_summary
Client ID column: None
Submission Date column: None
Definition:
mozdata.telemetry.main_summary
events
Client ID column: None
Submission Date column: None
Definition:
mozdata.telemetry.events
newtab_interactions
Client ID column: legacy_telemetry_client_id
Submission Date column: submission_date
Definition:
mozdata.telemetry.newtab_interactions
normandy_events
Client ID column: None
Submission Date column: None
Definition:
(
SELECT
*
FROM mozdata.telemetry.events
WHERE event_category = 'normandy'
)
cfr
Client ID column: None
Submission Date column: None
Definition:
(
SELECT
*,
DATE(submission_timestamp) AS submission_date
FROM `moz-fx-data-derived-datasets`.messaging_system.cfr
)
activity_stream_events
Client ID column: None
Submission Date column: None
Definition:
(
SELECT
*,
DATE(submission_timestamp) AS submission_date
FROM mozdata.activity_stream.events
)
sponsored_tiles_clients_daily
Client ID column: None
Submission Date column: submission_date
Definition:
mozdata.telemetry.sponsored_tiles_clients_daily
clients_first_seen_v2
Client ID column: None
Submission Date column: first_seen_date
Definition:
moz-fx-data-shared-prod.telemetry_derived.clients_first_seen_v2
urlbar_events
Client ID column: legacy_telemetry_client_id
Submission Date column: submission_date
Definition:
(
SELECT * FROM `moz-fx-data-shared-prod.firefox_desktop.urlbar_events`
)
urlbar_events_unnested_results
Client ID column: legacy_telemetry_client_id
Submission Date column: submission_date
Definition:
(
SELECT
e.* EXCEPT (results),
result
FROM
`moz-fx-data-shared-prod.firefox_desktop.urlbar_events` e
CROSS JOIN
UNNEST(e.results) AS result
)