[Bug 1904423] Support ohttp for generated app views

scholtzan commented 3 months ago

https://bugzilla.mozilla.org/show_bug.cgi?id=1904423

Some new pings that don't have client_info fields got added for Fenix. The generation template references client_info to get the channel. This PR should avoid referencing the field for affected pings

Checklist for reviewer:

[ ] Commits should reference a bug or github issue, if relevant (if a bug is referenced, the pull request should include the bug number in the title).
[ ] If the PR comes from a fork, trigger integration CI tests by running the Push to upstream workflow and provide the <username>:<branch> of the fork as parameter. The parameter will also show up in the logs of the manual-trigger-required-for-fork CI task together with more detailed instructions.
[ ] If adding a new field to a query, ensure that the schema and dependent downstream schemas have been updated.
[ ] When adding a new derived dataset, ensure that data is not available already (fully or partially) and recommend extending an existing dataset in favor of creating new ones. Data can be available in the bigquery-etl repository, looker-hub or in looker-spoke-default.

For modifications to schemas in restricted namespaces (see CODEOWNERS):

[ ] Follow the change control procedure

┆Issue is synchronized with this Jira Task

dataops-ci-bot commented 3 months ago

Integration report for "Update sql_generators/glean_usage/templates/app_ping_view.view.sql"

`sql.diff`

Click to expand!

```diff 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-06-24 20:01:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml 2024-06-24 20:09:49.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-06-24 20:01:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml 2024-06-24 20:09:48.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/bounce_tracking_protection/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/view.sql 2024-06-24 20:01:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/view.sql 2024-06-24 20:06:00.000000000 +0000 @@ -4,10 +4,9 @@ AS SELECT "org_mozilla_firefox" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_firefox", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- app build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_firefox", 21850000).channel AS normalized_channel, additional_properties, document_id, events, @@ -32,10 +31,9 @@ UNION ALL SELECT "org_mozilla_firefox_beta" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_firefox_beta", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- app build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_firefox_beta", 21850000).channel AS normalized_channel, additional_properties, document_id, events, @@ -60,10 +58,9 @@ UNION ALL SELECT "org_mozilla_fenix" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_fenix", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- app build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_fenix", 21850000).channel AS normalized_channel, additional_properties, document_id, events, @@ -88,10 +85,9 @@ UNION ALL SELECT "org_mozilla_fenix_nightly" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_fenix_nightly", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- app build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_fenix_nightly", 21850000).channel AS normalized_channel, additional_properties, document_id, events, @@ -116,10 +112,9 @@ UNION ALL SELECT "org_mozilla_fennec_aurora" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_fennec_aurora", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- app build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_fennec_aurora", 21850000).channel AS normalized_channel, additional_properties, document_id, events, 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-06-24 20:01:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml 2024-06-24 20:11:26.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-06-24 20:01:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml 2024-06-24 20:11:27.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/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-06-24 20:01:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_page/schema.yaml 2024-06-24 20:09:52.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-06-24 20:01:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_site/schema.yaml 2024-06-24 20:09:51.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/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-06-24 20:01:11.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/geckoview_version/schema.yaml 2024-06-24 20:10:01.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/org_mozilla_fenix/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/metrics/schema.yaml 2024-06-24 20:01:46.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/metrics/schema.yaml 2024-06-24 20:03:11.000000000 +0000 @@ -1880,7 +1880,8 @@ - name: value type: INTEGER mode: NULLABLE - description: 'Failure occurs when initializing the audio stream. + description: 'Failure occurs when initializing the audio stream. (Migrated from + the geckoview metric of the same name). ' - name: glean_validation_pings_submitted diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml 2024-06-24 20:01:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml 2024-06-24 20:03:15.000000000 +0000 @@ -3265,7 +3265,8 @@ - name: value type: INTEGER mode: NULLABLE - description: 'Failure occurs when initializing the audio stream. + description: 'Failure occurs when initializing the audio stream. (Migrated from + the geckoview metric of the same name). ' - name: glean_validation_pings_submitted diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml 2024-06-24 20:01:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml 2024-06-24 20:03:11.000000000 +0000 @@ -3265,7 +3265,8 @@ - name: value type: INTEGER mode: NULLABLE - description: 'Failure occurs when initializing the audio stream. + description: 'Failure occurs when initializing the audio stream. (Migrated from + the geckoview metric of the same name). ' - name: glean_validation_pings_submitted diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/eng_workflow_build_parquet/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/eng_workflow_build_parquet/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry/eng_workflow_build_parquet/schema.yaml 2024-06-24 20:01:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/eng_workflow_build_parquet/schema.yaml 2024-06-24 20:10:11.000000000 +0000 @@ -28,48 +28,36 @@ - name: artifact type: BOOLEAN mode: NULLABLE - description: true if --enable-artifact-builds - name: ccache type: BOOLEAN mode: NULLABLE - description: true if ccache is in use (--with-ccache) - name: compiler type: STRING mode: NULLABLE - description: The compiler type in use (CC_TYPE) - name: debug type: BOOLEAN mode: NULLABLE - description: true if build is debug (--enable-debug) - name: icecream type: BOOLEAN mode: NULLABLE - description: true if icecream in use - name: opt type: BOOLEAN mode: NULLABLE - description: true if build is optimized (--enable-optimize) - name: sccache type: BOOLEAN mode: NULLABLE - description: true if ccache in use is sccache - description: Selected build options - name: client_id type: STRING mode: NULLABLE - description: A UUID to uniquely identify a client - name: command type: STRING mode: NULLABLE - description: The mach command that was invoked - name: duration_ms type: FLOAT mode: NULLABLE - description: Command duration in milliseconds - name: success type: BOOLEAN mode: NULLABLE - description: true if the command succeeded - name: system type: RECORD mode: NULLABLE @@ -77,40 +65,30 @@ - name: os type: STRING mode: NULLABLE - description: Operating system - name: cpu_brand type: STRING mode: NULLABLE - description: CPU brand string from CPUID - name: drive_is_ssd type: BOOLEAN mode: NULLABLE - description: true if the source directory is on a solid-state disk - name: logical_cores type: INTEGER mode: NULLABLE - description: Number of logical CPU cores present - name: memory_gb type: INTEGER mode: NULLABLE - description: System memory in GB - name: physical_cores type: INTEGER mode: NULLABLE - description: Number of physical CPU cores present - name: virtual_machine type: BOOLEAN mode: NULLABLE - description: true if the OS appears to be running in a virtual machine - name: time type: STRING mode: NULLABLE - description: Time at which this event happened - name: exception type: STRING mode: NULLABLE - description: If a Python exception was encountered during the execution of the command, - this value contains the result of calling `repr` on the exception object. - name: file_types_changed type: RECORD mode: REPEATED @@ -118,11 +96,9 @@ - name: count type: INTEGER mode: NULLABLE - description: Count of changed files with this extension - name: ext type: STRING mode: NULLABLE - description: File extension - name: build_attrs type: RECORD mode: NULLABLE @@ -130,9 +106,6 @@ - name: clobber type: BOOLEAN mode: NULLABLE - description: true if the build was a clobber/full build - name: cpu_percent type: FLOAT mode: NULLABLE - description: cpu utilization observed during a build - description: Attributes characterizing a build ```

Link to full diff

dataops-ci-bot commented 3 months ago

Integration report for "[Bug 1904423] Support ohttp for generated app views"

`sql.diff`

Click to expand!

```diff 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-06-24 20:31:16.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml 2024-06-24 20:43:07.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-06-24 20:31:16.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml 2024-06-24 20:43:06.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/bounce_tracking_protection/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/schema.yaml 2024-06-24 20:31:53.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/schema.yaml 2024-06-24 20:40:55.000000000 +0000 @@ -1,11 +1,11 @@ fields: - name: normalized_app_id - mode: NULLABLE type: STRING + mode: NULLABLE description: App ID of the channel data was received from - name: normalized_channel - mode: NULLABLE type: STRING + mode: NULLABLE 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/fenix/bounce_tracking_protection/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/view.sql 2024-06-24 20:31:53.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/bounce_tracking_protection/view.sql 2024-06-24 20:36:06.000000000 +0000 @@ -4,10 +4,9 @@ AS SELECT "org_mozilla_firefox" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_firefox", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- abb build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_firefox", '21850000').channel AS normalized_channel, additional_properties, document_id, events, @@ -32,10 +31,9 @@ UNION ALL SELECT "org_mozilla_firefox_beta" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_firefox_beta", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- abb build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_firefox_beta", '21850000').channel AS normalized_channel, additional_properties, document_id, events, @@ -60,10 +58,9 @@ UNION ALL SELECT "org_mozilla_fenix" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_fenix", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- abb build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_fenix", '21850000').channel AS normalized_channel, additional_properties, document_id, events, @@ -88,10 +85,9 @@ UNION ALL SELECT "org_mozilla_fenix_nightly" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_fenix_nightly", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- abb build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_fenix_nightly", '21850000').channel AS normalized_channel, additional_properties, document_id, events, @@ -116,10 +112,9 @@ UNION ALL SELECT "org_mozilla_fennec_aurora" AS normalized_app_id, - mozfun.norm.fenix_app_info( - "org_mozilla_fennec_aurora", - client_info.app_build - ).channel AS normalized_channel, + -- set app build to 21850000 since all affected pings are coming from versions older than that + -- abb build only used to differentiate between preview (pre 21850000) and nightly (everything after) + mozfun.norm.fenix_app_info("org_mozilla_fennec_aurora", '21850000').channel AS normalized_channel, additional_properties, document_id, events, 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-06-24 20:31:16.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml 2024-06-24 20:40:53.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-06-24 20:31:16.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml 2024-06-24 20:40:54.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/fenix/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/use_counters/schema.yaml 2024-06-24 20:31:53.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/use_counters/schema.yaml 2024-06-24 20:42:55.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/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-06-24 20:31:53.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android/use_counters/schema.yaml 2024-06-24 20:48:04.000000000 +0000 @@ -1,11 +1,11 @@ fields: - name: normalized_app_id - mode: NULLABLE type: STRING + mode: NULLABLE description: App ID of the channel data was received from - name: normalized_channel - mode: NULLABLE type: STRING + mode: NULLABLE 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-06-24 20:31:16.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_page/schema.yaml 2024-06-24 20:43:09.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-06-24 20:31:16.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/google_search_console/search_impressions_by_site/schema.yaml 2024-06-24 20:43:09.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/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-06-24 20:31:16.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/geckoview_version/schema.yaml 2024-06-24 20:43:19.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/org_mozilla_fenix/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/metrics/schema.yaml 2024-06-24 20:31:53.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/metrics/schema.yaml 2024-06-24 20:33:31.000000000 +0000 @@ -1880,7 +1880,8 @@ - name: value type: INTEGER mode: NULLABLE - description: 'Failure occurs when initializing the audio stream. + description: 'Failure occurs when initializing the audio stream. (Migrated from + the geckoview metric of the same name). ' - name: glean_validation_pings_submitted diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml 2024-06-24 20:31:53.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml 2024-06-24 20:33:37.000000000 +0000 @@ -3265,7 +3265,8 @@ - name: value type: INTEGER mode: NULLABLE - description: 'Failure occurs when initializing the audio stream. + description: 'Failure occurs when initializing the audio stream. (Migrated from + the geckoview metric of the same name). ' - name: glean_validation_pings_submitted diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml 2024-06-24 20:31:53.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml 2024-06-24 20:33:31.000000000 +0000 @@ -3265,7 +3265,8 @@ - name: value type: INTEGER mode: NULLABLE - description: 'Failure occurs when initializing the audio stream. + description: 'Failure occurs when initializing the audio stream. (Migrated from + the geckoview metric of the same name). ' - name: glean_validation_pings_submitted 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-06-24 20:31:53.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry/clients_last_seen/schema.yaml 2024-06-24 20:43:38.000000000 +0000 @@ -77,44 +77,33 @@ - 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 @@ -143,23 +132,18 @@ - 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 @@ -167,92 +151,69 @@ - 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 @@ -260,196 +221,147 @@ - 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 @@ -457,351 +369,264 @@ - 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 @@ -809,211 +634,159 @@ - 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 @@ -1021,12 +794,9 @@ - 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 @@ -1037,7 +807,6 @@ - name: value type: INTEGER mode: NULLABLE - description: null - name: scalar_parent_urlbar_searchmode_bookmarkmenu_sum type: RECORD mode: REPEATED @@ -1045,12 +814,9 @@ - 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 @@ -1058,12 +824,9 @@ - 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 @@ -1071,12 +834,9 @@ - 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 @@ -1084,12 +844,9 @@ - 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 @@ -1097,12 +854,9 @@ - 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 @@ -1110,11 +864,9 @@ - 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 @@ -1122,12 +874,9 @@ - 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 @@ -1135,12 +884,9 @@ - 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 @@ -1148,12 +894,9 @@ - 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 @@ -1161,11 +904,9 @@ - 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 @@ -1173,11 +914,9 @@ - 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 @@ -1185,11 +924,9 @@ - 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 @@ -1197,47 +934,36 @@ - 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 @@ -1245,11 +971,9 @@ - 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 @@ -1470,27 +1194,21 @@ - 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 @@ -1498,20 +1216,15 @@ - 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 @@ -1519,12 +1232,9 @@ - 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 @@ -1595,7 +1305,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search Content About New Tab Sum - name: search_content_searchbar_sum type: RECORD mode: REPEATED @@ -1606,7 +1315,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search Content Search Bar Sum - name: search_content_system_sum type: RECORD mode: REPEATED @@ -1617,7 +1325,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search Content System Sum - name: search_content_webextension_sum type: RECORD mode: REPEATED @@ -1628,7 +1335,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search Content Web Extension Sum - name: search_content_tabhistory_sum type: RECORD mode: REPEATED @@ -1639,7 +1345,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search Content Tab History Sum - name: search_content_reload_sum type: RECORD mode: REPEATED @@ -1650,7 +1355,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search Content Reload Sum - name: search_content_unknown_sum type: RECORD mode: REPEATED @@ -1661,7 +1365,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search Content Unknown Sum - name: search_withads_urlbar_sum type: RECORD mode: REPEATED @@ -1672,7 +1375,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search With Ads URL Bar Sum - name: search_withads_urlbar_handoff_sum type: RECORD mode: REPEATED @@ -1683,7 +1385,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search With Ads URL Bar Handoff Sum - name: search_withads_urlbar_searchmode_sum type: RECORD mode: REPEATED @@ -1704,7 +1405,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search With Ads Context Menu Sum - name: search_withads_about_home_sum type: RECORD mode: REPEATED @@ -1715,7 +1415,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search With Ads About Home Sum - name: search_withads_about_newtab_sum type: RECORD mode: REPEATED @@ -1726,7 +1425,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search With Ads About New Tab Sum - name: search_withads_searchbar_sum type: RECORD mode: REPEATED @@ -1737,7 +1435,6 @@ - name: value type: INTEGER mode: NULLABLE - description: Search With Ads Search Bar Sum - name: search_withads_system_sum type: RECORD mode: REPEATED @@ -1748,7 +1445,6 @@ - name: value type: INTEGER ```

⚠️ Only part of the diff is displayed.

Link to full diff

mozilla / bigquery-etl