dataops-ci-bot
commented
2 months ago Integration report for "Fix event name to be correct"
sql.diff
Click to expand!
```diff diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/dags/bqetl_generated_funnels.py /tmp/workspace/generated-sql/dags/bqetl_generated_funnels.py --- /tmp/workspace/main-generated-sql/dags/bqetl_generated_funnels.py 2024-07-31 20:53:24.000000000 +0000 +++ /tmp/workspace/generated-sql/dags/bqetl_generated_funnels.py 2024-07-31 21:12:11.000000000 +0000 @@ -288,6 +288,21 @@ ) ) + monitor_frontend_derived__monitor_dashboard_user_journey_funnels__v1 = bigquery_etl_query( + task_id="monitor_frontend_derived__monitor_dashboard_user_journey_funnels__v1", + destination_table="monitor_dashboard_user_journey_funnels_v1", + dataset_id="monitor_frontend_derived", + project_id="moz-fx-data-shared-prod", + owner="ksiegler@mozilla.org", + email=[ + "ascholtz@mozilla.com", + "ksiegler@mozilla.org", + "telemetry-alerts@mozilla.com", + ], + date_partition_parameter="submission_date", + depends_on_past=False, + ) + accounts_frontend_derived__email_first_reg_login_funnels_by_service__v1.set_upstream( wait_for_copy_deduplicate_all ) @@ -349,3 +364,7 @@ firefox_accounts_derived__registration_funnels_legacy_events__v1.set_upstream( wait_for_firefox_accounts_derived__fxa_stdout_events__v1 ) + + monitor_frontend_derived__monitor_dashboard_user_journey_funnels__v1.set_upstream( + wait_for_copy_deduplicate_all + ) diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/reg_engagement_funnel_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/reg_engagement_funnel_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/reg_engagement_funnel_v1/query.sql 2024-07-31 20:47:55.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/reg_engagement_funnel_v1/query.sql 2024-07-31 20:56:16.000000000 +0000 @@ -396,7 +396,7 @@ {% else %} DATE(submission_timestamp) = @submission_date {% endif %} - AND event = 'reg.google_oauth_reg_start' + AND event = 'third_party_auth.google_reg_start' AND metrics.string.session_flow_id != '' ), registration_apple_engage_reg_view AS ( @@ -446,7 +446,7 @@ {% else %} DATE(submission_timestamp) = @submission_date {% endif %} - AND event = 'reg.apple_oauth_reg_start' + AND event = 'third_party_auth.apple_reg_start' AND metrics.string.session_flow_id != '' ), -- aggregate each funnel step value diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml 2024-07-31 20:47:17.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml 2024-07-31 20:56:33.000000000 +0000 @@ -1,49 +1,49 @@ fields: -- mode: NULLABLE - name: submission_date +- name: submission_date type: DATE -- mode: NULLABLE - name: source + mode: NULLABLE +- name: source type: STRING -- mode: NULLABLE - name: event_type + mode: NULLABLE +- name: event_type type: STRING -- mode: NULLABLE - name: form_factor + mode: NULLABLE +- name: form_factor type: STRING -- mode: NULLABLE - name: country + mode: NULLABLE +- name: country type: STRING -- mode: NULLABLE - name: subdivision1 + mode: NULLABLE +- name: subdivision1 type: STRING -- mode: NULLABLE - name: advertiser + mode: NULLABLE +- name: advertiser type: STRING -- mode: NULLABLE - name: release_channel + mode: NULLABLE +- name: release_channel type: STRING -- mode: NULLABLE - name: position + mode: NULLABLE +- name: position type: INTEGER -- mode: NULLABLE - name: provider + mode: NULLABLE +- name: provider type: STRING -- mode: NULLABLE - name: match_type + mode: NULLABLE +- name: match_type type: STRING -- mode: NULLABLE - name: normalized_os + mode: NULLABLE +- name: normalized_os type: STRING -- mode: NULLABLE - name: suggest_data_sharing_enabled + mode: NULLABLE +- name: suggest_data_sharing_enabled type: BOOLEAN -- mode: NULLABLE - name: event_count + mode: NULLABLE +- name: event_count type: INTEGER -- mode: NULLABLE - name: user_count + mode: NULLABLE +- name: user_count type: INTEGER -- mode: NULLABLE - name: query_type + mode: NULLABLE +- name: query_type type: STRING + mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml 2024-07-31 20:47:17.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml 2024-07-31 20:56:33.000000000 +0000 @@ -1,40 +1,40 @@ fields: -- mode: NULLABLE - name: submission_date +- name: submission_date type: DATE -- mode: NULLABLE - name: form_factor + mode: NULLABLE +- name: form_factor type: STRING -- mode: NULLABLE - name: country + mode: NULLABLE +- name: country type: STRING -- mode: NULLABLE - name: advertiser + mode: NULLABLE +- name: advertiser type: STRING -- mode: NULLABLE - name: normalized_os + mode: NULLABLE +- name: normalized_os type: STRING -- mode: NULLABLE - name: release_channel + mode: NULLABLE +- name: release_channel type: STRING -- mode: NULLABLE - name: position + mode: NULLABLE +- name: position type: INTEGER -- mode: NULLABLE - name: provider + mode: NULLABLE +- name: provider type: STRING -- mode: NULLABLE - name: match_type + mode: NULLABLE +- name: match_type type: STRING -- mode: NULLABLE - name: suggest_data_sharing_enabled + mode: NULLABLE +- name: suggest_data_sharing_enabled type: BOOLEAN -- mode: NULLABLE - name: impression_count + mode: NULLABLE +- name: impression_count type: INTEGER -- mode: NULLABLE - name: click_count + mode: NULLABLE +- name: click_count type: INTEGER -- mode: NULLABLE - name: query_type + mode: NULLABLE +- name: query_type type: STRING + mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml 2024-07-31 20:47:17.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml 2024-07-31 20:57:42.000000000 +0000 @@ -26,6 +26,9 @@ - name: adjust_network type: STRING mode: NULLABLE +- name: install_source + type: STRING + mode: NULLABLE - name: retained_week_2 type: BOOLEAN mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml 2024-07-31 20:47:17.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml 2024-07-31 20:57:43.000000000 +0000 @@ -48,6 +48,10 @@ description: 'The type of source of a client installation. ' +- name: install_source + type: STRING + mode: NULLABLE + description: null - name: new_profiles type: INTEGER mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/focus_android/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/focus_android/use_counters/schema.yaml 2024-07-31 20:47:55.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android/use_counters/schema.yaml 2024-07-31 21:06:04.000000000 +0000 @@ -1,11 +1,11 @@ fields: - name: normalized_app_id - type: STRING mode: NULLABLE + type: STRING description: App ID of the channel data was received from - name: normalized_channel - type: STRING mode: NULLABLE + type: STRING description: Normalized channel name - name: additional_properties type: STRING diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_page/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_page/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_page/schema.yaml 2024-07-31 20:47:17.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_page/schema.yaml 2024-07-31 20:56:47.000000000 +0000 @@ -6,9 +6,10 @@ - name: site_url type: STRING mode: NULLABLE - description: |- - For domain properties, this will be `sc-domain:` followed by the domain name. - For URL-prefix properties, it will be the full URL of the property definition. + description: 'For domain properties, this will be `sc-domain:` followed by the domain + name. + + For URL-prefix properties, it will be the full URL of the property definition.' - name: site_domain_name type: STRING mode: NULLABLE @@ -16,103 +17,110 @@ - name: page_url type: STRING mode: NULLABLE - description: |- - The final page URL linked by a search result after any skip redirects. - This will be null for anonymized Discover impressions. + description: 'The final page URL linked by a search result after any skip redirects. + + This will be null for anonymized Discover impressions.' - name: page_domain_name type: STRING mode: NULLABLE - description: |- - Domain name of the page URL. - This will be null for anonymized Discover impressions. + description: 'Domain name of the page URL. + + This will be null for anonymized Discover impressions.' - name: page_path type: STRING mode: NULLABLE - description: |- - The path part of the page URL. - This will be null for anonymized Discover impressions. + description: 'The path part of the page URL. + + This will be null for anonymized Discover impressions.' - name: localized_site_code type: STRING mode: NULLABLE - description: |- - Localized site code such as `en-US` or `de` found in the first segment of the page URL path (if any). - This will be null for anonymized Discover impressions. + description: 'Localized site code such as `en-US` or `de` found in the first segment + of the page URL path (if any). + + This will be null for anonymized Discover impressions.' - name: localized_site type: STRING mode: NULLABLE - description: |- - Description of the localized site language and/or country based on `localized_site_code` (if any). - This will be null for anonymized Discover impressions. + description: 'Description of the localized site language and/or country based on + `localized_site_code` (if any). + + This will be null for anonymized Discover impressions.' - name: localized_site_language_code type: STRING mode: NULLABLE - description: |- - Localized site language code in ISO-639-alpha-2 format found in the first segment of the page URL path (if any). - This will be null for anonymized Discover impressions. + description: 'Localized site language code in ISO-639-alpha-2 format found in the + first segment of the page URL path (if any). + + This will be null for anonymized Discover impressions.' - name: localized_site_language type: STRING mode: NULLABLE - description: |- - Localized site language based on `localized_site_language_code` (if any). - This will be null for anonymized Discover impressions. + description: 'Localized site language based on `localized_site_language_code` (if + any). + + This will be null for anonymized Discover impressions.' - name: query type: STRING mode: NULLABLE - description: |- - The search query. - This will be null for anonymized search impressions, and all Discover and Google News search impressions. + description: 'The search query. + + This will be null for anonymized search impressions, and all Discover and Google + News search impressions.' - name: query_type type: STRING mode: NULLABLE - description: |- - Type of search query: - * Anonymized: Query was redacted by Google to protect the users' privacy. - * Brand: Query contained one or more Mozilla brand keywords. - * Non-Brand: Query didn't contain any Mozilla brand keywords. - * Unknown: Query couldn't be classified. - This will be null for all Discover and Google News search impressions. + description: "Type of search query:\n * Anonymized: Query was redacted by Google\ + \ to protect the users' privacy.\n * Brand: Query contained one or more Mozilla\ + \ brand keywords.\n * Non-Brand: Query didn't contain any Mozilla brand keywords.\n\ + \ * Unknown: Query couldn't be classified.\nThis will be null for all Discover\ + \ and Google News search impressions." - name: is_anonymized type: BOOLEAN mode: NULLABLE - description: |- - Whether Google has anonymized the search impression to protect the users' privacy. + description: 'Whether Google has anonymized the search impression to protect the + users'' privacy. + The `query` field will be null for anonymized search impressions. - The `country_code`, `page_url`, and related fields will be null for anonymized Discover impressions. + + The `country_code`, `page_url`, and related fields will be null for anonymized + Discover impressions.' - name: has_good_page_experience type: BOOLEAN mode: NULLABLE - description: |- - Whether Google Search considers the page to be providing a good page experience. - This will be null when the source data wasn't exported directly to BigQuery by Google. + description: 'Whether Google Search considers the page to be providing a good page + experience. + + This will be null when the source data wasn''t exported directly to BigQuery by + Google.' - name: search_type type: STRING mode: NULLABLE - description: |- - Where the link was seen by the user: - * Web: In Google Search's default "All" tab. - * Image: In Google Search's "Images" tab. - * Video: In Google Search's "Videos" tab. - * News: In Google Search's "News" tab. - * Discover: In Google's Discover feed. - * Google News: On news.google.com or in the Google News app on Android and iOS. + description: "Where the link was seen by the user:\n * Web: In Google Search's\ + \ default \"All\" tab.\n * Image: In Google Search's \"Images\" tab.\n * Video:\ + \ In Google Search's \"Videos\" tab.\n * News: In Google Search's \"News\" tab.\n\ + \ * Discover: In Google's Discover feed.\n * Google News: On news.google.com\ + \ or in the Google News app on Android and iOS." - name: search_appearance type: STRING mode: NULLABLE - description: |- - How the search result appeared (e.g. normal result, translated result, video). - This will be null when the source data wasn't exported directly to BigQuery by Google. + description: 'How the search result appeared (e.g. normal result, translated result, + video). + + This will be null when the source data wasn''t exported directly to BigQuery by + Google.' - name: user_country_code type: STRING mode: NULLABLE - description: |- - Country from which the user was searching, in ISO-3166-1-alpha-3 format. - This will be null for anonymized Discover impressions. + description: 'Country from which the user was searching, in ISO-3166-1-alpha-3 format. + + This will be null for anonymized Discover impressions.' - name: user_country type: STRING mode: NULLABLE - description: |- - Country from which the user was searching. - This will be null for anonymized Discover impressions. + description: 'Country from which the user was searching. + + This will be null for anonymized Discover impressions.' - name: user_region type: STRING mode: NULLABLE @@ -124,13 +132,15 @@ - name: device_type type: STRING mode: NULLABLE - description: |- - The type of device on which the user was searching: Desktop, Mobile, or Tablet. - This will be null for Discover impressions. + description: 'The type of device on which the user was searching: Desktop, Mobile, + or Tablet. + + This will be null for Discover impressions.' - name: impressions type: INTEGER mode: NULLABLE - description: The number of times that search results with a link to the page were shown to a user. + description: The number of times that search results with a link to the page were + shown to a user. - name: clicks type: INTEGER mode: NULLABLE @@ -138,6 +148,7 @@ - name: average_position type: FLOAT mode: NULLABLE - description: |- - The average position of the page in the search results, where `1` is the topmost position. - This will be null for Discover and Google News search impressions. + description: 'The average position of the page in the search results, where `1` + is the topmost position. + + This will be null for Discover and Google News search impressions.' diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_site/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_site/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_site/schema.yaml 2024-07-31 20:47:17.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_site/schema.yaml 2024-07-31 20:56:47.000000000 +0000 @@ -6,9 +6,10 @@ - name: site_url type: STRING mode: NULLABLE - description: |- - For domain properties, this will be `sc-domain:` followed by the domain name. - For URL-prefix properties, it will be the full URL of the property definition. + description: 'For domain properties, this will be `sc-domain:` followed by the domain + name. + + For URL-prefix properties, it will be the full URL of the property definition.' - name: site_domain_name type: STRING mode: NULLABLE @@ -20,27 +21,23 @@ - name: query_type type: STRING mode: NULLABLE - description: |- - Type of search query: - * Anonymized: Query was redacted by Google to protect the users' privacy. - * Brand: Query contained one or more Mozilla brand keywords. - * Non-Brand: Query didn't contain any Mozilla brand keywords. - * Unknown: Query couldn't be classified. + description: "Type of search query:\n * Anonymized: Query was redacted by Google\ + \ to protect the users' privacy.\n * Brand: Query contained one or more Mozilla\ + \ brand keywords.\n * Non-Brand: Query didn't contain any Mozilla brand keywords.\n\ + \ * Unknown: Query couldn't be classified." - name: is_anonymized type: BOOLEAN mode: NULLABLE - description: |- - Whether Google has anonymized the search impression to protect the users' privacy. - The `query` field will be null for anonymized search impressions. + description: 'Whether Google has anonymized the search impression to protect the + users'' privacy. + + The `query` field will be null for anonymized search impressions.' - name: search_type type: STRING mode: NULLABLE - description: |- - Where the link was seen by the user: - * Web: In Google Search's default "All" tab. - * Image: In Google Search's "Images" tab. - * Video: In Google Search's "Videos" tab. - * News: In Google Search's "News" tab. + description: "Where the link was seen by the user:\n * Web: In Google Search's\ + \ default \"All\" tab.\n * Image: In Google Search's \"Images\" tab.\n * Video:\ + \ In Google Search's \"Videos\" tab.\n * News: In Google Search's \"News\" tab." - name: user_country_code type: STRING mode: NULLABLE @@ -60,17 +57,20 @@ - name: device_type type: STRING mode: NULLABLE - description: |- - The type of device on which the user was searching: Desktop, Mobile, or Tablet. + description: 'The type of device on which the user was searching: Desktop, Mobile, + or Tablet.' - name: impressions type: INTEGER mode: NULLABLE - description: The number of times that search results with at least one link to the site were shown to a user. + description: The number of times that search results with at least one link to the + site were shown to a user. - name: clicks type: INTEGER mode: NULLABLE - description: The number of times a user clicked at least one search result link to the site. + description: The number of times a user clicked at least one search result link + to the site. - name: average_top_position type: FLOAT mode: NULLABLE - description: The average top position of the site in the search results, where `1` is the topmost position. + description: The average top position of the site in the search results, where `1` + is the topmost position. diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/event_monitoring_live_v1/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/event_monitoring_live_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/event_monitoring_live_v1/metadata.yaml 2024-07-31 20:48:27.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/event_monitoring_live_v1/metadata.yaml 2024-07-31 21:07:09.000000000 +0000 @@ -1,10 +1,19 @@ +friendly_name: Event Monitoring Live +description: |- + Materialized view of experimentation related events + coming from monitor_frontend. +owners: +- ascholtz@mozilla.com +- akomar@mozilla.com +labels: + materialized_view: true + owner1: ascholtz + owner2: akomar +bigquery: null workgroup_access: - role: roles/bigquery.dataViewer members: - workgroup:mozilla-confidential - - workgroup:dataops-managed/external-fides - -# Generated by bigquery_etl.dependency references: materialized_view.sql: - moz-fx-data-shared-prod.monitor_frontend_live.events_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/monitor_dashboard_user_journey_funnels_v1/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/monitor_dashboard_user_journey_funnels_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/monitor_dashboard_user_journey_funnels_v1/metadata.yaml 2024-07-31 20:48:27.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/monitor_dashboard_user_journey_funnels_v1/metadata.yaml 2024-07-31 21:07:09.000000000 +0000 @@ -1,10 +1,26 @@ +friendly_name: Monitor Dashboard User Journey Funnels +description: |- + Please provide a description for the query +owners: +- ksiegler@mozilla.org +labels: + incremental: true + dag: bqetl_generated_funnels + owner1: ksiegler +scheduling: + dag_name: bqetl_generated_funnels +bigquery: + time_partitioning: + type: day + field: submission_date + require_partition_filter: false + expiration_days: null + range_partitioning: null + clustering: null workgroup_access: - role: roles/bigquery.dataViewer members: - workgroup:mozilla-confidential - - workgroup:dataops-managed/external-fides - -# Generated by bigquery_etl.dependency references: query.sql: - mozdata.monitor_frontend.events_unnested diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/geckoview_version/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/geckoview_version/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/geckoview_version/schema.yaml 2024-07-31 20:47:17.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/geckoview_version/schema.yaml 2024-07-31 20:59:54.000000000 +0000 @@ -1,7 +1,13 @@ fields: -- type: DATETIME - name: build_hour -- type: INTEGER - name: geckoview_major_version -- type: INTEGER - name: n_pings +- name: build_hour + type: DATETIME + mode: NULLABLE + description: null +- name: geckoview_major_version + type: INTEGER + mode: NULLABLE + description: null +- name: n_pings + type: INTEGER + mode: NULLABLE + description: null diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/clients_last_seen/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/clients_last_seen/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/clients_last_seen/schema.yaml 2024-07-31 20:47:54.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/clients_last_seen/schema.yaml 2024-07-31 21:00:14.000000000 +0000 @@ -77,33 +77,44 @@ - name: submission_date type: DATE mode: NULLABLE + description: Submission Date - name: first_seen_date type: DATE mode: NULLABLE + description: First Seen Date - name: second_seen_date type: DATE mode: NULLABLE + description: Second Seen Date - name: days_seen_bits type: INTEGER mode: NULLABLE + description: Bit pattern to identify when the client_id has sent a main ping in + the previous 28 days. - name: days_visited_1_uri_bits type: INTEGER mode: NULLABLE + description: Days Visited 1 URI Bits - name: days_visited_5_uri_bits type: INTEGER mode: NULLABLE + description: Days Visited 5 URI Bits - name: days_visited_10_uri_bits type: INTEGER mode: NULLABLE + description: Days Visited 10 URI Bits - name: days_had_8_active_ticks_bits type: INTEGER mode: NULLABLE + description: Days Had 8 Active Ticks Bits - name: days_opened_dev_tools_bits type: INTEGER mode: NULLABLE + description: Days Opened Dev Tools Bits - name: days_interacted_bits type: INTEGER mode: NULLABLE + description: Days Interacted Bits - name: days_visited_1_uri_normal_mode_bits type: INTEGER mode: NULLABLE @@ -132,18 +143,23 @@ - name: client_id type: STRING mode: NULLABLE + description: Client ID - name: aborts_content_sum type: INTEGER mode: NULLABLE + description: Aborts Content Sum - name: aborts_gmplugin_sum type: INTEGER mode: NULLABLE + description: null - name: aborts_plugin_sum type: INTEGER mode: NULLABLE + description: Aborts Plugin Sum - name: active_addons_count_mean type: FLOAT mode: NULLABLE + description: Active Addons Count Mean - name: active_addons type: RECORD mode: REPEATED @@ -151,69 +167,92 @@ - name: addon_id type: STRING mode: NULLABLE + description: Add-On Identifier - name: blocklisted type: BOOLEAN mode: NULLABLE + description: Blocklisted - name: name type: STRING mode: NULLABLE + description: Name - name: user_disabled type: BOOLEAN mode: NULLABLE + description: User Disabled - name: app_disabled type: BOOLEAN mode: NULLABLE + description: App Disabled - name: version type: STRING mode: NULLABLE + description: Version - name: scope type: INTEGER mode: NULLABLE + description: Scope - name: type type: STRING mode: NULLABLE + description: Type - name: foreign_install type: BOOLEAN mode: NULLABLE + description: Foreign Install - name: has_binary_components type: BOOLEAN mode: NULLABLE + description: Has Binary Components - name: install_day type: INTEGER mode: NULLABLE + description: Install Day - name: update_day type: INTEGER mode: NULLABLE + description: Update Day - name: signed_state type: INTEGER mode: NULLABLE + description: Signed State - name: is_system type: BOOLEAN mode: NULLABLE + description: Is System - name: is_web_extension type: BOOLEAN mode: NULLABLE + description: Is Web Extension - name: multiprocess_compatible type: BOOLEAN mode: NULLABLE + description: Multiprocess Compatible + description: Active Addons - name: active_hours_sum type: FLOAT mode: NULLABLE + description: Active Hours Sum - name: addon_compatibility_check_enabled type: BOOLEAN mode: NULLABLE + description: Addon Compatibility Check Enabled - name: app_build_id type: STRING mode: NULLABLE + description: App Build ID - name: app_display_version type: STRING mode: NULLABLE + description: App Display Version - name: app_name type: STRING mode: NULLABLE + description: App Name - name: app_version type: STRING mode: NULLABLE + description: App Version - name: attribution type: RECORD mode: NULLABLE @@ -221,147 +260,196 @@ - name: source type: STRING mode: NULLABLE + description: Source - name: medium type: STRING mode: NULLABLE + description: Medium - name: campaign type: STRING mode: NULLABLE + description: Campaign - name: content type: STRING mode: NULLABLE + description: Content - name: experiment type: STRING mode: NULLABLE + description: Experiment - name: variation type: STRING mode: NULLABLE + description: Variation - name: dltoken type: STRING mode: NULLABLE + description: Download Token - name: dlsource type: STRING mode: NULLABLE + description: Download Source - name: ua type: STRING mode: NULLABLE + description: null + description: Attribution - name: blocklist_enabled type: BOOLEAN mode: NULLABLE + description: Blocklist Enabled - name: channel type: STRING mode: NULLABLE + description: Channel - name: client_clock_skew_mean type: FLOAT mode: NULLABLE + description: Client Clock Skew Mean - name: client_submission_latency_mean type: FLOAT mode: NULLABLE + description: Client Submission Latency Mean - name: cpu_cores type: INTEGER mode: NULLABLE + description: CPU Cores - name: cpu_count type: INTEGER mode: NULLABLE + description: CPU Count - name: cpu_family type: INTEGER mode: NULLABLE + description: CPU Family - name: cpu_l2_cache_kb type: INTEGER mode: NULLABLE + description: CPU L2 Cache KB - name: cpu_l3_cache_kb type: INTEGER mode: NULLABLE + description: CPU L3 Cache KB - name: cpu_model type: INTEGER mode: NULLABLE + description: CPU Model - name: cpu_speed_mhz type: INTEGER mode: NULLABLE + description: CPU Speed MHz - name: cpu_stepping type: INTEGER mode: NULLABLE + description: CPU Stepping - name: cpu_vendor type: STRING mode: NULLABLE + description: CPU Vendor - name: crashes_detected_content_sum type: INTEGER mode: NULLABLE + description: Crashes Detected Content Sum - name: crashes_detected_gmplugin_sum type: INTEGER mode: NULLABLE + description: null - name: crashes_detected_plugin_sum type: INTEGER mode: NULLABLE + description: Crashes Detected Plugin Sum - name: crash_submit_attempt_content_sum type: INTEGER mode: NULLABLE + description: Crash Submit Attempt Content Sum - name: crash_submit_attempt_main_sum type: INTEGER mode: NULLABLE + description: Crash Submit Attempt Main Sum - name: crash_submit_attempt_plugin_sum type: INTEGER mode: NULLABLE + description: Crash Submit Attempt Plugin Sum - name: crash_submit_success_content_sum type: INTEGER mode: NULLABLE + description: Crash Submit Success Content Sum - name: crash_submit_success_main_sum type: INTEGER mode: NULLABLE + description: Crash Submit Success Main Sum - name: crash_submit_success_plugin_sum type: INTEGER mode: NULLABLE + description: Crash Submit Success Plugin Sum - name: default_search_engine type: STRING mode: NULLABLE + description: Default Search Engine - name: default_search_engine_data_load_path type: STRING mode: NULLABLE + description: Default Search Engine Data Load Path - name: default_search_engine_data_name type: STRING mode: NULLABLE + description: Default Search Engine Data Name - name: default_search_engine_data_origin type: STRING mode: NULLABLE + description: Default Search Engine Data origin - name: default_search_engine_data_submission_url type: STRING mode: NULLABLE + description: Default Search Engine Data Submission URL - name: devtools_toolbox_opened_count_sum type: INTEGER mode: NULLABLE + description: Dev Tools Toolbox Opened Count Sum - name: distribution_id type: STRING mode: NULLABLE + description: Distribution ID - name: e10s_enabled type: BOOLEAN mode: NULLABLE + description: E10s Enabled - name: env_build_arch type: STRING mode: NULLABLE + description: Environment Build Arch - name: env_build_id type: STRING mode: NULLABLE + description: Environment Build ID - name: env_build_version type: STRING mode: NULLABLE + description: Environment Build Version - name: environment_settings_intl_accept_languages type: STRING mode: REPEATED + description: Environment Settings Intl Accept Languages - name: environment_settings_intl_app_locales type: STRING mode: REPEATED + description: Environment Settings Intl App Locales - name: environment_settings_intl_available_locales type: STRING mode: REPEATED + description: Environment Settings Intl Available Locales - name: environment_settings_intl_requested_locales type: STRING mode: REPEATED + description: Environment Settings Intl Requested Localed - name: environment_settings_intl_system_locales type: STRING mode: REPEATED + description: Environment Settings Intl System Locales - name: environment_settings_intl_regional_prefs_locales type: STRING mode: REPEATED + description: Environment Settings Intl Regional Prefs Locales - name: experiments type: RECORD mode: REPEATED @@ -369,264 +457,351 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: STRING mode: NULLABLE + description: Value + description: Experiments - name: first_paint_mean type: FLOAT mode: NULLABLE + description: First Paint Mean - name: flash_version type: STRING mode: NULLABLE + description: Flash Version - name: country type: STRING mode: NULLABLE + description: Country - name: city type: STRING mode: NULLABLE + description: City - name: geo_subdivision1 type: STRING mode: NULLABLE + description: Geo Subdivision 1 - name: geo_subdivision2 type: STRING mode: NULLABLE + description: Geo Subdivision 2 - name: isp_name type: STRING mode: NULLABLE + description: ISP Name - name: isp_organization type: STRING mode: NULLABLE + description: ISP Organization - name: gfx_features_advanced_layers_status type: STRING mode: NULLABLE + description: GFX Features Advanced Layers Status - name: gfx_features_d2d_status type: STRING mode: NULLABLE + description: GFX Features D2D Status - name: gfx_features_d3d11_status type: STRING mode: NULLABLE + description: GFX Features D3D11 Status - name: gfx_features_gpu_process_status type: STRING mode: NULLABLE + description: GFX Features GPU Process Status - name: histogram_parent_devtools_aboutdebugging_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools About Debugging Opened Count Sum - name: histogram_parent_devtools_animationinspector_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Animation Inspector Opened Count Sum - name: histogram_parent_devtools_browserconsole_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Browser Console Opened Count Sum - name: histogram_parent_devtools_canvasdebugger_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Canvas Debugger Opened Count Sum - name: histogram_parent_devtools_computedview_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Computed View Opened Count Sum - name: histogram_parent_devtools_custom_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Custom Opened Count Sum - name: histogram_parent_devtools_dom_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools DOM Opened Count Sum - name: histogram_parent_devtools_eyedropper_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Eyedropper Opened Count Sum - name: histogram_parent_devtools_fontinspector_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Font Inspector Opened Count Sum - name: histogram_parent_devtools_inspector_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Inspector Opened Count Sum - name: histogram_parent_devtools_jsbrowserdebugger_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools JS Browser Debugger Opened Count Sum - name: histogram_parent_devtools_jsdebugger_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Devtools JS Debugger Opened Count Sum - name: histogram_parent_devtools_jsprofiler_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools JS Profiler Opened Count Sum - name: histogram_parent_devtools_layoutview_opened_count_sum type: INTEGER mode: NULLABLE + description: null - name: histogram_parent_devtools_memory_opened_count_sum type: INTEGER mode: NULLABLE - name: histogram_parent_devtools_menu_eyedropper_opened_count_sum type: INTEGER mode: NULLABLE + description: null - name: histogram_parent_devtools_netmonitor_opened_count_sum type: INTEGER mode: NULLABLE + description: null - name: histogram_parent_devtools_options_opened_count_sum type: INTEGER mode: NULLABLE + description: null - name: histogram_parent_devtools_paintflashing_opened_count_sum type: INTEGER mode: NULLABLE + description: null - name: histogram_parent_devtools_picker_eyedropper_opened_count_sum type: INTEGER mode: NULLABLE + description: null - name: histogram_parent_devtools_responsive_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Responsive Opened Count Sum - name: histogram_parent_devtools_ruleview_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Rule View Opened Count Sum - name: histogram_parent_devtools_scratchpad_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Scratchpad Opened Count Sum - name: histogram_parent_devtools_scratchpad_window_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Scratchpad Window Opened Count Sum - name: histogram_parent_devtools_shadereditor_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Shader Editor Opened Count Sum - name: histogram_parent_devtools_storage_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Storage Opened Count Sum - name: histogram_parent_devtools_styleeditor_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Style Editor Opened Count Sum - name: histogram_parent_devtools_webaudioeditor_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Web Audio Editor Opened Count Sum - name: histogram_parent_devtools_webconsole_opened_count_sum type: INTEGER mode: NULLABLE + description: null - name: histogram_parent_devtools_webide_opened_count_sum type: INTEGER mode: NULLABLE + description: Histogram Parent Dev Tools Web IDE Opened Count Sum - name: install_year type: INTEGER mode: NULLABLE + description: Install Year - name: is_default_browser type: BOOLEAN mode: NULLABLE + description: Is Default Browser Indicator - name: is_wow64 type: BOOLEAN mode: NULLABLE + description: WoW64 Indicator - name: locale type: STRING mode: NULLABLE + description: Locale - name: memory_mb type: INTEGER mode: NULLABLE + description: Memory (MB) - name: normalized_channel type: STRING mode: NULLABLE + description: Normalized Channel - name: normalized_os_version type: STRING mode: NULLABLE + description: Normalized OS Version - name: os type: STRING mode: NULLABLE + description: Operating System - name: os_service_pack_major type: INTEGER mode: NULLABLE + description: OS Service Pack Major - name: os_service_pack_minor type: INTEGER mode: NULLABLE + description: OS Service Pack Minor - name: os_version type: STRING mode: NULLABLE + description: Operating System Version - name: pings_aggregated_by_this_row type: INTEGER mode: NULLABLE + description: Pings Aggregated By This Row - name: places_bookmarks_count_mean type: FLOAT mode: NULLABLE + description: Places Bookmarks Count Mean - name: places_pages_count_mean type: FLOAT mode: NULLABLE + description: Places Pages Count Mean - name: plugin_hangs_sum type: INTEGER mode: NULLABLE + description: Plugin Hangs Sum - name: plugins_infobar_allow_sum type: INTEGER mode: NULLABLE + description: Plugins Infobar Allow Sum - name: plugins_infobar_block_sum type: INTEGER mode: NULLABLE + description: Plugins Infobar Block Sum - name: plugins_infobar_shown_sum type: INTEGER mode: NULLABLE + description: Plugins Infobar Shown Sum - name: plugins_notification_shown_sum type: INTEGER mode: NULLABLE + description: Plugins Notifications Shown Sum - name: previous_build_id type: STRING mode: NULLABLE + description: Previous Build ID - name: profile_age_in_days type: INTEGER mode: NULLABLE + description: Profile Age in Days - name: profile_creation_date type: STRING mode: NULLABLE + description: Profile Creation Date - name: push_api_notify_sum type: INTEGER mode: NULLABLE + description: Push API Notify Sum - name: sample_id type: INTEGER mode: NULLABLE + description: Sample ID - name: sandbox_effective_content_process_level type: INTEGER mode: NULLABLE + description: Sandbox Effective Content Process Level - name: scalar_combined_webrtc_nicer_stun_retransmits_sum type: INTEGER mode: NULLABLE + description: Scalar Combined WebRTC Nicer Stun Retransmits Sum - name: scalar_combined_webrtc_nicer_turn_401s_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_combined_webrtc_nicer_turn_403s_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_combined_webrtc_nicer_turn_438s_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_content_navigator_storage_estimate_count_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_content_navigator_storage_persist_count_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_aushelper_websense_reg_version type: STRING mode: NULLABLE + description: null - name: scalar_parent_browser_engagement_max_concurrent_tab_count_max type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_browser_engagement_max_concurrent_window_count_max type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_browser_engagement_tab_open_event_count_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_browser_engagement_total_uri_count_sum type: INTEGER mode: NULLABLE + description: Scalar Parent Browser Engagement Total URI Count Sum - name: scalar_parent_browser_engagement_unfiltered_uri_count_sum type: INTEGER mode: NULLABLE + description: Scalar Parent Browser Engagement Unfiltered URI Count Sum - name: scalar_parent_browser_engagement_unique_domains_count_max type: INTEGER mode: NULLABLE + description: Scalar Parent Browser Engagement Unique Domains Count Max - name: scalar_parent_browser_engagement_unique_domains_count_mean type: FLOAT mode: NULLABLE + description: Scalar Parent Browser Engagement Unique Domains Count Mean - name: scalar_parent_browser_engagement_window_open_event_count_sum type: INTEGER mode: NULLABLE + description: Scalar Parent Browser Engagement Window Open Event Count Sum - name: scalar_parent_devtools_accessibility_node_inspected_count_sum type: INTEGER mode: NULLABLE + description: Scalar Parent Dev Tools Accessibility Mode Inspected Count Sum - name: scalar_parent_devtools_accessibility_opened_count_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_devtools_accessibility_picker_used_count_sum type: INTEGER mode: NULLABLE + description: Scalar Parent Dev Tools Accessibility Picker Used Count Sum - name: scalar_parent_devtools_accessibility_select_accessible_for_node_sum type: RECORD mode: REPEATED @@ -634,159 +809,211 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value - name: scalar_parent_devtools_accessibility_service_enabled_count_sum type: INTEGER mode: NULLABLE + description: Scalar Parent Devtools Accessibility Service Enabled Count Sum - name: scalar_parent_devtools_copy_full_css_selector_opened_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_devtools_copy_unique_css_selector_opened_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_devtools_toolbar_eyedropper_opened_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_navigator_storage_estimate_count_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_navigator_storage_persist_count_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_storage_sync_api_usage_extensions_using_sum type: INTEGER mode: NULLABLE + description: null - name: search_cohort type: STRING mode: NULLABLE + description: Search Cohort - name: search_count_abouthome type: INTEGER mode: NULLABLE + description: Search Count About Home - name: search_count_contextmenu type: INTEGER mode: NULLABLE + description: Search Count Context Menu - name: search_count_newtab type: INTEGER mode: NULLABLE + description: Search Count New Tab - name: search_count_searchbar type: INTEGER mode: NULLABLE + description: Search Count Search Bar - name: search_count_system type: INTEGER mode: NULLABLE + description: Search Count System - name: search_count_urlbar type: INTEGER mode: NULLABLE + description: Search Count URL Bar - name: search_count_all type: INTEGER mode: NULLABLE + description: Search Count All - name: search_count_tagged_sap type: INTEGER mode: NULLABLE + description: null - name: search_count_tagged_follow_on type: INTEGER mode: NULLABLE + description: null - name: search_count_organic type: INTEGER mode: NULLABLE + description: Search Count - Organic - name: search_count_urlbar_handoff type: INTEGER mode: NULLABLE + description: null - name: session_restored_mean type: FLOAT mode: NULLABLE + description: Session Restored Mean - name: sessions_started_on_this_day type: INTEGER mode: NULLABLE + description: Sessions Started On This Day - name: shutdown_kill_sum type: INTEGER mode: NULLABLE + description: Shutdown Kill Sum - name: subsession_hours_sum type: NUMERIC mode: NULLABLE + description: Subsession Hours Sum - name: ssl_handshake_result_failure_sum type: INTEGER mode: NULLABLE + description: SSL Handshake Result Failure Sum - name: ssl_handshake_result_success_sum type: INTEGER mode: NULLABLE + description: SSL Handshake Result Success Sum - name: sync_configured type: BOOLEAN mode: NULLABLE + description: Sync Configured Indicator - name: sync_count_desktop_mean type: FLOAT mode: NULLABLE + description: Sync Count Desktop Mean - name: sync_count_mobile_mean type: FLOAT mode: NULLABLE + description: Sync Count Mobile Mean - name: sync_count_desktop_sum type: INTEGER mode: NULLABLE + description: Sync Count Desktop Sum - name: sync_count_mobile_sum type: INTEGER mode: NULLABLE + description: Sync Count Mobile Sum - name: telemetry_enabled type: BOOLEAN mode: NULLABLE + description: Telemetry Enabled Indicator - name: timezone_offset type: INTEGER mode: NULLABLE + description: Timezone Offset - name: update_auto_download type: BOOLEAN mode: NULLABLE + description: Update Auto Download - name: update_channel type: STRING mode: NULLABLE + description: Update Channel - name: update_enabled type: BOOLEAN mode: NULLABLE + description: Update Enabled - name: vendor type: STRING mode: NULLABLE + description: Vendor - name: web_notification_shown_sum type: INTEGER mode: NULLABLE + description: Web Notification Shown Sum - name: windows_build_number type: INTEGER mode: NULLABLE + description: Windows Build Number - name: windows_ubr type: INTEGER mode: NULLABLE + description: Windows UBR - name: fxa_configured type: BOOLEAN mode: NULLABLE + description: FXA Configured - name: trackers_blocked_sum type: INTEGER mode: NULLABLE + description: Trackers Blocked Sum - name: submission_timestamp_min type: TIMESTAMP mode: NULLABLE + description: Minimum Submission Timestamp - name: ad_clicks_count_all type: INTEGER mode: NULLABLE + description: Ad Clicks Count All - name: search_with_ads_count_all type: INTEGER mode: NULLABLE + description: Search with Ads Count All - name: scalar_parent_urlbar_impression_autofill_about_sum type: INTEGER mode: NULLABLE + description: Scalar Parent URL Bar Impression Autofill About Sum - name: scalar_parent_urlbar_impression_autofill_adaptive_sum type: INTEGER mode: NULLABLE + description: Scalar Parent URL Bar Impression Autofill Adaptive Sum - name: scalar_parent_urlbar_impression_autofill_origin_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_urlbar_impression_autofill_other_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_urlbar_impression_autofill_preloaded_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_urlbar_impression_autofill_url_sum type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_telemetry_event_counts_sum type: RECORD mode: REPEATED @@ -794,9 +1021,12 @@ - name: key type: STRING mode: NULLABLE + description: null - name: value type: INTEGER mode: NULLABLE + description: null + description: Scalar Parent Telemetry Event Counts Sum - name: scalar_content_telemetry_event_counts_sum type: RECORD mode: REPEATED @@ -807,6 +1037,7 @@ - name: value type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_urlbar_searchmode_bookmarkmenu_sum type: RECORD mode: REPEATED @@ -814,9 +1045,12 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value + description: null - name: scalar_parent_urlbar_searchmode_handoff_sum type: RECORD mode: REPEATED @@ -824,9 +1058,12 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value + description: Scalar Parent URL Bar Search Mode Handoff Sum - name: scalar_parent_urlbar_searchmode_keywordoffer_sum type: RECORD mode: REPEATED @@ -834,9 +1071,12 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value + description: Scalar Parent URL Bar Search Mode Keyword Offer Sum - name: scalar_parent_urlbar_searchmode_oneoff_sum type: RECORD mode: REPEATED @@ -844,9 +1084,12 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value + description: Scalar Parent URL Bar Search Mode One-off Sum - name: scalar_parent_urlbar_searchmode_other_sum type: RECORD mode: REPEATED @@ -854,9 +1097,12 @@ - name: key type: STRING mode: NULLABLE + description: null - name: value type: INTEGER mode: NULLABLE + description: null + description: Scalar Parent URL Bar Search Mode Other Sum - name: scalar_parent_urlbar_searchmode_shortcut_sum type: RECORD mode: REPEATED @@ -864,9 +1110,11 @@ - name: key type: STRING mode: NULLABLE + description: null - name: value type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_urlbar_searchmode_tabmenu_sum type: RECORD mode: REPEATED @@ -874,9 +1122,12 @@ - name: key type: STRING mode: NULLABLE + description: null - name: value type: INTEGER mode: NULLABLE + description: null + description: Scalar Parent URL Bar Search Mode Tab Menu Sum - name: scalar_parent_urlbar_searchmode_tabtosearch_sum type: RECORD mode: REPEATED @@ -884,9 +1135,12 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value + description: Scalar Parent URL Bar Search Mode Tab to Search Sum - name: scalar_parent_urlbar_searchmode_tabtosearch_onboard_sum type: RECORD mode: REPEATED @@ -894,9 +1148,12 @@ - name: key type: STRING mode: NULLABLE + description: null - name: value type: INTEGER mode: NULLABLE + description: null + description: Scalar Parent URL Bar Search Mode Tab to Search Onboard Sum - name: scalar_parent_urlbar_searchmode_topsites_newtab_sum type: RECORD mode: REPEATED @@ -904,9 +1161,11 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value - name: scalar_parent_urlbar_searchmode_topsites_urlbar_sum type: RECORD mode: REPEATED @@ -914,9 +1173,11 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value - name: scalar_parent_urlbar_searchmode_touchbar_sum type: RECORD mode: REPEATED @@ -924,9 +1185,11 @@ - name: key type: STRING mode: NULLABLE + description: null - name: value type: INTEGER mode: NULLABLE + description: null - name: scalar_parent_urlbar_searchmode_typed_sum type: RECORD mode: REPEATED @@ -934,36 +1197,47 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value - name: scalar_parent_os_environment_is_taskbar_pinned type: BOOLEAN mode: NULLABLE + description: Scalar Parent OS Environment Is Taskbar Pinned - name: scalar_parent_os_environment_launched_via_desktop type: BOOLEAN mode: NULLABLE + description: Scalar Parent OS Environment Launched Via Desktop - name: scalar_parent_os_environment_launched_via_start_menu type: BOOLEAN mode: NULLABLE + description: Scalar Parent OS Environment Launched Via Start Menu - name: scalar_parent_os_environment_launched_via_taskbar type: BOOLEAN mode: NULLABLE + description: Scalar Parent OS Environment Launched via Task Bar - name: scalar_parent_os_environment_launched_via_other_shortcut type: BOOLEAN mode: NULLABLE + description: Scalar Parent OS Environment Launched Via Other Shortcut - name: scalar_parent_os_environment_launched_via_other type: BOOLEAN mode: NULLABLE + description: Scalar Parent OS Environment Launched Via Other - name: search_count_webextension type: INTEGER mode: NULLABLE + description: Search Count Web Extension - name: search_count_alias type: INTEGER mode: NULLABLE + description: Search Count Alias - name: search_count_urlbar_searchmode type: INTEGER mode: NULLABLE + description: Search Count URL Bar Search Mode - name: scalar_parent_browser_ui_interaction_preferences_pane_home_sum type: RECORD mode: REPEATED @@ -971,9 +1245,11 @@ - name: key type: STRING mode: NULLABLE + description: Key - name: value type: INTEGER mode: NULLABLE + description: Value - name: scalar_parent_urlbar_picked_autofill_sum type: RECORD mode: REPEATED @@ -1194,21 +1470,27 @@ - name: value type: INTEGER mode: NULLABLE + description: Scalar Parent URL Bar Picked Visit URL Sum - name: default_private_search_engine type: STRING mode: NULLABLE + description: Default Private Search Engine - name: default_private_search_engine_data_load_path type: STRING mode: NULLABLE + description: Default Private Search Engine Data Load Path - name: default_private_search_engine_data_name type: STRING mode: NULLABLE + description: Default Private Search Engine Data Name - name: default_private_search_engine_data_origin type: STRING mode: NULLABLE + description: Default Private Search Engine Data Origin - name: default_private_search_engine_data_submission_url type: STRING mode: NULLABLE + description: Default Private Search Engine Data Submission URL - name: search_counts type: RECORD mode: REPEATED @@ -1216,15 +1498,20 @@ - name: engine type: STRING mode: NULLABLE + description: Engine - name: source type: STRING mode: NULLABLE + description: Source - name: count type: INTEGER mode: NULLABLE + description: Count + description: Search Counts - name: user_pref_browser_search_region type: STRING mode: NULLABLE + description: User Preferences Browser Search Region - name: search_with_ads type: RECORD mode: REPEATED @@ -1232,9 +1519,12 @@ - name: key type: STRING mode: NULLABLE + description: null - name: value type: INTEGER mode: NULLABLE + description: null + description: Search with Ads - name: ad_clicks type: RECORD mode: REPEATED @@ -1305,6 +1595,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Content About New Tab Sum - name: search_content_searchbar_sum type: RECORD mode: REPEATED @@ -1315,6 +1606,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Content Search Bar Sum - name: search_content_system_sum type: RECORD mode: REPEATED @@ -1325,6 +1617,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Content System Sum - name: search_content_webextension_sum type: RECORD mode: REPEATED @@ -1335,6 +1628,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Content Web Extension Sum - name: search_content_tabhistory_sum type: RECORD mode: REPEATED @@ -1345,6 +1639,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Content Tab History Sum - name: search_content_reload_sum type: RECORD mode: REPEATED @@ -1355,6 +1650,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Content Reload Sum - name: search_content_unknown_sum type: RECORD mode: REPEATED @@ -1365,6 +1661,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Content Unknown Sum - name: search_withads_urlbar_sum type: RECORD mode: REPEATED @@ -1375,6 +1672,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads URL Bar Sum - name: search_withads_urlbar_handoff_sum type: RECORD mode: REPEATED @@ -1385,6 +1683,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads URL Bar Handoff Sum - name: search_withads_urlbar_searchmode_sum type: RECORD mode: REPEATED @@ -1405,6 +1704,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads Context Menu Sum - name: search_withads_about_home_sum type: RECORD mode: REPEATED @@ -1415,6 +1715,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads About Home Sum - name: search_withads_about_newtab_sum type: RECORD mode: REPEATED @@ -1425,6 +1726,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads About New Tab Sum - name: search_withads_searchbar_sum type: RECORD mode: REPEATED @@ -1435,6 +1737,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads Search Bar Sum - name: search_withads_system_sum type: RECORD mode: REPEATED @@ -1445,6 +1748,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads System Sum - name: search_withads_webextension_sum type: RECORD mode: REPEATED @@ -1455,6 +1759,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads Web Extension Sum - name: search_withads_tabhistory_sum type: RECORD mode: REPEATED @@ -1465,6 +1770,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search With Ads Tab History Sum - name: search_withads_reload_sum type: RECORD mode: REPEATED @@ -1545,6 +1851,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Ad Clicks About New Tab Sum - name: search_adclicks_searchbar_sum type: RECORD mode: REPEATED @@ -1555,6 +1862,7 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Ad Clicks Search Bar Sum - name: search_adclicks_system_sum type: RECORD mode: REPEATED @@ -1605,39 +1913,50 @@ - name: value type: INTEGER mode: NULLABLE + description: Search Ad Clicks Unknown Sum - name: update_background type: BOOLEAN mode: NULLABLE - name: user_pref_browser_search_suggest_enabled type: STRING mode: NULLABLE + description: User Preferences Browser Search Suggest Enabled - name: user_pref_browser_widget_in_navbar type: STRING mode: NULLABLE + description: User Preferences Browser Widget in Navigation Bar - name: user_pref_browser_urlbar_suggest_searches type: STRING mode: NULLABLE + description: User Preferences Browser URL Bar Suggest Searches - name: user_pref_browser_urlbar_show_search_suggestions_first type: STRING mode: NULLABLE + description: null - name: user_pref_browser_urlbar_suggest_quicksuggest type: STRING mode: NULLABLE + description: null - name: user_pref_browser_urlbar_suggest_quicksuggest_sponsored type: STRING mode: NULLABLE + description: null - name: user_pref_browser_urlbar_quicksuggest_onboarding_dialog_choice type: STRING mode: NULLABLE + description: null - name: scalar_parent_browser_engagement_total_uri_count_normal_and_private_mode_sum type: INTEGER mode: NULLABLE + description: null - name: user_pref_browser_newtabpage_enabled type: STRING mode: NULLABLE + description: User Preferences Browser New Tab Page Enabled - name: user_pref_app_shield_optoutstudies_enabled type: STRING mode: ```⚠️ Only part of the diff is displayed.
┆Issue is synchronized with this Jira Task