custom-namespaces.yaml (2,094 lines of code) (raw):

--- operational_monitoring: glean_app: false owners: - ascholtz@mozilla.com pretty_name: Operational Monitoring views: projects: type: table_view tables: - table: moz-fx-data-shared-prod.operational_monitoring_derived.projects_v1 combined_browser_metrics: glean_app: false owners: - gkaberere@mozilla.com - lvargas@mozilla.com - mhirose@mozilla.com - anicholson@mozilla.com - kik@mozilla.com pretty_name: Combined Browser Metrics views: active_users_aggregates: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.active_users_aggregates active_users_aggregates_device: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.active_users_aggregates_device cohort_daily_statistics: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.cohort_daily_statistics cohort_weekly_statistics: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.cohort_weekly_statistics fenix_and_firefox_use_counters: type: table_view tables: - table: mozilla-public-data.telemetry_derived.fenix_and_firefox_use_counters glean_active_users_aggregates: type: table_view tables: - table: moz-fx-data-shared-prod.glean_telemetry.active_users_aggregates review_checker_desktop: glean_app: false owners: - betling@mozilla.com - akommasani@mozilla.com pretty_name: Review Checker Desktop views: clients: type: table_view tables: - table: mozdata.firefox_desktop.review_checker_clients events: type: table_view tables: - table: mozdata.firefox_desktop.review_checker_events microsurvey: type: table_view tables: - table: mozdata.firefox_desktop.review_checker_microsurvey review_checker: glean_app: false owners: - betling@mozilla.com - akommasani@mozilla.com pretty_name: Review Checker explores: desktop_clients: type: table_explore views: base_view: desktop_clients desktop_events: type: table_explore views: base_view: desktop_events desktop_microsurvey: type: table_explore views: base_view: desktop_microsurvey android_clients: type: table_explore views: base_view: android_clients android_events: type: table_explore views: base_view: android_events ios_clients: type: table_explore views: base_view: ios_clients ios_events: type: table_explore views: base_view: ios_events views: desktop_clients: type: table_view tables: - table: mozdata.firefox_desktop.review_checker_clients desktop_events: type: table_view tables: - table: mozdata.firefox_desktop.review_checker_events desktop_microsurvey: type: table_view tables: - table: mozdata.firefox_desktop.review_checker_microsurvey android_clients: type: table_view tables: - table: mozdata.org_mozilla_fenix.review_checker_clients android_events: type: table_view tables: - table: mozdata.org_mozilla_fenix.review_checker_events ios_clients: type: table_view tables: - table: mozdata.org_mozilla_ios_firefox.review_checker_clients ios_events: type: table_view tables: - table: mozdata.org_mozilla_ios_firefox.review_checker_events duet: glean_app: false owners: - ascholtz@mozilla.com pretty_name: DUET explores: gplay_installs_by_country: type: table_explore views: base_view: gplay_installs_by_country views: gplay_installs_by_country: type: table_view tables: - table: mozdata.fenix.gplay_installs_by_country measures: total_installs: type: sum sql: "${install_count}" total_uninstalls: type: sum sql: "${uninstall_count}" total_updates: type: sum sql: "${update_count}" install: type: ping_view tables: - channel: release table: mozdata.firefox_installer.install new_profile: type: ping_view tables: - channel: release table: mozdata.telemetry.new_profile fenix_marketing_metrics: type: table_view tables: - table: moz-fx-data-shared-prod.fenix.marketing_attributable_metrics firefox_mobile_installs_adjust_deliverables: type: table_view tables: - table: moz-fx-data-shared-prod.adjust_derived.adjust_deliverables_v1 firefox_ios_campaign_performance: type: table_view tables: - table: mozdata.firefox_ios.ad_activation_performance app_store_funnel_ios: type: table_view tables: - table: mozdata.firefox_ios.app_store_funnel activity_stream: glean_app: false owners: - najiang@mozilla.com pretty_name: Activity Stream views: events: type: ping_view tables: - table: mozdata.activity_stream.events sessions: type: ping_view tables: - table: mozdata.activity_stream.sessions impression_stats_flat: type: ping_view tables: - table: mozdata.activity_stream.impression_stats_flat explores: event_counts: type: ping_explore views: base_view: events session_counts: type: ping_explore views: base_view: sessions pocket_tile_impressions: type: ping_explore views: base_view: impression_stats_flat search_private: glean_app: false connection: bigquery-oauth pretty_name: Search Private owners: - xluo@mozilla.com - skahmann@mozilla.com - ctroy@mozilla.com spoke: looker-spoke-private views: search_term_sanitization_job_metadata_daily: type: table_view tables: - table: moz-fx-data-shared-prod.search_terms_derived.sanitization_job_metadata_v2 sanitization_job_languages: type: table_view tables: - table: moz-fx-data-shared-prod.search_terms.sanitization_job_languages search_term_data_validation_reports: type: table_view tables: - table: moz-fx-data-shared-prod.search_terms_derived.search_term_data_validation_reports_v1 search: glean_app: false owners: - xluo@mozilla.com - skahmann@mozilla.com - ctroy@mozilla.com pretty_name: Search views: search_clients_engines_sources_daily: type: table_view tables: - table: mozdata.search.search_clients_engines_sources_daily mobile_search_clients_engines_sources_daily: type: table_view tables: - table: mozdata.search.mobile_search_clients_engines_sources_daily desktop_mobile_search_clients_monthly: type: table_view tables: - table: mozdata.search.desktop_mobile_search_clients_monthly desktop_search_alert_records: type: ping_view tables: - table: mozdata.analysis.desktop_search_alert_records desktop_search_alert_latest_daily: type: table_view tables: - table: mozdata.analysis.desktop_search_alert_latest_daily explores: desktop_search_counts: type: ping_explore views: base_view: search_clients_engines_sources_daily mobile_search_counts: type: ping_explore views: base_view: mobile_search_clients_engines_sources_daily desktop_search_alert_records: type: ping_explore views: base_view: desktop_search_alert_records contextual_services_private: glean_app: false connection: bigquery-oauth pretty_name: Contextual Services owners: - rburwei@mozilla.com - mbowerman@mozilla.com spoke: looker-spoke-private views: request_payload_tiles: type: table_view tables: - table: mozdata.contextual_services.request_payload_tiles request_payload_suggest: type: table_view tables: - table: mozdata.contextual_services.request_payload_suggest final_adM_forecasts: type: table_view tables: - table: moz-fx-data-shared-prod.revenue_derived.final_adm_revenue_forecast suggest_revenue_levers_daily: type: table_view tables: - table: mozdata.contextual_services.suggest_revenue_levers_daily event_aggregates_spons_tiles: type: ping_view tables: - table: mozdata.contextual_services.event_aggregates_spons_tiles event_aggregates_suggest: type: ping_view tables: - table: mozdata.contextual_services.event_aggregates_suggest event_aggregates: type: ping_view tables: - table: mozdata.contextual_services.event_aggregates quicksuggest_click: type: ping_view tables: - table: mozdata.contextual_services.quicksuggest_click quicksuggest_impression: type: ping_view tables: - table: mozdata.contextual_services.quicksuggest_impression search_terms_daily: type: ping_view tables: - table: mozdata.search_terms.search_terms_daily topsites_click: type: ping_view tables: - table: mozdata.contextual_services.topsites_click topsites_impression: type: ping_view tables: - table: mozdata.contextual_services.topsites_impression topsites_impression_fenix: tables: - channel: release table: mozdata.fenix.topsites_impression - channel: beta table: mozdata.org_mozilla_firefox_beta.topsites_impression - channel: nightly table: mozdata.org_mozilla_fenix.topsites_impression type: ping_view topsites_impression_firefox_ios: tables: - channel: release table: mozdata.org_mozilla_ios_firefox.topsites_impression - channel: beta table: mozdata.org_mozilla_ios_firefoxbeta.topsites_impression - channel: nightly table: mozdata.org_mozilla_ios_fennec.topsites_impression type: ping_view explores: event_aggregates_spons_tiles: type: ping_explore views: base_view: event_aggregates_spons_tiles event_aggregates_suggest: type: ping_explore views: base_view: event_aggregates_suggest event_aggregates: type: ping_explore views: base_view: event_aggregates quicksuggest_clicks: type: ping_explore views: base_view: quicksuggest_click quicksuggest_impressions: type: ping_explore views: base_view: quicksuggest_impression search_terms_daily: type: ping_explore views: base_view: search_terms_daily topsites_clicks: type: ping_explore views: base_view: topsites_click topsites_impressions: type: ping_explore views: base_view: topsites_impression topsites_impressions_fenix: type: ping_explore views: base_view: topsites_impression_fenix topsites_impressions_firefox_ios: type: ping_explore views: base_view: topsites_impression_firefox_ios contextual_services: glean_app: false pretty_name: Contextual Services owners: - rburwei@mozilla.com - mbowerman@mozilla.com views: sponsored_tiles_ad_request_fill: type: table_view tables: - table: mozdata.telemetry.sponsored_tiles_ad_request_fill mozilla_vpn_private: glean_app: false connection: bigquery-oauth pretty_name: Mozilla VPN owners: - dthorn@mozilla.com spoke: looker-spoke-private mozilla_vpn: glean_app: true owners: - dthorn@mozilla.com pretty_name: Mozilla VPN views: devices: type: table_view tables: - channel: release table: mozdata.mozilla_vpn.devices funnel_fxa_login_to_protected: type: table_view tables: - channel: release table: mozdata.mozilla_vpn.funnel_fxa_login_to_protected funnel_ga_to_subscriptions: type: table_view tables: - channel: release table: mozdata.mozilla_vpn.funnel_ga_to_subscriptions retention_by_subscription: type: table_view tables: - channel: release table: mozdata.mozilla_vpn.retention_by_subscription site_metrics_summary: type: table_view tables: - channel: release table: moz-fx-data-shared-prod.mozilla_vpn_derived.site_metrics_summary_v2 subscriptions: type: table_view tables: - channel: release table: mozdata.mozilla_vpn.all_subscriptions vat_rates: type: table_view tables: - channel: release table: mozdata.mozilla_vpn.vat_rates monitor_frontend: glean_app: true owners: - ksiegler@mozilla.com pretty_name: Monitor Frontend views: dashboard_user_journey_funnels: type: table_view tables: - table: moz-fx-data-shared-prod.monitor_frontend_derived.monitor_dashboard_user_journey_funnels_v1 explores: dashboard_user_journey_funnels: type: table_explore views: base_view: dashboard_user_journey_funnels firefox_accounts: glean_app: false owners: - loines@mozilla.com pretty_name: Firefox Accounts views: all_events: type: events_view tables: - events_table_view: all_events_table base_table: mozdata.firefox_accounts.fxa_all_events events: type: events_view tables: - events_table_view: fxa_events_table base_table: mozdata.firefox_accounts.fxa_content_auth_oauth_events auth_events: type: events_view tables: - events_table_view: fxa_auth_events_table base_table: mozdata.firefox_accounts.fxa_content_auth_events content_auth_stdout_events: type: events_view tables: - events_table_view: fxa_content_auth_stdout_events_table base_table: mozdata.firefox_accounts.fxa_content_auth_stdout_events all_events_table: type: table_view tables: - table: mozdata.firefox_accounts.fxa_all_events time_partitioning_field: "timestamp" fxa_events_table: type: table_view tables: - channel: release table: mozdata.firefox_accounts.fxa_content_auth_oauth_events time_partitioning_field: "timestamp" fxa_auth_events_table: type: table_view tables: - channel: release table: mozdata.firefox_accounts.fxa_content_auth_events time_partitioning_field: "timestamp" fxa_content_auth_stdout_events_table: type: table_view tables: - channel: release table: mozdata.firefox_accounts.fxa_content_auth_stdout_events time_partitioning_field: "timestamp" growth_accounting: type: growth_accounting_view identifier_field: user_id_sha256 tables: - table: mozdata.accounts_backend.users_services_last_seen fxa_first_seen_table: type: table_view tables: - channel: release table: mozdata.firefox_accounts.fxa_users_first_seen fxa_users_services_first_seen_table: type: table_view tables: - table: mozdata.firefox_accounts.fxa_users_services_first_seen fxa_users_services_daily_table: type: table_view tables: - table: mozdata.firefox_accounts.fxa_users_services_daily fxa_log_device_command_events: type: table_view tables: - channel: release table: mozdata.firefox_accounts.fxa_log_device_command_events login_funnels_by_service: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend.login_funnels_by_service registration_funnels_by_service: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend.registration_funnels_by_service registration_funnels_legacy_events: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_accounts_derived.registration_funnels_legacy_events_v1 accounts_aggregates: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_db.accounts_aggregates accounts_oauth_clients: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_db.fxa_oauth_clients database_counts: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_backend.monitoring_db_counts measures: total_rows_sum: type: sum sql: ${total_rows} monitor_mozilla_accounts_funnels: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend_derived.monitor_mozilla_accounts_funnels_v1 password_reset_funnels: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend_derived.pwd_reset_funnels_v1 password_reset_funnels_by_service: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend_derived.pwd_reset_funnels_by_service_v1 email_first_funnels: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend_derived.email_first_reg_login_funnels_v1 email_first_funnels_by_service: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend.email_first_reg_login_funnels_by_service registration_engagement_funnels_by_service: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend_derived.reg_engagement_funnel_v1 login_engagement_funnels_by_service: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend_derived.login_engagement_funnel_v1 recovery_phone_segments: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_backend_derived.monitoring_db_recovery_phones_counts_v1 measures: total_rows_sum: type: sum sql: ${total_rows} health_counts: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_accounts_derived.health_counts_v1 measures: count_sum: type: sum sql: ${count} health_issues: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_accounts_derived.health_issues_v1 measures: count: type: count health_lighthouse: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_accounts_derived.health_lighthouse_v1 measures: count: type: count health_pingdom: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_accounts_derived.health_pingdom_v1 measures: count: type: count health_prs: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_accounts_derived.health_prs_v1 measures: count: type: count health_tags: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_accounts_derived.health_tags_v1 measures: count: type: count health_twilio: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_accounts_derived.health_twilio_v1 measures: row_count: type: count count_sum: type: sum sql: ${count} price_sum: type: sum sql: ${price} account_settings_page_engagement: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend_derived.accounts_pref_engagement_v1 account_settings_delete_account_funnel: type: table_view tables: - table: moz-fx-data-shared-prod.accounts_frontend_derived.account_pref_delete_funnel_v1 explores: all_event_counts: type: events_explore views: base_view: all_events extended_view: all_events_table event_counts: type: events_explore views: base_view: events extended_view: fxa_events_table auth_event_counts: type: events_explore views: base_view: auth_events extended_view: fxa_auth_events_table content_auth_stdout_event_counts: type: events_explore views: base_view: content_auth_stdout_events extended_view: fxa_content_auth_stdout_events_table growth_accounting: type: growth_accounting_explore views: base_view: growth_accounting accounts_aggregates: type: table_explore views: base_view: accounts_aggregates accounts_oauth_clients: type: table_explore views: base_view: accounts_oauth_clients database_counts: type: table_explore views: base_view: database_counts monitor_mozilla_accounts_funnels: type: table_explore views: base_view: monitor_mozilla_accounts_funnels registration_funnels_legacy_events: type: table_explore views: base_view: registration_funnels_legacy_events password_reset_funnels: type: table_explore views: base_view: password_reset_funnels password_reset_funnels_by_service: type: table_explore views: base_view: password_reset_funnels_by_service email_first_funnels: type: table_explore views: base_view: email_first_funnels email_first_funnels_by_service: type: table_explore views: base_view: email_first_funnels_by_service login_funnels_by_service: type: table_explore views: base_view: login_funnels_by_service registration_funnels_by_service: type: table_explore views: base_view: registration_funnels_by_service registration_engagement_funnels_by_service: type: table_explore views: base_view: registration_engagement_funnels_by_service login_engagement_funnels_by_service: type: table_explore views: base_view: login_engagement_funnels_by_service recovery_phone_segments: type: table_explore views: base_view: recovery_phone_segments health_counts: type: table_explore views: base_view: health_counts health_issues: type: table_explore views: base_view: health_issues health_lighthouse: type: table_explore views: base_view: health_lighthouse health_pingdom: type: table_explore views: base_view: health_pingdom health_prs: type: table_explore views: base_view: health_prs health_tags: type: table_explore views: base_view: health_tags health_twilio: type: table_explore views: base_view: health_twilio account_settings_page_engagement: type: table_explore views: base_view: account_settings_page_engagement account_settings_delete_account_funnel: type: table_explore views: base_view: account_settings_delete_account_funnel revenue: glean_app: false connection: bigquery-oauth pretty_name: Revenue owners: - akomarzewski@mozilla.com - skahmann@mozilla.com spoke: looker-spoke-private views: firefox_ltv: type: table_view tables: - table: mozdata.revenue.firefox_ltv fenix_ltv: type: table_view tables: - table: mozdata.ltv.fenix_client_ltv firefox_ios_ltv: type: table_view tables: - table: mozdata.ltv.firefox_ios_client_ltv firefox_desktop_ltv: type: table_view tables: - table: mozdata.ltv.firefox_desktop_client_ltv revenue_google_top10_row_data: type: table_view tables: - table: mozdata.revenue.revenue_google_top10_row_data stripe_itemized_payout_reconciliation: type: table_view tables: - table: mozdata.stripe.itemized_payout_reconciliation stripe_itemized_tax_transactions: type: table_view tables: - table: mozdata.stripe.itemized_tax_transactions ad_cost_breakdowns: type: table_view tables: - table: moz-fx-data-shared-prod.fenix_derived.google_ads_campaign_cost_breakdowns_v1 search_revenue_levers_monthly: type: table_view tables: - table: mozdata.revenue.search_revenue_levers_monthly revenue_private: glean_app: false connection: bigquery-oauth pretty_name: Revenue Private owners: - akommasani@mozilla.com - akomarzewski@mozilla.com - skahmann@mozilla.com spoke: looker-spoke-private views: search_revenue_levers_daily: type: table_view tables: - table: mozdata.search.search_revenue_levers_daily ads: glean_app: false connection: bigquery-oauth pretty_name: Ads owners: - cmorales@mozilla.com - cbeck@mozilla.com - lvargas@mozilla.com - sbetancourt@mozilla.com - jsnyder@mozilla.com spoke: looker-spoke-private views: android_pocket_spocs: type: table_view tables: - table: mozdata.ads.android_pocket_spocs consolidated_ad_metrics_daily_pt: type: table_view tables: - table: mozdata.ads.consolidated_ad_metrics_daily_pt consolidated_ad_metrics_hourly: type: table_view tables: - table: mozdata.ads.consolidated_ad_metrics_hourly tiles_addressable_inventory_hourly: type: table_view tables: - table: mozdata.ads.tiles_addressable_inventory_hourly amp_search_with: type: table_view tables: - table: mozdata.ads.amp_search_with campaign_metrics_daily: type: table_view tables: - table: mozdata.ads.campaign_metrics_daily firefox_ios: pretty_name: Firefox iOS owners: - darcese@mozilla.com - kik@mozilla.com - rbaffourawuah@mozilla.com - vsabino@mozilla.com views: feature_usage_metrics: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_ios.feature_usage_metrics feature_usage_events: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_ios.feature_usage_events clients_activation: type: table_view tables: - table: mozdata.firefox_ios.clients_activation firefox_ios_clients: type: table_view tables: - table: mozdata.firefox_ios.firefox_ios_clients explores: feature_usage_metrics: type: table_explore views: base_view: feature_usage_metrics feature_usage_events: type: table_explore views: base_view: feature_usage_events clients_activation: type: table_explore views: base_view: clients_activation fenix: pretty_name: Firefox Android owners: - vzare@mozilla.com - rbaffourawuah@mozilla.com - vsabino@mozilla.com - kik@mozilla.com views: android_store_performance: type: table_view tables: - table: moz-fx-data-marketing-prod.google_play_store.Store_Performance_country_v1 android_onboarding: type: table_view tables: - table: moz-fx-data-shared-prod.fenix_derived.android_onboarding_v1 feature_usage_metrics: type: table_view tables: - table: moz-fx-data-shared-prod.fenix.feature_usage_metrics feature_usage_events: type: table_view tables: - table: moz-fx-data-shared-prod.fenix.feature_usage_events firefox_android_clients: type: table_view tables: - table: mozdata.fenix.firefox_android_clients explores: feature_usage_metrics: type: table_explore views: base_view: feature_usage_metrics feature_usage_events: type: table_explore views: base_view: feature_usage_events newtab: glean_app: false connection: bigquery-oauth pretty_name: New Tab owners: - cmorales@mozilla.com - mbowerman@mozilla.com spoke: looker-spoke-private experimentation: glean_app: false owners: - ascholtz@mozilla.com pretty_name: Experimentation views: logs: type: table_view tables: - channel: release table: moz-fx-data-experiments.monitoring.logs query_cost: type: table_view tables: - channel: release table: moz-fx-data-experiments.monitoring.query_cost_v1 task_monitoring_logs: type: table_view tables: - channel: release table: moz-fx-data-experiments.monitoring.task_monitoring_logs experiment_enrollment_daily_active_population: type: table_view tables: - channel: release table: mozdata.telemetry.experiment_enrollment_daily_active_population experiment_enrollment_cumulative_population_estimate: type: table_view tables: - channel: release table: mozdata.telemetry.experiment_enrollment_cumulative_population_estimate experiment_enrollment_overall: type: table_view tables: - channel: release table: mozdata.telemetry.experiment_enrollment_overall experiment_unenrollment_overall: type: table_view tables: - channel: release table: mozdata.telemetry.experiment_unenrollment_overall experiment_enrollment_other_events_overall: type: table_view tables: - channel: release table: mozdata.telemetry.experiment_enrollment_other_events_overall experiment_cumulative_search_with_ads_count: type: table_view tables: - channel: release table: mozdata.telemetry.experiment_cumulative_search_with_ads_count experiment_cumulative_search_count: type: table_view tables: - channel: release table: mozdata.telemetry.experiment_cumulative_search_count experiment_cumulative_ad_clicks: type: table_view tables: - channel: release table: mozdata.telemetry.experiment_cumulative_ad_clicks experimenter_experiments: type: table_view tables: - channel: release table: moz-fx-data-experiments.monitoring.experimenter_experiments_v1 experiment_search_aggregates_live: type: table_view tables: - channel: release table: moz-fx-data-shared-prod.telemetry_derived.experiment_search_aggregates_live_v1 experiment_crash_rates: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.experiment_crash_rates_live explores: experiment_crash_rates: type: table_explore views: base_view: experiment_crash_rates firefox_desktop: glean_app: true views: firefox_desktop_baseline_active_users_aggregates: type: table_view tables: - table: mozdata.firefox_desktop.baseline_active_users_aggregates desktop_acquisition_funnel_table: type: table_view tables: - table: mozdata.telemetry.desktop_acquisition_funnel urlbar_events_table: type: table_view tables: - table: mozdata.firefox_desktop.urlbar_events urlbar_events: type: events_view tables: - events_table_view: urlbar_events_table base_table: mozdata.firefox_desktop.urlbar_events urlbar_events_daily_table: type: table_view tables: - table: mozdata.firefox_desktop.urlbar_events_daily serp_categorization_unnested_table: type: table_view tables: - table: mozdata.firefox_desktop.serp_categorization_unnested feature_usage_table: type: table_view tables: - table: mozdata.telemetry.feature_usage clients_last_seen_table: type: table_view tables: - table: mozdata.telemetry.clients_last_seen clients_daily_table: type: table_view tables: - table: mozdata.telemetry.clients_daily clients_daily_joined_table: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry_derived.clients_daily_joined_v1 client_counts: type: client_counts_view tables: - table: mozdata.telemetry.clients_daily sponsored_tiles_clients_daily_table: type: table_view tables: - table: mozdata.telemetry.sponsored_tiles_clients_daily sponsored_tiles_clients_daily: type: table_view tables: - table: mozdata.telemetry.sponsored_tiles_clients_daily suggest_clients_daily_table: type: table_view tables: - table: mozdata.telemetry.suggest_clients_daily suggest_clients_daily: type: table_view tables: - table: mozdata.telemetry.suggest_clients_daily funnel_analysis: type: funnel_analysis_view tables: - funnel_analysis: events_daily_table event_types: mozdata.telemetry.event_types step_1: event_types step_2: event_types step_3: event_types step_4: event_types events_daily_table: type: table_view tables: - channel: release table: mozdata.telemetry.events_daily growth_accounting: type: growth_accounting_view tables: - table: mozdata.telemetry.clients_last_seen events: type: events_view tables: - events_table_view: desktop_events_table base_table: mozdata.telemetry.events glean_events: type: events_view tables: - events_table_view: events_unnested_table base_table: mozdata.firefox_desktop.events_unnested desktop_events_table: type: table_view tables: - channel: release table: mozdata.telemetry.events newtab_interactions_table: type: table_view tables: - table: mozdata.telemetry.newtab_interactions newtab_visits_table: type: table_view tables: - table: mozdata.telemetry.newtab_visits default_browser: type: ping_view tables: - table: mozdata.default_browser_agent.default_browser clients_first_seen_v2: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry_derived.clients_first_seen_v2 desktop_cohort_daily_retention: type: table_view tables: - table: mozdata.telemetry.desktop_cohort_daily_retention desktop_new_profiles: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.desktop_new_profiles fenix_distribution_deal: type: table_view tables: - table: mozdata.analysis.fenix_distribution_deal_v1 newtab_items_daily: type: table_view tables: - table: moz-fx-data-shared-prod.firefox_desktop_derived.newtab_items_daily_v1 explores: client_counts: type: client_counts_explore views: base_view: client_counts extended_view: clients_daily_table funnel_analysis: type: funnel_analysis_explore views: base_view: funnel_analysis growth_accounting: type: growth_accounting_explore views: base_view: growth_accounting events: type: events_explore views: base_view: events extended_view: desktop_events_table glean_event_counts: type: events_explore views: base_view: glean_events extended_view: events_unnested_table default_browser: type: ping_explore views: base_view: default_browser urlbar_events_daily: type: table_explore views: base_view: urlbar_events_daily_table serp_categorization_unnested: type: table_explore views: base_view: serp_categorization_unnested_table fenix_distribution_deal: type: table_explore views: base_view: fenix_distribution_deal newtab_items_daily: type: table_explore views: base_view: newtab_items_daily monitoring: glean_app: false owners: - ascholtz@mozilla.com - akomar@mozilla.com - anicholson@mozilla.com - mhirose@mozilla.com - kik@mozilla.com - wichan@mozilla.com pretty_name: Monitoring (Data Pipeline) views: metadata_completeness: tables: - table: mozdata.monitoring.metadata_completeness type: table_view metadata_completeness_summary: tables: - table: mozdata.monitoring.metadata_completeness_summary type: table_view bigquery_tables_inventory: tables: - table: moz-fx-data-shared-prod.monitoring.bigquery_tables_inventory type: table_view bigquery_table_storage: tables: - table: moz-fx-data-shared-prod.monitoring.bigquery_table_storage type: table_view bigquery_shared_prod_table_storage: tables: - table: mozdata.monitoring.table_storage type: table_view bigquery_shared_prod_table_storage_trends: tables: - table: moz-fx-data-shared-prod.monitoring.table_storage_trends type: table_view bigquery_table_storage_timeline_daily: tables: - table: moz-fx-data-shared-prod.monitoring.bigquery_table_storage_timeline_daily type: table_view bigquery_usage: tables: - table: moz-fx-data-shared-prod.monitoring.bigquery_usage type: table_view column_size: type: ping_view tables: - table: mozdata.monitoring.column_size payload_bytes_error_all: type: ping_view tables: - table: mozdata.monitoring.payload_bytes_error_all schema_error_counts: type: ping_view tables: - table: mozdata.monitoring.schema_error_counts stable_and_derived_table_sizes: type: ping_view tables: - table: mozdata.monitoring.stable_and_derived_table_sizes stable_table_column_counts: type: ping_view tables: - table: mozdata.monitoring.stable_table_column_counts structured_missing_columns: type: ping_view tables: - table: mozdata.monitoring.structured_missing_columns telemetry_missing_columns: type: ping_view tables: - table: mozdata.monitoring.telemetry_missing_columns missing_columns_notes: type: table_view tables: - table: mozdata.static.monitoring_missing_columns_notes_v1 missing_document_namespaces_notes: type: table_view tables: - table: mozdata.static.monitoring_missing_document_namespaces_notes_v1 schema_errors_notes: type: table_view tables: - table: mozdata.static.monitoring_schema_errors_notes_v1 shredder_per_job_stats: type: table_view tables: - table: mozdata.monitoring.shredder_per_job_stats shredder_targets_new_mismatched_targets: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring_derived.shredder_targets_new_mismatched_v1 table_partition_expirations: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring_derived.table_partition_expirations_v1 # views for accessing Airflow metadata airflow_dag: type: table_view tables: - table: mozdata.monitoring.airflow_dag airflow_dag_note: type: table_view tables: - table: mozdata.monitoring.airflow_dag_note airflow_dag_owner_attributes: type: table_view tables: - table: mozdata.monitoring.airflow_dag_owner_attributes airflow_dag_run: type: table_view tables: - table: mozdata.monitoring.airflow_dag_run airflow_dag_tag: type: table_view tables: - table: mozdata.monitoring.airflow_dag_tag airflow_dag_warning: type: table_view tables: - table: mozdata.monitoring.airflow_dag_warning airflow_import_error: type: table_view tables: - table: mozdata.monitoring.airflow_import_error airflow_job: type: table_view tables: - table: mozdata.monitoring.airflow_job airflow_slot_pool: type: table_view tables: - table: mozdata.monitoring.airflow_slot_pool airflow_task_fail: type: table_view tables: - table: mozdata.monitoring.airflow_task_fail airflow_task_instance: type: table_view tables: - table: mozdata.monitoring.airflow_task_instance airflow_task_instance_note: type: table_view tables: - table: mozdata.monitoring.airflow_task_instance_note airflow_task_reschedule: type: table_view tables: - table: mozdata.monitoring.airflow_task_reschedule airflow_trigger: type: table_view tables: - table: mozdata.monitoring.airflow_trigger airflow_user: type: table_view tables: - table: mozdata.monitoring.airflow_user bigeye_usage: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring.bigeye_usage measures: cost_sum: type: sum sql: "${cost}" total_terabytes_processed_sum: type: sum sql: "${total_terabytes_processed}" total_terabytes_billed_sum: type: sum sql: "${total_terabytes_billed}" total_slot_ms_sum: type: sum sql: "${total_slot_ms}" task_duration_seconds_sum: type: sum sql: "${task_duration_seconds}" event_monitoring_live: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring.event_monitoring_live event_error_monitoring_aggregates: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring_derived.event_error_monitoring_aggregates_v1 legacy_desktop_event_counts: type: table_view tables: - table: mozdata.telemetry.event_aggregates glean_event_counts: type: table_view tables: - table: mozdata.monitoring.event_counts_glean mlops_job_cost_per_job: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring_derived.outerbounds_cost_per_flow_v1 mlops_job_cost_per_job_run: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring_derived.outerbounds_cost_per_flow_run_v1 mlops_rayserve_cost_fakespot_tenant: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring_derived.rayserve_cost_fakespot_tenant_v1 mlops_rayserve_cost_fakespot_tenant_prod: type: table_view tables: - table: moz-fx-data-shared-prod.monitoring_derived.rayserve_cost_fakespot_tenant_prod_v1 looker_dashboard_load_times: type: table_view tables: - table: mozdata.monitoring.looker_dashboard_load_times explores: column_size: type: ping_explore views: base_view: column_size payload_bytes_error_all: type: ping_explore views: base_view: payload_bytes_error_all schema_error_counts: type: ping_explore views: base_view: schema_error_counts stable_and_dervied_table_sizes: type: ping_explore views: base_view: stable_and_derived_table_sizes stable_table_column_counts: type: ping_explore views: base_view: stable_table_column_counts structured_missing_columns: type: ping_explore views: base_view: structured_missing_columns telemetry_missing_columns: type: ping_explore views: base_view: telemetry_missing_columns legacy_desktop_event_counts: type: table_explore views: base_view: legacy_desktop_event_counts glean_event_counts: type: table_explore views: base_view: glean_event_counts looker_dashboard_load_times: type: table_explore views: base_view: looker_dashboard_load_times casa: glean_app: false spoke: looker-spoke-private connection: bigquery-casa owners: - anicholson@mozilla.com pretty_name: CASA views: projects: type: table_view tables: - table: mozdata.casa.projects users: type: table_view tables: - table: mozdata.casa.users reference: glean_app: false pretty_name: Reference owners: - cmorales@mozilla.com spoke: looker-spoke-default views: macroeconomic_indices: type: table_view tables: - table: mozdata.external.macroeconomic_indices calendar: type: table_view tables: - table: mozdata.external.calendar holiday: type: table_view tables: - table: mozdata.external.holidays chrome_extensions: type: table_view tables: - table: mozdata.external.chrome_extensions imf_gross_domestic_product: type: table_view tables: - table: mozdata.external.gdp imf_exchange_rates: type: table_view tables: - table: mozdata.external.imf_exchange_rates inflation_monthly: type: table_view tables: - table: mozdata.external.monthly_inflation inflation_quarterly: type: table_view tables: - table: mozdata.external.quarterly_inflation population_by_country: type: table_view tables: - table: mozdata.external.population_by_country kpi: glean_app: false owners: - loines@mozilla.com pretty_name: KPI views: unified_metrics: type: ping_view tables: - table: mozdata.telemetry.unified_metrics automated_kpi_forecasts: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry_derived.kpi_automated_forecast_v1 automated_kpi_confidence_intervals: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry_derived.kpi_automated_forecast_confidences_v1 explores: unified_metrics: type: ping_explore views: base_view: unified_metrics fpa: glean_app: false connection: bigquery-oauth pretty_name: FP&A owners: - ngrammater@mozilla.com - rmiller@mozilla.com - lakshmimurugan@google.com spoke: looker-spoke-private shared: glean_app: false pretty_name: Shared owners: - ascholtz@mozilla.com views: countries: type: table_view tables: - table: mozdata.static.country_codes_v1 data_incidents: type: table_view tables: - table: mozdata.static.data_incidents_v1 applications: type: table_view tables: - table: mozdata.telemetry.applications shared_private: glean_app: false pretty_name: Shared Private owners: - ascholtz@mozilla.com spoke: looker-spoke-private views: countries: type: table_view tables: - table: mozdata.static.country_codes_v1 websites: glean_app: false pretty_name: Websites spoke: looker-spoke-default owners: - kik@mozilla.com views: ga4_www_site_downloads: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.www_site_downloads ga4_sessions: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.ga_sessions_v2 moz_org_page_metrics: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.www_site_page_metrics moz_org_metrics_summary: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.www_site_metrics_summary moz_org_landing_page_metrics: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.www_site_landing_page_metrics ga4_blogs_sessions: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.blogs_sessions ga4_blogs_goals: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.blogs_goals blogs_daily_summary: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.blogs_daily_summary blogs_landing_page_summary: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.blogs_landing_page_summary www_site_events_metrics: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.www_site_events_metrics firefox_whatsnew_summary: type: table_view tables: - table: moz-fx-data-shared-prod.mozilla_org.firefox_whatsnew_summary google_search_console_by_page: type: table_view tables: - table: mozdata.google_search_console.search_impressions_by_page google_search_console_by_site: type: table_view tables: - table: mozdata.google_search_console.search_impressions_by_site limited_historical_google_search_console_by_page: type: table_view tables: - table: mozdata.google_search_console.limited_historical_search_impressions_by_page limited_historical_google_search_console_by_site: type: table_view tables: - table: mozdata.google_search_console.limited_historical_search_impressions_by_site marketing: glean_app: false pretty_name: Marketing spoke: looker-spoke-default owners: - kik@mozilla.com views: firefox_for_families_forecasted_expectations: type: table_view tables: - table: mozdata.analysis.marketing_firefox_for_families_forecasted_expectations relay: glean_app: false owners: - srose@mozilla.com - ysmith@mozilla.com pretty_name: Firefox Relay views: subscriptions: type: table_view tables: - table: mozdata.relay.subscriptions subscription_events: type: table_view tables: - table: mozdata.relay.subscription_events active_subscriptions: type: table_view tables: - table: mozdata.relay.active_subscriptions active_subscription_ids: type: table_view tables: - table: mozdata.relay.active_subscription_ids fivetran: glean_app: false owners: - lschiestl@mozilla.com pretty_name: Fivetran views: daily_connector_costs: type: table_view tables: - table: mozdata.fivetran_costs.daily_connector_costs hubs: glean_app: false owners: - srose@mozilla.com pretty_name: Hubs views: subscriptions: type: table_view tables: - table: mozdata.hubs.subscriptions subscription_events: type: table_view tables: - table: mozdata.hubs.subscription_events active_subscriptions: type: table_view tables: - table: mozdata.hubs.active_subscriptions active_subscription_ids: type: table_view tables: - table: mozdata.hubs.active_subscription_ids subscription_platform: pretty_name: Subscription Platform owners: - srose@mozilla.com glean_app: false views: # Using `_v1` views to avoid breakages when v2 tables are deployed. apple_subscriptions_v1: type: table_view tables: - table: moz-fx-data-shared-prod.subscription_platform_derived.apple_subscriptions_v1 measures: count: type: count google_subscriptions_v1: type: table_view tables: - table: moz-fx-data-shared-prod.subscription_platform_derived.google_subscriptions_v1 measures: count: type: count stripe_subscriptions_v1: type: table_view tables: - table: moz-fx-data-shared-prod.subscription_platform_derived.stripe_subscriptions_v1 measures: count: type: count stripe_subscriptions: type: table_view tables: - table: moz-fx-data-shared-prod.subscription_platform_derived.stripe_subscriptions_v2 active_subscriptions: type: table_view tables: - table: mozdata.subscription_platform.active_subscriptions measures: count_sum: type: sum sql: ${count} stripe_plans: type: table_view tables: - table: mozdata.subscription_platform.stripe_plans stripe_products: type: table_view tables: - table: mozdata.subscription_platform.stripe_products # Logical subscriptions logical_subscriptions: type: table_view tables: - table: mozdata.subscription_platform.logical_subscriptions logical_subscription_events: type: table_view tables: - table: mozdata.subscription_platform.logical_subscription_events daily_active_logical_subscriptions: type: table_view tables: - table: mozdata.subscription_platform.daily_active_logical_subscriptions monthly_active_logical_subscriptions: type: table_view tables: - table: mozdata.subscription_platform.monthly_active_logical_subscriptions # Service subscriptions service_subscriptions: type: table_view tables: - table: mozdata.subscription_platform.service_subscriptions service_subscription_events: type: table_view tables: - table: mozdata.subscription_platform.service_subscription_events daily_active_service_subscriptions: type: table_view tables: - table: mozdata.subscription_platform.daily_active_service_subscriptions monthly_active_service_subscriptions: type: table_view tables: - table: mozdata.subscription_platform.monthly_active_service_subscriptions explores: # Using `_v1` explores to avoid breakages when v2 tables are deployed. apple_subscriptions_v1: type: table_explore views: base_view: apple_subscriptions_v1 google_subscriptions_v1: type: table_explore views: base_view: google_subscriptions_v1 stripe_subscriptions_v1: type: table_explore views: base_view: stripe_subscriptions_v1 active_subscriptions: type: table_explore views: base_view: active_subscriptions telemetry_dev_cycle: pretty_name: Telemetry Dev Cycle owners: - leli@mozilla.com glean_app: false views: data_review_stats: type: table_view tables: - table: mozdata.telemetry_dev_cycle.data_review_stats experiments_stats: type: table_view tables: - table: mozdata.telemetry_dev_cycle.experiments_stats glean_metrics_stats: type: table_view tables: - table: mozdata.telemetry_dev_cycle.glean_metrics_stats telemetry_probes_stats: type: table_view tables: - table: mozdata.telemetry_dev_cycle.telemetry_probes_stats growth: pretty_name: Growth owners: - fbertsch@mozilla.com - kik@mozilla.com glean_app: false views: browser_usage: type: table_view tables: - table: mozdata.cloudflare.browser_usage device_usage: type: table_view tables: - table: mozdata.cloudflare.device_usage operating_system_usage: type: table_view tables: - table: mozdata.cloudflare.os_usage android_app_campaign_stats: type: table_view tables: - table: moz-fx-data-shared-prod.google_ads.android_app_campaign_stats ios_app_campaign_stats: type: table_view tables: - table: moz-fx-data-shared-prod.apple_ads_external.ios_app_campaign_stats_v1 rolling_28_day_dau: type: table_view tables: - table: mozdata.telemetry.segmented_dau_28_day_rolling user_journey: pretty_name: User Journey owners: - fbertsch@mozilla.com glean_app: false firefox_okrs: glean_app: false owners: - vsabino@mozilla.com - rbaffourawuah@mozilla.com - kik@mozilla.com pretty_name: Firefox OKRs views: desktop_retention: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.desktop_retention desktop_engagement: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.desktop_engagement mobile_retention: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.mobile_retention mobile_engagement: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.mobile_engagement mobile_new_profiles: type: table_view tables: - table: moz-fx-data-shared-prod.telemetry.mobile_new_profiles fakespot: pretty_name: Fakespot owners: - wstuckey@mozilla.com glean_app: false firefox_metrics: pretty_name: Firefox Metrics owners: - vsabino@mozilla.com glean_app: false fxci: pretty_name: Firefox-CI Taskcluster owners: - ahalberstadt@mozilla.com glean_app: false views: tasks_base: type: table_view tables: - table: moz-fx-data-shared-prod.fxci.tasks task_runs_base: type: table_view tables: - table: moz-fx-data-shared-prod.fxci.task_runs task_run_costs_base: type: table_view tables: - table: moz-fx-data-shared-prod.fxci.task_run_costs worker_costs_base: type: table_view tables: - table: moz-fx-data-shared-prod.fxci.worker_costs worker_metrics_base: type: table_view tables: - table: moz-fx-data-shared-prod.fxci.worker_metrics accounts_backend: explores: accounts_events: hidden: true type: glean_ping_explore views: base_view: accounts_events accounts_frontend: explores: accounts_events: hidden: true type: glean_ping_explore views: base_view: accounts_events jira_service_desk: pretty_name: Jira Service Desk connection: bigquery-oauth owners: - rantwan@mozilla.com glean_app: false views: issue: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.issue issue_type: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.issue_type project: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.project status: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.status resolution: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.resolution field: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.field field_option: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.field_option issue_field_history: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.issue_field_history issue_multiselect_history: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.issue_multiselect_history request: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.request request_type: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.request_type status_category: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.status_category user: type: table_view tables: - table: moz-fx-data-shared-prod.jira_service_desk.user explores: issue: type: table_explore views: base_view: issue issue_type: type: table_explore views: base_view: issue_type project: type: table_explore views: base_view: project status: type: table_explore views: base_view: status resolution: type: table_explore views: base_view: resolution field: type: table_explore views: base_view: field field_option: type: table_explore views: base_view: field_option issue_field_history: type: table_explore views: base_view: issue_field_history issue_multiselect_history: type: table_explore views: base_view: issue_multiselect_history request: type: table_explore views: base_view: request request_type: type: table_explore views: base_view: request_type status_category: type: table_explore views: base_view: status_category user: type: table_explore views: base_view: user zoom: pretty_name: Zoom connection: bigquery-oauth owners: - rantwan@mozilla.com glean_app: false views: meetings: type: table_view tables: - table: mozdata.zoom.meetings meeting_reports: type: table_view tables: - table: mozdata.zoom.meeting_reports meeting_participants: type: table_view tables: - table: mozdata.zoom.meeting_participants users: type: table_view tables: - table: mozdata.zoom.users device_manufacturer_partnerships: glean_app: false pretty_name: Device Manufacturer Partnerships owners: - mbowerman@mozilla.com - kik@mozilla.com spoke: looker-spoke-default views: shipment_and_activation_vivo: type: table_view tables: - table: mozdata.device_manufacturer_partnerships.shipment_and_activation_vivo