Skip to content

telemetry

accessibility_clients

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived accessibility_clients_v1

Source Directory | Metadata File | View Definition


active_profiles

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived active_profiles_v1

Source Directory | Metadata File | View Definition


addon_aggregates

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry addon_aggregates_v2

Source Directory | Metadata File | View Definition


addon_aggregates_v2

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addon_aggregates_v2

Source Directory | Metadata File | View Definition


addon_install_blocked

A historical view of pings sent for the telemetry/addon-install-blocked document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/addon-install-blocked
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable addon_install_blocked_v4

Source Directory | Metadata File | View Definition


addon_names

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addon_names_v1

Source Directory | Metadata File | View Definition


addons

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addons_v2

Source Directory | Metadata File | View Definition


addons_daily

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addons_daily_v1

Source Directory | Metadata File | View Definition


addons_v2

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived addons_v2

Source Directory | Metadata File | View Definition


adm_engagements_daily

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived adm_engagements_daily_v1

Source Directory | Metadata File | View Definition


advancedtelemetry

A historical view of pings sent for the telemetry/advancedtelemetry document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/advancedtelemetry
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable advancedtelemetry_v4

Source Directory | Metadata File | View Definition


anonymous

A historical view of pings sent for the telemetry/anonymous document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/anonymous
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable anonymous_v4

Source Directory | Metadata File | View Definition


asn_aggregates

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived asn_aggregates_v1

Source Directory | Metadata File | View Definition


attitudes_daily

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived attitudes_daily_v1

Source Directory | Metadata File | View Definition


bhr

A historical view of pings sent for the telemetry/bhr document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/bhr
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable bhr_v4

Source Directory | Metadata File | View Definition


block_autoplay

A historical view of pings sent for the telemetry/block-autoplay document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/block-autoplay
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable block_autoplay_v4

Source Directory | Metadata File | View Definition


buildhub2

Referenced Tables
Project Dataset Table
moz-fx-buildhub2-prod-4784 build_metadata buildhub2

Source Directory | Metadata File | View Definition


certificate_checker

A historical view of pings sent for the telemetry/certificate-checker document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/certificate-checker
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable certificate_checker_v4

Source Directory | Metadata File | View Definition


client_probe_counts_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_histogram_probe_counts_v1
moz-fx-data-shared-prod telemetry_derived clients_scalar_probe_counts_v1
moz-fx-data-shared-prod telemetry_derived histogram_percentiles_v1
moz-fx-data-shared-prod telemetry_derived scalar_percentiles_v1

Source Directory | Metadata File | View Definition


clients_daily

A daily aggregate of main and event pings from each Firefox desktop client.

Clustering fields: normalized_channel, sample_id

See also: clients_last_seen, clients_first_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry clients_daily_v6

Source Directory | Metadata File | View Definition


clients_daily_histogram_aggregates_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_daily_histogram_aggregates_v1

Source Directory | Metadata File | View Definition


clients_daily_scalar_aggregates_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_daily_scalar_aggregates_v1

Source Directory | Metadata File | View Definition


clients_daily_v6

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_daily_v6

Source Directory | Metadata File | View Definition


clients_first_seen

Identical in schema to clients_daily except that each client appears only once over all time; includes fields first_seen_date and second_seen_date for determining user "activation".

Note that first_seen_date and second_seen_date are also pulled into clients_last_seen to avoid needing to join with this view. Use this view directly only when you're investigating client activation questions.

Clustering fields: normalized_channel, sample_id

See also: clients_daily, clients_last_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_first_seen_v1

Source Directory | Metadata File | View Definition


clients_histogram_aggregates_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_histogram_aggregates_v1

Source Directory | Metadata File | View Definition


clients_last_seen

Captures history of activity of each client in 28 day windows for each submission date.

There will be one row per client per submission_date. A given client will stop appearing for new dates if they do not send a main ping for 28 days.

Generally, this is a direct product of clients_daily and serves to make certain query patterns more efficient by eliminating the need for self-joins that would otherwise be needed to consider windows of activity. As an exception, it pulls in first_seen_date and second_seen_date over all time from clients_first_seen since first_seen_date is highly valuable for providing a stable definition of when a profile was created.

See the Working with Bit Patterns in Clients Last Seen article on docs.telemetry.mozilla.org for more detailed notes on usage.

Clustering fields: normalized_channel, sample_id

See also: clients_daily, clients_first_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry clients_last_seen_v1

Source Directory | Metadata File | View Definition


clients_last_seen_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_last_seen_v1

Source Directory | Metadata File | View Definition


clients_probe_processes

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived client_probe_counts_v1

Source Directory | Metadata File | View Definition


clients_scalar_aggregates_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived clients_scalar_aggregates_v1

Source Directory | Metadata File | View Definition


core

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable core_v10
moz-fx-data-shared-prod telemetry_stable core_v2
moz-fx-data-shared-prod telemetry_stable core_v3
moz-fx-data-shared-prod telemetry_stable core_v4
moz-fx-data-shared-prod telemetry_stable core_v5
moz-fx-data-shared-prod telemetry_stable core_v6
moz-fx-data-shared-prod telemetry_stable core_v7
moz-fx-data-shared-prod telemetry_stable core_v8
moz-fx-data-shared-prod telemetry_stable core_v9

Source Directory | Metadata File | View Definition


core_clients_daily

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry core_clients_daily_v1

Source Directory | Metadata File | View Definition


core_clients_daily_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived core_clients_daily_v1

Source Directory | Metadata File | View Definition


core_clients_last_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry core_clients_last_seen_v1

Source Directory | Metadata File | View Definition


core_clients_last_seen_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived core_clients_last_seen_v1

Source Directory | Metadata File | View Definition


crash

A historical view of pings sent for the telemetry/crash document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/crash
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable crash_v4

Source Directory | Metadata File | View Definition


crash_aggregates

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry crash_aggregates_v1

Source Directory | Metadata File | View Definition


crash_aggregates_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived crash_aggregates_v1

Source Directory | Metadata File | View Definition


crash_summary

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry crash_summary_v2

Source Directory | Metadata File | View Definition


crash_summary_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived crash_summary_v1

Source Directory | Metadata File | View Definition


crash_summary_v2

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived crash_summary_v2

Source Directory | Metadata File | View Definition


deletion

A historical view of pings sent for the telemetry/deletion document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/deletion
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable deletion_v4

Source Directory | Metadata File | View Definition


deletion_request

A historical view of pings sent for the telemetry/deletion-request document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/deletion-request
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable deletion_request_v4

Source Directory | Metadata File | View Definition


deployment_checker

A historical view of pings sent for the telemetry/deployment-checker document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/deployment-checker
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable deployment_checker_v4

Source Directory | Metadata File | View Definition


desktop_retention_1_week

Among profiles that were active at least once in the week starting on the specified day (days 0 through 6), whether each profile is active during the following week (days 7 through 13). This based on https://docs.telemetry.mozilla.org/cookbooks/retention.html#1-week-retention for the usage criterion "Any Firefox Activity" on Firefox (Desktop)

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry clients_last_seen

Source Directory | Metadata File | View Definition


devtools_panel_usage

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived devtools_panel_usage_v1

Source Directory | Metadata File | View Definition


disable_sha1rollout

A historical view of pings sent for the telemetry/disable-sha1rollout document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/disable-sha1rollout
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable disable_sha1rollout_v4

Source Directory | Metadata File | View Definition


dnssec_study_v1

A historical view of pings sent for the telemetry/dnssec-study-v1 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/dnssec-study-v1
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable dnssec_study_v1_v4

Source Directory | Metadata File | View Definition


downgrade

A historical view of pings sent for the telemetry/downgrade document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/downgrade
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable downgrade_v4

Source Directory | Metadata File | View Definition


eng_workflow_build_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry eng_workflow_build_parquet_v1

Source Directory | Metadata File | View Definition


eng_workflow_build_parquet_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod eng_workflow build

Source Directory | Metadata File | View Definition


eng_workflow_hgpush_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived eng_workflow_hgpush_parquet_v1

Source Directory | Metadata File | View Definition


eng_workflow_hgpush_parquet_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived eng_workflow_hgpush_parquet_v1

Source Directory | Metadata File | View Definition


event

A historical view of pings sent for the telemetry/event document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/event
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable event_v4

Source Directory | Metadata File | View Definition


event_types

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived event_types_v1

Source Directory | Metadata File | View Definition


events

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry events_v1

Source Directory | Metadata File | View Definition


events_1pct

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived events_1pct_v1

Source Directory | Metadata File | View Definition


events_daily

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived events_daily_v1

Source Directory | Metadata File | View Definition


events_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived event_events_v1
moz-fx-data-shared-prod telemetry_derived main_events_v1
moz-fx-data-shared-prod telemetry_derived events_v1

Source Directory | Metadata File | View Definition


experiment_cumulative_ad_clicks

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_cumulative_ad_clicks_v1

Source Directory | Metadata File | View Definition


experiment_cumulative_search_count

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_cumulative_search_count_v1

Source Directory | Metadata File | View Definition


experiment_cumulative_search_with_ads_count

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_cumulative_search_with_ads_count_v1

Source Directory | Metadata File | View Definition


experiment_enrollment_cumulative_population_estimate

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_enrollment_cumulative_population_estimate_v1

Source Directory | Metadata File | View Definition


experiment_enrollment_daily_active_population

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_enrollment_daily_active_population_v1

Source Directory | Metadata File | View Definition


experiment_enrollment_other_events_overall

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_enrollment_other_events_overall_v1

Source Directory | Metadata File | View Definition


experiment_enrollment_overall

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_enrollment_overall_v1

Source Directory | Metadata File | View Definition


experiment_error_aggregates

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_error_aggregates_v1

Source Directory | Metadata File | View Definition


experiment_error_aggregates_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_error_aggregates_v1

Source Directory | Metadata File | View Definition


experiment_unenrollment_overall

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiment_unenrollment_overall_v1

Source Directory | Metadata File | View Definition


experiments

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry experiments_v1

Source Directory | Metadata File | View Definition


experiments_aggregates

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry experiments_aggregates_v1

Source Directory | Metadata File | View Definition


experiments_aggregates_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiments_aggregates_v1

Source Directory | Metadata File | View Definition


experiments_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived experiments_v0
moz-fx-data-shared-prod telemetry_derived experiments_v1

Source Directory | Metadata File | View Definition


fenix_clients_last_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_fenix_nightly baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_fennec_aurora baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_firefox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_firefox_beta baseline_clients_last_seen

Source Directory | Metadata File | View Definition


fenix_events_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod org_mozilla_fenix_stable events_v1

Source Directory | Metadata File | View Definition


fennec_ios_events_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry mobile_event

Source Directory | Metadata File | View Definition


firefox_accounts_exact_mau28_by_dimensions

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_accounts_exact_mau28_by_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_accounts_exact_mau28_by_dimensions_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod firefox_accounts_derived exact_mau28_v1
moz-fx-data-shared-prod static country_names_v1

Source Directory | Metadata File | View Definition


firefox_accounts_exact_mau28_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_accounts_exact_mau28_by_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_desktop_exact_mau28

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_desktop_exact_mau28_v1

Source Directory | Metadata File | View Definition


firefox_desktop_exact_mau28_by_client_count_dimensions

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_desktop_exact_mau28_by_client_count_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_desktop_exact_mau28_by_dimensions

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_desktop_exact_mau28_by_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_desktop_exact_mau28_by_dimensions_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_desktop_exact_mau28_by_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_desktop_exact_mau28_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod static firefox_desktop_imputed_mau28_v1
moz-fx-data-shared-prod telemetry_derived firefox_desktop_exact_mau28_by_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_desktop_usage_2021

Stable source for 2021 KPI data on Firefox desktop usage, including cumulative days of use (cdou) and new profiles, broken out by dimensions. Contains data back to 2017 for year-over-year comparisons.

New profile counts are determined using the first_seen_date approach where we consider a profile new on the day it first sends a main ping.

Queries should generally be SUM of the cdou, new_profiles, dau, wau, or mau fields, grouped by any dimensions you want to compare or filtered to only your target population.

Example query to see CDOU and new profiles over time for the Windows population:

SELECT
  submission_date,
  os,
  SUM(cdou) AS cdou,
  SUM(new_profiles) AS new_profiles
FROM mozdata.telemetry.firefox_desktop_usage_2021
WHERE os = 'Windows'
GROUP BY submission_date
ORDER BY submission_date

Note that some amount of the upstream data in clients_last_seen will be deleted over time in response to user-initiated deletion requests, but the aggregates in this view (which are no longer client-level) will remain stable. Expect to see slightly higher results from this table compared to queries on client-level tables. The underlying table was initially created on 2021-02-19.

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_desktop_usage_v1

Source Directory | Metadata File | View Definition


firefox_nondesktop_day_2_7_activation

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_nondesktop_day_2_7_activation_v1

Source Directory | Metadata File | View Definition


firefox_nondesktop_exact_mau28

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_v1

Source Directory | Metadata File | View Definition


firefox_nondesktop_exact_mau28_by_client_count_dimensions

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived firefox_nondesktop_exact_mau28_by_client_count_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_nondesktop_exact_mau28_by_dimensions

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_by_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_nondesktop_exact_mau28_by_dimensions_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod static country_codes_v1
moz-fx-data-shared-prod telemetry_derived firefox_nondesktop_exact_mau28_v1

Source Directory | Metadata File | View Definition


firefox_nondesktop_exact_mau28_by_product

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_by_product_v1

Source Directory | Metadata File | View Definition


firefox_nondesktop_exact_mau28_by_product_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_by_dimensions_v1

Source Directory | Metadata File | View Definition


firefox_nondesktop_exact_mau28_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry firefox_nondesktop_exact_mau28_by_dimensions_v1

Source Directory | Metadata File | View Definition


first_shutdown

A historical view of pings sent for the telemetry/first-shutdown document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/first-shutdown
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable first_shutdown_v4

Source Directory | Metadata File | View Definition


first_shutdown_summary

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived first_shutdown_summary_v4

Source Directory | Metadata File | View Definition


first_shutdown_summary_v4

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived first_shutdown_summary_v4

Source Directory | Metadata File | View Definition


flash_shield_study

A historical view of pings sent for the telemetry/flash-shield-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/flash-shield-study
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable flash_shield_study_v4

Source Directory | Metadata File | View Definition


focus_event

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable focus_event_v1

Source Directory | Metadata File | View Definition


frecency_update

A historical view of pings sent for the telemetry/frecency-update document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/frecency-update
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable frecency_update_v4

Source Directory | Metadata File | View Definition


ftu

A historical view of pings sent for the telemetry/ftu document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/ftu
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable ftu_v3

Source Directory | Metadata File | View Definition


health

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable health_v4

Source Directory | Metadata File | View Definition


heartbeat

A historical view of pings sent for the telemetry/heartbeat document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/heartbeat
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable heartbeat_v4

Source Directory | Metadata File | View Definition


installation

A historical view of pings sent for the telemetry/installation document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/installation
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable installation_v1

Source Directory | Metadata File | View Definition


lockwise_mobile_events

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry lockwise_mobile_events_v1

Source Directory | Metadata File | View Definition


lockwise_mobile_events_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_focus_event_parquet_v1
moz-fx-data-shared-prod telemetry telemetry_mobile_event_parquet_v2

Source Directory | Metadata File | View Definition


main

A historical view of pings sent for the telemetry/main document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/main
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable main_v4

Source Directory | Metadata File | View Definition


main_1pct

A materialized 1 percent sample of main pings intended as a performance optimization for exploratory queries. It contains only the most recent six months of data.

Queries on this table are logically equivalent to queries on top of main_v4 with a filter on sample_id = 0, but this table has a few advantages. First, query estimates will be much more accurate; estimates of bytes scanned can't take into account clustering, so we sometimes see valid queries get rejected by Redash due to appearing expensive when they really aren't. Second, simple queries should complete much more quickly on this table compared to main_v4; for simple queries on a very wide table like this, the execution time appears to be dominated by BQ simply scanning metadata for all the blocks it might need to touch. Because this table contains only 1% of main ping data, it is likely to have many fewer blocks to scan through.

An extra-experimental feature here is the addition of subsample_id, an additional clustering field that allows for queries to efficiently filter down to a 0.01% sample. Like sample_id, it ranges from 0 to 99.

Clustering fields: normalized_channel, sample_id, subsample_id

See also: main_nightly

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_1pct_v1

Source Directory | Metadata File | View Definition


main_nightly

A materialized subset of main pings intended as a performance optimization for exploratory queries. It contains only the most recent six months of data for the nightly channel of Firefox.

Queries on this table are logically equivalent to queries on top of main_v4 with a filter on normalized_channel = 'nightly', but this table has a few advantages. First, query estimates will be much more accurate; estimates of bytes scanned can't take into account clustering, so we sometimes see valid queries get rejected by Redash due to appearing expensive when they really aren't. Second, simple queries should complete much more quickly on this table compared to main_v4; for simple queries on a very wide table like this, the execution time appears to be dominated by BQ simply scanning metadata for all the blocks it might need to touch. Because this table contains only a fraction of main ping data, it is likely to have many fewer blocks to scan through.

Clustering fields: normalized_channel, sample_id

See also: main_nightly

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_nightly_v1

Source Directory | Metadata File | View Definition


main_summary

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry main_summary_v4

Source Directory | Metadata File | View Definition


main_summary_v3

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_summary_v3

Source Directory | Metadata File | View Definition


main_summary_v4

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived main_summary_v4

Source Directory | Metadata File | View Definition


malware_addon_states

A historical view of pings sent for the telemetry/malware-addon-states document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/malware-addon-states
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable malware_addon_states_v4

Source Directory | Metadata File | View Definition


mobile_event

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable mobile_event_v1

Source Directory | Metadata File | View Definition


mobile_metrics

A historical view of pings sent for the telemetry/mobile-metrics document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/mobile-metrics
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable mobile_metrics_v1

Source Directory | Metadata File | View Definition


mobile_usage_2021

Stable source for 2021 KPI data on mobile usage, including cumulative days of use (cdou) broken out by dimensions. Contains data back to 2017 for year-over-year comparisons.

Queries should generally be SUM of the cdou, dau, wau, or mau fields, grouped by any dimensions you want to compare or filtered to only your target population.

Example query to see CDOU over time for Firefox for iOS:

SELECT
  submission_date,
  SUM(cdou) AS cdou
FROM mozdata.telemetry.mobile_usage_2021
WHERE app_name = 'firefox_ios'
GROUP BY submission_date
ORDER BY submission_date

Note that some amount of the upstream data in nondesktop_clients_last_seen will be deleted over time in response to user-initiated deletion requests, but the aggregates in this view (which are no longer client-level) will remain stable. Expect to see slightly higher results from this table compared to queries on client-level tables.

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod static country_codes_v1
moz-fx-data-shared-prod telemetry_derived mobile_usage_v1

Source Directory | Metadata File | View Definition


modules

A historical view of pings sent for the telemetry/modules document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/modules
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable modules_v4

Source Directory | Metadata File | View Definition


new_profile

A historical view of pings sent for the telemetry/new-profile document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/new-profile
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable new_profile_v4

Source Directory | Metadata File | View Definition


nondesktop_clients_last_seen

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry nondesktop_clients_last_seen_v1

Source Directory | Metadata File | View Definition


nondesktop_clients_last_seen_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod mozilla_lockbox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_ios_lockbox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_reference_browser baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_tv_firefox baseline_clients_last_seen
moz-fx-data-shared-prod org_mozilla_vrbrowser baseline_clients_last_seen
moz-fx-data-shared-prod telemetry core_clients_last_seen
moz-fx-data-shared-prod telemetry fenix_clients_last_seen

Source Directory | Metadata File | View Definition


normandy_login_study

A historical view of pings sent for the telemetry/normandy-login-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/normandy-login-study
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable normandy_login_study_v4

Source Directory | Metadata File | View Definition


optout

A historical view of pings sent for the telemetry/optout document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/optout
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable optout_v4

Source Directory | Metadata File | View Definition


origin_content_blocking

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived origin_content_blocking

Source Directory | Metadata File | View Definition


outofdate_notifications_system_addon

A historical view of pings sent for the telemetry/outofdate-notifications-system-addon document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/outofdate-notifications-system-addon
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable outofdate_notifications_system_addon_v4

Source Directory | Metadata File | View Definition


pioneer_study

A historical view of pings sent for the telemetry/pioneer-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/pioneer-study
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable pioneer_study_v4

Source Directory | Metadata File | View Definition


pre_account

A historical view of pings sent for the telemetry/pre-account document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/pre-account
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable pre_account_v4

Source Directory | Metadata File | View Definition


prio

A historical view of pings sent for the telemetry/prio document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/prio
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable prio_v4

Source Directory | Metadata File | View Definition


regrets_reporter_update

A historical view of pings sent for the telemetry/regrets-reporter-update document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/regrets-reporter-update
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable regrets_reporter_update_v4

Source Directory | Metadata File | View Definition


releases

Firefox release information imported from https://product-details.mozilla.org/1.0/firefox.json

For more context, see https://wiki.mozilla.org/Release_Management/Product_details

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived releases_v1

Source Directory | Metadata File | View Definition


rocket_android_events_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry focus_event

Source Directory | Metadata File | View Definition


saved_session

A historical view of pings sent for the telemetry/saved-session document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/saved-session
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable saved_session_v4

Source Directory | Metadata File | View Definition


searchvol

A historical view of pings sent for the telemetry/searchvol document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/searchvol
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable searchvol_v4

Source Directory | Metadata File | View Definition


searchvolextra

A historical view of pings sent for the telemetry/searchvolextra document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/searchvolextra
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable searchvolextra_v4

Source Directory | Metadata File | View Definition


shield_icq_v1

A historical view of pings sent for the telemetry/shield-icq-v1 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/shield-icq-v1
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable shield_icq_v1_v4

Source Directory | Metadata File | View Definition


shield_study

A historical view of pings sent for the telemetry/shield-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/shield-study
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable shield_study_v4

Source Directory | Metadata File | View Definition


shield_study_addon

A historical view of pings sent for the telemetry/shield-study-addon document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/shield-study-addon
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable shield_study_addon_v4

Source Directory | Metadata File | View Definition


shield_study_error

A historical view of pings sent for the telemetry/shield-study-error document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/shield-study-error
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable shield_study_error_v4

Source Directory | Metadata File | View Definition


simpleprophet_forecasts

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived simpleprophet_forecasts_desktop_v1
moz-fx-data-shared-prod telemetry_derived simpleprophet_forecasts_fxa_v1
moz-fx-data-shared-prod telemetry_derived simpleprophet_forecasts_mobile_v1

Source Directory | Metadata File | View Definition


smoot_usage_day_0

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived smoot_usage_desktop_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_fxa_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_new_profiles_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_nondesktop_v2

Source Directory | Metadata File | View Definition


smoot_usage_day_13

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived smoot_usage_desktop_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_fxa_v2
moz-fx-data-shared-prod telemetry_derived smoot_usage_nondesktop_v2

Source Directory | Metadata File | View Definition


socorro_crash

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry socorro_crash_v2

Source Directory | Metadata File | View Definition


socorro_crash_v2

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived socorro_crash_v2

Source Directory | Metadata File | View Definition


ssl_ratios

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry ssl_ratios_v1

Source Directory | Metadata File | View Definition


ssl_ratios_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived ssl_ratios_v1

Source Directory | Metadata File | View Definition


sync

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable sync_v4

Source Directory | Metadata File | View Definition


system_addon_deployment_diagnostics

A historical view of pings sent for the telemetry/system-addon-deployment-diagnostics document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/system-addon-deployment-diagnostics
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable system_addon_deployment_diagnostics_v4

Source Directory | Metadata File | View Definition


telemetry_anonymous_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_anonymous_parquet_v1

Source Directory | Metadata File | View Definition


telemetry_anonymous_parquet_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry anonymous

Source Directory | Metadata File | View Definition


telemetry_core_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_core_parquet_v3

Source Directory | Metadata File | View Definition


telemetry_core_parquet_v3

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry core

Source Directory | Metadata File | View Definition


telemetry_downgrade_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_downgrade_parquet_v1

Source Directory | Metadata File | View Definition


telemetry_downgrade_parquet_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry downgrade

Source Directory | Metadata File | View Definition


telemetry_focus_event_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_focus_event_parquet_v1

Source Directory | Metadata File | View Definition


telemetry_focus_event_parquet_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry focus_event

Source Directory | Metadata File | View Definition


telemetry_heartbeat_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_heartbeat_parquet_v1

Source Directory | Metadata File | View Definition


telemetry_heartbeat_parquet_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry heartbeat

Source Directory | Metadata File | View Definition


telemetry_ip_privacy

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_ip_privacy_v2

Source Directory | Metadata File | View Definition


telemetry_ip_privacy_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_ip_privacy_parquet_v1

Source Directory | Metadata File | View Definition


telemetry_ip_privacy_parquet_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_ip_privacy_parquet_v1

Source Directory | Metadata File | View Definition


telemetry_mobile_event_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_mobile_event_parquet_v2

Source Directory | Metadata File | View Definition


telemetry_mobile_event_parquet_v2

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry mobile_event

Source Directory | Metadata File | View Definition


telemetry_new_profile_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_new_profile_parquet_v2

Source Directory | Metadata File | View Definition


telemetry_new_profile_parquet_v2

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_new_profile_parquet_v2

Source Directory | Metadata File | View Definition


telemetry_shield_study_parquet

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry telemetry_shield_study_parquet_v1

Source Directory | Metadata File | View Definition


telemetry_shield_study_parquet_v1

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_derived telemetry_shield_study_parquet_v1

Source Directory | Metadata File | View Definition


testpilot

A historical view of pings sent for the telemetry/testpilot document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/testpilot
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable testpilot_v4

Source Directory | Metadata File | View Definition


testpilottest

A historical view of pings sent for the telemetry/testpilottest document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/testpilottest
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable testpilottest_v4

Source Directory | Metadata File | View Definition


third_party_modules

A historical view of pings sent for the telemetry/third-party-modules document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/third-party-modules
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable third_party_modules_v4

Source Directory | Metadata File | View Definition


tls13_middlebox_alt_server_hello_1

A historical view of pings sent for the telemetry/tls13-middlebox-alt-server-hello-1 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls13-middlebox-alt-server-hello-1
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_alt_server_hello_1_v4

Source Directory | Metadata File | View Definition


tls13_middlebox_beta

A historical view of pings sent for the telemetry/tls13-middlebox-beta document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls13-middlebox-beta
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_beta_v4

Source Directory | Metadata File | View Definition


tls13_middlebox_draft22

A historical view of pings sent for the telemetry/tls13-middlebox-draft22 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls13-middlebox-draft22
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_draft22_v4

Source Directory | Metadata File | View Definition


tls13_middlebox_ghack

A historical view of pings sent for the telemetry/tls13-middlebox-ghack document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls13-middlebox-ghack
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_ghack_v4

Source Directory | Metadata File | View Definition


tls13_middlebox_repetition

A historical view of pings sent for the telemetry/tls13-middlebox-repetition document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls13-middlebox-repetition
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_repetition_v4

Source Directory | Metadata File | View Definition


tls13_middlebox_testing

A historical view of pings sent for the telemetry/tls13-middlebox-testing document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls13-middlebox-testing
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls13_middlebox_testing_v4

Source Directory | Metadata File | View Definition


tls_13_study

A historical view of pings sent for the telemetry/tls-13-study document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls-13-study
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls_13_study_v4

Source Directory | Metadata File | View Definition


tls_13_study_v1

A historical view of pings sent for the telemetry/tls-13-study-v1 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls-13-study-v1
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls_13_study_v1_v4

Source Directory | Metadata File | View Definition


tls_13_study_v2

A historical view of pings sent for the telemetry/tls-13-study-v2 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls-13-study-v2
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls_13_study_v2_v4

Source Directory | Metadata File | View Definition


tls_13_study_v3

A historical view of pings sent for the telemetry/tls-13-study-v3 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls-13-study-v3
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls_13_study_v3_v4

Source Directory | Metadata File | View Definition


tls_13_study_v4

A historical view of pings sent for the telemetry/tls-13-study-v4 document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/tls-13-study-v4
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable tls_13_study_v4_v4

Source Directory | Metadata File | View Definition


uitour_tag

A historical view of pings sent for the telemetry/uitour-tag document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/uitour-tag
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable uitour_tag_v4

Source Directory | Metadata File | View Definition


uninstall

A historical view of pings sent for the telemetry/uninstall document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/uninstall
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable uninstall_v4

Source Directory | Metadata File | View Definition


untrusted_modules

A historical view of pings sent for the telemetry/untrusted-modules document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/untrusted-modules
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable untrusted_modules_v4

Source Directory | Metadata File | View Definition


update

A historical view of pings sent for the telemetry/update document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/update
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable update_v4

Source Directory | Metadata File | View Definition


voice

A historical view of pings sent for the telemetry/voice document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/voice
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable voice_v4

Source Directory | Metadata File | View Definition


voice_feedback

A historical view of pings sent for the telemetry/voice-feedback document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/voice-feedback
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable voice_feedback_v4

Source Directory | Metadata File | View Definition


windows_10_aggregate

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry clients_daily

Source Directory | Metadata File | View Definition


windows_10_build_distribution

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry windows_10_aggregate

Source Directory | Metadata File | View Definition


windows_10_patch_adoption

Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry windows_10_aggregate

Source Directory | Metadata File | View Definition


x_contextual_feature_recommendation

A historical view of pings sent for the telemetry/x-contextual-feature-recommendation document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/x-contextual-feature-recommendation
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable x_contextual_feature_recommendation_v4

Source Directory | Metadata File | View Definition


xfocsp_error_report

A historical view of pings sent for the telemetry/xfocsp-error-report document type.

This view is guaranteed to contain only complete days (per submission_timestamp) and to contain only one row per distinct document_id within a given date.

Clustering fields: normalized_channel, sample_id

  • Friendly name: Historical Pings for telemetry/xfocsp-error-report
Referenced Tables
Project Dataset Table
moz-fx-data-shared-prod telemetry_stable xfocsp_error_report_v4

Source Directory | Metadata File | View Definition