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
)

---