dataops-ci-bot
commented
2 months ago Integration report for "feat: remove backfill.yaml for org_mozilla_fennec_aurora_derived/baseline_clients_daily_v1 as it was not used"
sql.diff
Click to expand!
```diff Only in /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/baseline_clients_daily_v1: backfill.yaml diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:56.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_frontend_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:56.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/bedrock_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/bedrock_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/bedrock_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/bedrock_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:56.000000000 +0000 @@ -60,7 +60,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.bedrock_live.non_interaction_v1` + `moz-fx-data-shared-prod.bedrock_live.interaction_v1` UNION ALL SELECT submission_timestamp, @@ -70,7 +70,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.bedrock_live.interaction_v1` + `moz-fx-data-shared-prod.bedrock_live.non_interaction_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -80,7 +80,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, 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-05-29 09:12:24.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates/schema.yaml 2024-05-29 09:20:05.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-05-29 09:12:24.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/contextual_services/event_aggregates_suggest/schema.yaml 2024-05-29 09:20:04.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/debug_ping_view_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/debug_ping_view_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/debug_ping_view_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/debug_ping_view_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:56.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, 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-05-29 09:12:24.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_clients/schema.yaml 2024-05-29 09:21:35.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-05-29 09:12:24.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/funnel_retention_week_4/schema.yaml 2024-05-29 09:21:36.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/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/metrics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/metrics/schema.yaml 2024-05-29 09:17:58.000000000 +0000 @@ -655,6 +655,9 @@ - name: home_bookmarks_show_all_bookmarks type: INTEGER mode: NULLABLE + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE - name: custom_distribution type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/metrics/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/metrics/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/fenix/metrics/view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/metrics/view.sql 2024-05-29 09:17:57.000000000 +0000 @@ -386,7 +386,8 @@ metrics.counter.hls_canplay_requested, metrics.counter.hls_canplay_supported, metrics.counter.home_bookmarks_bookmark_clicked, - metrics.counter.home_bookmarks_show_all_bookmarks + metrics.counter.home_bookmarks_show_all_bookmarks, + metrics.counter.bounce_tracking_protection_purge_count_classified_tracker ) AS `counter`, STRUCT( metrics.custom_distribution.geckoview_document_site_origins, @@ -1012,7 +1013,8 @@ metrics.counter.hls_canplay_requested, metrics.counter.hls_canplay_supported, metrics.counter.home_bookmarks_bookmark_clicked, - metrics.counter.home_bookmarks_show_all_bookmarks + metrics.counter.home_bookmarks_show_all_bookmarks, + metrics.counter.bounce_tracking_protection_purge_count_classified_tracker ) AS `counter`, STRUCT( metrics.custom_distribution.geckoview_document_site_origins, 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-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/fenix/use_counters/schema.yaml 2024-05-29 09:16:36.000000000 +0000 @@ -7164,6 +7164,12 @@ - name: use_counter_css_page_css_position_anchor type: INTEGER mode: NULLABLE + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/metrics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/metrics/schema.yaml 2024-05-29 09:14:07.000000000 +0000 @@ -812,6 +812,14 @@ description: 'Record when a canPlayType request supports HLS. ' + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE + description: 'Counts sites purged from BTP that are classified as trackers as + part of the following lists: [emailtracking-protection, fingerprinting-protection, + socialtracking-protection, tracking-protection] + + ' - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/use_counters/schema.yaml 2024-05-29 09:14:00.000000000 +0000 @@ -17632,6 +17632,22 @@ rate. ' + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a document used the CSS property position-visibility. + Compare against `use.counter.content_documents_destroyed` to calculate the + rate. + + ' + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a page used the CSS property position-visibility. Compare + against `use.counter.top_level_content_documents_destroyed` to calculate the + rate. + + ' - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/user_characteristics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/user_characteristics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/user_characteristics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop/user_characteristics/schema.yaml 2024-05-29 09:14:01.000000000 +0000 @@ -491,6 +491,30 @@ description: 'The CSS system-color Selecteditemtext. ' + - name: characteristics_avail_height + type: INTEGER + mode: NULLABLE + description: 'Available height property + + ' + - name: characteristics_avail_width + type: INTEGER + mode: NULLABLE + description: 'Available width property + + ' + - name: characteristics_orientation_angle + type: INTEGER + mode: NULLABLE + description: 'Orientation angle of the screen + + ' + - name: characteristics_pixel_depth + type: INTEGER + mode: NULLABLE + description: 'Screen pixel depth property + + ' - name: string type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_tasks_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_tasks_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_tasks_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_tasks_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:56.000000000 +0000 @@ -70,7 +70,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/metrics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/metrics/schema.yaml 2024-05-29 09:14:02.000000000 +0000 @@ -629,6 +629,14 @@ description: 'Record when a canPlayType request supports HLS. ' + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE + description: 'Counts sites purged from BTP that are classified as trackers as + part of the following lists: [emailtracking-protection, fingerprinting-protection, + socialtracking-protection, tracking-protection] + + ' - name: datetime type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_background_update/use_counters/schema.yaml 2024-05-29 09:14:06.000000000 +0000 @@ -17632,6 +17632,22 @@ rate. ' + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a document used the CSS property position-visibility. + Compare against `use.counter.content_documents_destroyed` to calculate the + rate. + + ' + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a page used the CSS property position-visibility. Compare + against `use.counter.top_level_content_documents_destroyed` to calculate the + rate. + + ' - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_desktop_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:57.000000000 +0000 @@ -50,7 +50,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.firefox_desktop_live.urlbar_potential_exposure_v1` + `moz-fx-data-shared-prod.firefox_desktop_live.prototype_no_code_events_v1` UNION ALL SELECT submission_timestamp, @@ -60,7 +60,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.firefox_desktop_live.events_v1` + `moz-fx-data-shared-prod.firefox_desktop_live.newtab_v1` UNION ALL SELECT submission_timestamp, @@ -70,7 +70,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.firefox_desktop_live.newtab_v1` + `moz-fx-data-shared-prod.firefox_desktop_live.events_v1` UNION ALL SELECT submission_timestamp, @@ -80,7 +80,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.firefox_desktop_live.prototype_no_code_events_v1` + `moz-fx-data-shared-prod.firefox_desktop_live.urlbar_potential_exposure_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -90,7 +90,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_translations_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_translations_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/firefox_translations_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/firefox_translations_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:57.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/focus_android/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/focus_android/metrics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android/metrics/schema.yaml 2024-05-29 09:16:10.000000000 +0000 @@ -424,6 +424,9 @@ - name: hls_canplay_supported type: INTEGER mode: NULLABLE + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE - name: datetime type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/focus_android/metrics/view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android/metrics/view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/focus_android/metrics/view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android/metrics/view.sql 2024-05-29 09:16:10.000000000 +0000 @@ -108,7 +108,8 @@ metrics.counter.httpsfirst_upgraded, metrics.counter.httpsfirst_upgraded_schemeless, metrics.counter.hls_canplay_requested, - metrics.counter.hls_canplay_supported + metrics.counter.hls_canplay_supported, + metrics.counter.bounce_tracking_protection_purge_count_classified_tracker ) AS `counter`, metrics.datetime, STRUCT( @@ -367,7 +368,8 @@ metrics.counter.httpsfirst_upgraded, metrics.counter.httpsfirst_upgraded_schemeless, metrics.counter.hls_canplay_requested, - metrics.counter.hls_canplay_supported + metrics.counter.hls_canplay_supported, + metrics.counter.bounce_tracking_protection_purge_count_classified_tracker ) AS `counter`, metrics.datetime, STRUCT( 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-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/focus_android/use_counters/schema.yaml 2024-05-29 09:15:52.000000000 +0000 @@ -7164,6 +7164,12 @@ - name: use_counter_css_page_css_position_anchor type: INTEGER mode: NULLABLE + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/internet_outages/global_outages_v1/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/internet_outages/global_outages_v1/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/internet_outages/global_outages_v1/schema.yaml 2024-05-29 09:12:25.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/internet_outages/global_outages_v1/schema.yaml 2024-05-29 09:21:47.000000000 +0000 @@ -1,49 +1,49 @@ fields: -- mode: NULLABLE - name: country +- name: country type: STRING -- mode: NULLABLE - name: city + mode: NULLABLE +- name: city type: STRING -- mode: NULLABLE - name: datetime + mode: NULLABLE +- name: datetime type: TIMESTAMP -- mode: NULLABLE - name: proportion_undefined + mode: NULLABLE +- name: proportion_undefined type: FLOAT -- mode: NULLABLE - name: proportion_timeout + mode: NULLABLE +- name: proportion_timeout type: FLOAT -- mode: NULLABLE - name: proportion_abort + mode: NULLABLE +- name: proportion_abort type: FLOAT -- mode: NULLABLE - name: proportion_unreachable + mode: NULLABLE +- name: proportion_unreachable type: FLOAT -- mode: NULLABLE - name: proportion_terminated + mode: NULLABLE +- name: proportion_terminated type: FLOAT -- mode: NULLABLE - name: proportion_channel_open + mode: NULLABLE +- name: proportion_channel_open type: FLOAT -- mode: NULLABLE - name: avg_dns_success_time + mode: NULLABLE +- name: avg_dns_success_time type: FLOAT -- mode: NULLABLE - name: missing_dns_success + mode: NULLABLE +- name: missing_dns_success type: FLOAT -- mode: NULLABLE - name: avg_dns_failure_time + mode: NULLABLE +- name: avg_dns_failure_time type: FLOAT -- mode: NULLABLE - name: missing_dns_failure + mode: NULLABLE +- name: missing_dns_failure type: FLOAT -- mode: NULLABLE - name: count_dns_failure + mode: NULLABLE +- name: count_dns_failure type: FLOAT -- mode: NULLABLE - name: ssl_error_prop + mode: NULLABLE +- name: ssl_error_prop type: FLOAT -- mode: NULLABLE - name: avg_tls_handshake_time + mode: NULLABLE +- name: avg_tls_handshake_time type: FLOAT + mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/klar_android/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/klar_android/metrics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android/metrics/schema.yaml 2024-05-29 09:16:35.000000000 +0000 @@ -424,6 +424,9 @@ - name: hls_canplay_supported type: INTEGER mode: NULLABLE + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE - name: datetime type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/klar_android/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/klar_android/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/klar_android/use_counters/schema.yaml 2024-05-29 09:16:27.000000000 +0000 @@ -7164,6 +7164,12 @@ - name: use_counter_css_page_css_position_anchor type: INTEGER mode: NULLABLE + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/mdn_yari_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/mdn_yari_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/mdn_yari_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/mdn_yari_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:57.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitor_frontend_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:58.000000000 +0000 @@ -19,7 +19,7 @@ event.name AS event_name, event_extra.key AS event_extra_key, normalized_country_code AS country, - 'Firefox Monitor (Frontend)' AS normalized_app_name, + 'Mozilla Monitor (Frontend)' AS normalized_app_name, channel, version, -- Access experiment information. @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_error_monitoring_aggregates_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_error_monitoring_aggregates_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_error_monitoring_aggregates_v1/query.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_error_monitoring_aggregates_v1/query.sql 2024-05-29 09:16:30.000000000 +0000 @@ -2127,7 +2127,7 @@ WITH event_counters AS ( SELECT DATE(submission_timestamp) AS submission_date, - "Firefox Monitor (Cirrus)" AS normalized_app_name, + "Mozilla Monitor (Cirrus)" AS normalized_app_name, client_info.app_channel AS channel, metrics.labeled_counter FROM @@ -2221,7 +2221,7 @@ WITH event_counters AS ( SELECT DATE(submission_timestamp) AS submission_date, - "Firefox Monitor (Frontend)" AS normalized_app_name, + "Mozilla Monitor (Frontend)" AS normalized_app_name, client_info.app_channel AS channel, metrics.labeled_counter FROM diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_flow_monitoring_aggregates_v1/script.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_flow_monitoring_aggregates_v1/script.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_flow_monitoring_aggregates_v1/script.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_flow_monitoring_aggregates_v1/script.sql 2024-05-29 09:16:30.000000000 +0000 @@ -663,7 +663,7 @@ -- limit event.timestamp, otherwise this will cause an overflow INTERVAL LEAST(event_timestamp, 20000000000000) MILLISECOND ) AS timestamp, - "Firefox Monitor (Cirrus)" AS normalized_app_name, + "Mozilla Monitor (Cirrus)" AS normalized_app_name, client_info.app_channel AS channel FROM `moz-fx-data-shared-prod.monitor_cirrus.events_unnested`, @@ -701,7 +701,7 @@ -- limit event.timestamp, otherwise this will cause an overflow INTERVAL LEAST(event_timestamp, 20000000000000) MILLISECOND ) AS timestamp, - "Firefox Monitor (Frontend)" AS normalized_app_name, + "Mozilla Monitor (Frontend)" AS normalized_app_name, client_info.app_channel AS channel FROM `moz-fx-data-shared-prod.monitor_frontend.events_unnested`, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_monitoring_aggregates_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_monitoring_aggregates_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_monitoring_aggregates_v1/query.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/monitoring_derived/event_monitoring_aggregates_v1/query.sql 2024-05-29 09:16:30.000000000 +0000 @@ -45,7 +45,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.firefox_desktop_stable.urlbar_potential_exposure_v1` + `moz-fx-data-shared-prod.firefox_desktop_stable.prototype_no_code_events_v1` UNION ALL SELECT submission_timestamp, @@ -55,7 +55,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.firefox_desktop_stable.events_v1` + `moz-fx-data-shared-prod.firefox_desktop_stable.newtab_v1` UNION ALL SELECT submission_timestamp, @@ -65,7 +65,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.firefox_desktop_stable.newtab_v1` + `moz-fx-data-shared-prod.firefox_desktop_stable.events_v1` UNION ALL SELECT submission_timestamp, @@ -75,7 +75,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.firefox_desktop_stable.prototype_no_code_events_v1` + `moz-fx-data-shared-prod.firefox_desktop_stable.urlbar_potential_exposure_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -582,7 +582,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.org_mozilla_ios_firefox_stable.metrics_v1` + `moz-fx-data-shared-prod.org_mozilla_ios_firefox_stable.first_session_v1` UNION ALL SELECT submission_timestamp, @@ -592,7 +592,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.org_mozilla_ios_firefox_stable.first_session_v1` + `moz-fx-data-shared-prod.org_mozilla_ios_firefox_stable.metrics_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -673,7 +673,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.org_mozilla_ios_firefoxbeta_stable.metrics_v1` + `moz-fx-data-shared-prod.org_mozilla_ios_firefoxbeta_stable.first_session_v1` UNION ALL SELECT submission_timestamp, @@ -683,7 +683,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.org_mozilla_ios_firefoxbeta_stable.first_session_v1` + `moz-fx-data-shared-prod.org_mozilla_ios_firefoxbeta_stable.metrics_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -764,7 +764,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.org_mozilla_ios_fennec_stable.metrics_v1` + `moz-fx-data-shared-prod.org_mozilla_ios_fennec_stable.first_session_v1` UNION ALL SELECT submission_timestamp, @@ -774,7 +774,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.org_mozilla_ios_fennec_stable.first_session_v1` + `moz-fx-data-shared-prod.org_mozilla_ios_fennec_stable.metrics_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -2000,7 +2000,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.bedrock_stable.non_interaction_v1` + `moz-fx-data-shared-prod.bedrock_stable.interaction_v1` UNION ALL SELECT submission_timestamp, @@ -2010,7 +2010,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.bedrock_stable.interaction_v1` + `moz-fx-data-shared-prod.bedrock_stable.non_interaction_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -2081,7 +2081,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.viu_politica_stable.main_events_v1` + `moz-fx-data-shared-prod.viu_politica_stable.video_index_v1` UNION ALL SELECT submission_timestamp, @@ -2091,7 +2091,7 @@ client_info.app_display_version AS version, ping_info FROM - `moz-fx-data-shared-prod.viu_politica_stable.video_index_v1` + `moz-fx-data-shared-prod.viu_politica_stable.main_events_v1` ) CROSS JOIN UNNEST(events) AS event, @@ -2421,7 +2421,7 @@ event.name AS event_name, event_extra.key AS event_extra_key, normalized_country_code AS country, - "Firefox Monitor (Frontend)" AS normalized_app_name, + "Mozilla Monitor (Frontend)" AS normalized_app_name, channel, version, -- Access experiment information. diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/mozilla_vpn/subscriptions/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/mozilla_vpn/subscriptions/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/mozilla_vpn/subscriptions/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/mozilla_vpn/subscriptions/schema.yaml 2024-05-29 09:20:20.000000000 +0000 @@ -20,45 +20,3 @@ - name: type type: STRING mode: NULLABLE -- name: provider - type: STRING - mode: NULLABLE -- name: apple_receipt - type: RECORD - mode: NULLABLE - fields: - - name: environment - type: STRING - mode: NULLABLE - - name: active_period - type: RECORD - mode: NULLABLE - fields: - - name: start_date - type: DATE - mode: NULLABLE - - name: end_date - type: DATE - mode: NULLABLE - - name: start_time - type: TIMESTAMP - mode: NULLABLE - - name: end_time - type: TIMESTAMP - mode: NULLABLE - - name: interval - type: STRING - mode: NULLABLE - - name: interval_count - type: INTEGER - mode: NULLABLE - - name: trial_period - type: RECORD - mode: NULLABLE - fields: - - name: start_time - type: TIMESTAMP - mode: NULLABLE - - name: end_time - type: TIMESTAMP - mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/mozillavpn_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/mozillavpn_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/mozillavpn_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/mozillavpn_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:56.000000000 +0000 @@ -80,7 +80,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_bergamot_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_bergamot_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_bergamot_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_bergamot_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:56.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, 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-05-29 09:12:25.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/geckoview_version/schema.yaml 2024-05-29 09:20:24.000000000 +0000 @@ -1,7 +1,10 @@ fields: -- type: DATETIME - name: build_hour -- type: INTEGER - name: geckoview_major_version -- type: INTEGER - name: n_pings +- name: build_hour + type: DATETIME + mode: NULLABLE +- name: geckoview_major_version + type: INTEGER + mode: NULLABLE +- name: n_pings + type: INTEGER + mode: NULLABLE 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-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/metrics/schema.yaml 2024-05-29 09:14:24.000000000 +0000 @@ -1480,6 +1480,14 @@ on the home screen. This was previously recent_bookmarks.show_all_bookmarks. ' + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE + description: 'Counts sites purged from BTP that are classified as trackers as + part of the following lists: [emailtracking-protection, fingerprinting-protection, + socialtracking-protection, tracking-protection] + + ' - name: labeled_counter type: RECORD mode: NULLABLE @@ -1852,7 +1860,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_fenix/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix/use_counters/schema.yaml 2024-05-29 09:14:15.000000000 +0000 @@ -17632,6 +17632,22 @@ rate. ' + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a document used the CSS property position-visibility. + Compare against `use.counter.content_documents_destroyed` to calculate the + rate. + + ' + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a page used the CSS property position-visibility. Compare + against `use.counter.top_level_content_documents_destroyed` to calculate the + rate. + + ' - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:58.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/metrics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/metrics/schema.yaml 2024-05-29 09:14:16.000000000 +0000 @@ -1480,6 +1480,14 @@ on the home screen. This was previously recent_bookmarks.show_all_bookmarks. ' + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE + description: 'Counts sites purged from BTP that are classified as trackers as + part of the following lists: [emailtracking-protection, fingerprinting-protection, + socialtracking-protection, tracking-protection] + + ' - name: labeled_counter type: RECORD mode: NULLABLE @@ -1852,8 +1860,7 @@ - name: value type: INTEGER mode: NULLABLE - description: 'Failure occurs when initializing the audio stream. (Migrated from - the geckoview metric of the same name). + description: 'Failure occurs when initializing the audio stream. ' - name: glean_validation_pings_submitted diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly/use_counters/schema.yaml 2024-05-29 09:14:10.000000000 +0000 @@ -17632,6 +17632,22 @@ rate. ' + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a document used the CSS property position-visibility. + Compare against `use.counter.content_documents_destroyed` to calculate the + rate. + + ' + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a page used the CSS property position-visibility. Compare + against `use.counter.top_level_content_documents_destroyed` to calculate the + rate. + + ' - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fenix_nightly_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:57.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, 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-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/metrics/schema.yaml 2024-05-29 09:14:25.000000000 +0000 @@ -1480,6 +1480,14 @@ on the home screen. This was previously recent_bookmarks.show_all_bookmarks. ' + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE + description: 'Counts sites purged from BTP that are classified as trackers as + part of the following lists: [emailtracking-protection, fingerprinting-protection, + socialtracking-protection, tracking-protection] + + ' - name: custom_distribution type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora/use_counters/schema.yaml 2024-05-29 09:14:21.000000000 +0000 @@ -17632,6 +17632,22 @@ rate. ' + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a document used the CSS property position-visibility. + Compare against `use.counter.content_documents_destroyed` to calculate the + rate. + + ' + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a page used the CSS property position-visibility. Compare + against `use.counter.top_level_content_documents_destroyed` to calculate the + rate. + + ' - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/baseline_clients_daily_v1/backfill.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/baseline_clients_daily_v1/backfill.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/baseline_clients_daily_v1/backfill.yaml 2024-05-29 09:12:25.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/baseline_clients_daily_v1/backfill.yaml 1970-01-01 00:00:00.000000000 +0000 @@ -1,8 +0,0 @@ -2024-05-22: - start_date: 2024-05-15 - end_date: 2024-05-20 - reason: |- - This is a limited time window trial of the managed backfill process to use sql_generated query. - watchers: - - kik@mozilla.com - status: Initiate diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_fennec_aurora_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:58.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/metrics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/metrics/schema.yaml 2024-05-29 09:14:25.000000000 +0000 @@ -1480,6 +1480,14 @@ on the home screen. This was previously recent_bookmarks.show_all_bookmarks. ' + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE + description: 'Counts sites purged from BTP that are classified as trackers as + part of the following lists: [emailtracking-protection, fingerprinting-protection, + socialtracking-protection, tracking-protection] + + ' - name: custom_distribution type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox/use_counters/schema.yaml 2024-05-29 09:14:21.000000000 +0000 @@ -17632,6 +17632,22 @@ rate. ' + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a document used the CSS property position-visibility. + Compare against `use.counter.content_documents_destroyed` to calculate the + rate. + + ' + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a page used the CSS property position-visibility. Compare + against `use.counter.top_level_content_documents_destroyed` to calculate the + rate. + + ' - name: labeled_counter type: RECORD mode: NULLABLE 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-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/metrics/schema.yaml 2024-05-29 09:14:19.000000000 +0000 @@ -1480,6 +1480,14 @@ on the home screen. This was previously recent_bookmarks.show_all_bookmarks. ' + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE + description: 'Counts sites purged from BTP that are classified as trackers as + part of the following lists: [emailtracking-protection, fingerprinting-protection, + socialtracking-protection, tracking-protection] + + ' - name: custom_distribution type: RECORD mode: NULLABLE @@ -3163,7 +3171,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/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta/use_counters/schema.yaml 2024-05-29 09:14:15.000000000 +0000 @@ -17632,6 +17632,22 @@ rate. ' + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a document used the CSS property position-visibility. + Compare against `use.counter.content_documents_destroyed` to calculate the + rate. + + ' + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a page used the CSS property position-visibility. Compare + against `use.counter.top_level_content_documents_destroyed` to calculate the + rate. + + ' - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_beta_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:58.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:59.000000000 +0000 @@ -60,7 +60,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_vpn_derived/event_monitoring_live_v1/materialized_view.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_vpn_derived/event_monitoring_live_v1/materialized_view.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_vpn_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_firefox_vpn_derived/event_monitoring_live_v1/materialized_view.sql 2024-05-29 09:14:58.000000000 +0000 @@ -80,7 +80,7 @@ LEFT JOIN UNNEST(event.extra) AS event_extra WHERE - DATE(submission_timestamp) >= "2024-05-28" + DATE(submission_timestamp) >= "2024-05-29" GROUP BY submission_date, window_start, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/metrics/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/metrics/schema.yaml 2024-05-29 09:14:35.000000000 +0000 @@ -835,6 +835,14 @@ description: 'Record when a canPlayType request supports HLS. ' + - name: bounce_tracking_protection_purge_count_classified_tracker + type: INTEGER + mode: NULLABLE + description: 'Counts sites purged from BTP that are classified as trackers as + part of the following lists: [emailtracking-protection, fingerprinting-protection, + socialtracking-protection, tracking-protection] + + ' - name: datetime type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/use_counters/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/use_counters/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/use_counters/schema.yaml 2024-05-29 09:12:58.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus/use_counters/schema.yaml 2024-05-29 09:14:24.000000000 +0000 @@ -17632,6 +17632,22 @@ rate. ' + - name: use_counter_css_doc_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a document used the CSS property position-visibility. + Compare against `use.counter.content_documents_destroyed` to calculate the + rate. + + ' + - name: use_counter_css_page_css_position_visibility + type: INTEGER + mode: NULLABLE + description: 'Whether a page used the CSS property position-visibility. Compare + against `use.counter.top_level_content_documents_destroyed` to calculate the + rate. + + ' - name: labeled_counter type: RECORD mode: NULLABLE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus_beta/metrics/schema.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus_beta/metrics/schema.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/org_mozilla_focus_beta/metrics/schema.yaml 2024-05-29 09:12:58. ```⚠️ Only part of the diff is displayed.
feat: remove backfill.yaml for org_mozilla_fennec_aurora_derived/baseline_clients_daily_v1 as it was not used
Checklist for reviewer:
<username>:<branch>of the fork as parameter. The parameter will also show up in the logs of themanual-trigger-required-for-forkCI task together with more detailed instructions.For modifications to schemas in restricted namespaces (see
CODEOWNERS):┆Issue is synchronized with this Jira Task