Skip to content

Firefox desktop

Pre-defined data sources for firefox_desktop that can be used across all experiments. These data sources are defined in jetstream-config

clients_daily

Client ID column: None

Submission Date column: None

Definition:
mozdata.telemetry.clients_daily

search_clients_engines_sources_daily

Client ID column: None

Submission Date column: None

Definition:
mozdata.search.search_clients_engines_sources_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

normandy_events

Client ID column: None

Submission Date column: None

Definition:
(
    SELECT
        *
    FROM mozdata.telemetry.events
    WHERE event_category = 'normandy'
)

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_v4
)

crash

Client ID column: None

Submission Date column: None

Definition:
(
    SELECT
        *,
        DATE(submission_timestamp) AS submission_date,
        environment.experiments
    FROM mozdata.telemetry.crash
)

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
)