search

mozilla / lookml-generator

LookML Generator for Glean and Mozilla Data
https://mozilla.github.io/lookml-generator/generator.html
Mozilla Public License 2.0
17 stars 17 forks source link

feat: deprecate funnel_retention_week_4 table views for fenix and firefox_ios as superseded by mobile_retention #1061

Closed kik-kik closed 2 months ago

kik-kik commented 2 months ago

feat: deprecate funnel_retention_week_4 table views for fenix and firefox_ios as superseded by mobile_retention

kik-kik commented 2 months ago

Prior to merging we need to remove the following references:

dataops-ci-bot commented 2 months ago

Integration report for "feat: deprecate funnel_retention_week_4 table views for fenix and firefox_ios as superseded by mobile_retention"

lookml.diff

Click to expand! ```diff Only in /tmp/workspace/looker-hub/fenix/views: funnel_retention_week_4.view.lkml Only in /tmp/workspace/looker-hub/firefox_ios: dashboards Only in /tmp/workspace/looker-hub/firefox_ios/views: funnel_retention_week_4.view.lkml Only in /tmp/workspace/looker-hub/: user_journey diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/fenix/explores/metrics.explore.lkml /tmp/workspace/generated-lookml/fenix/explores/metrics.explore.lkml --- /tmp/workspace/looker-hub/fenix/explores/metrics.explore.lkml 2024-09-19 12:30:09.455190888 +0000 +++ /tmp/workspace/generated-lookml/fenix/explores/metrics.explore.lkml 2024-09-19 12:28:44.000000000 +0000 @@ -459,6 +459,26 @@ sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_eh_response_version}) AS metrics__metrics__labeled_counter__netwerk_eh_response_version ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_eh_response_version.document_id} ;; } + join: metrics__metrics__labeled_counter__netwerk_http3_0rtt_state { + relationship: one_to_many + sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_http3_0rtt_state}) AS metrics__metrics__labeled_counter__netwerk_http3_0rtt_state ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_http3_0rtt_state.document_id} ;; + } + + join: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_grease { + relationship: one_to_many + sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_http3_ech_outcome_grease}) AS metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_grease ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_grease.document_id} ;; + } + + join: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_none { + relationship: one_to_many + sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_http3_ech_outcome_none}) AS metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_none ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_none.document_id} ;; + } + + join: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_real { + relationship: one_to_many + sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_http3_ech_outcome_real}) AS metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_real ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_real.document_id} ;; + } + join: metrics__metrics__labeled_counter__network_byte_range_request { relationship: one_to_many sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__network_byte_range_request}) AS metrics__metrics__labeled_counter__network_byte_range_request ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__network_byte_range_request.document_id} ;; diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/fenix/views/funnel_retention_week_4.view.lkml /tmp/workspace/generated-lookml/fenix/views/funnel_retention_week_4.view.lkml --- /tmp/workspace/looker-hub/fenix/views/funnel_retention_week_4.view.lkml 2024-09-19 12:30:09.479190993 +0000 +++ /tmp/workspace/generated-lookml/fenix/views/funnel_retention_week_4.view.lkml 1970-01-01 00:00:00.000000000 +0000 @@ -1,89 +0,0 @@ - -# *Do not manually modify this file* -# -# This file has been generated via https://github.com/mozilla/lookml-generator -# You can extend this view in the looker-spoke-default project (https://github.com/mozilla/looker-spoke-default) - -view: funnel_retention_week_4 { - dimension: adjust_ad_group { - sql: ${TABLE}.adjust_ad_group ;; - type: string - } - - dimension: adjust_campaign { - sql: ${TABLE}.adjust_campaign ;; - type: string - } - - dimension: adjust_creative { - sql: ${TABLE}.adjust_creative ;; - type: string - } - - dimension: adjust_network { - sql: ${TABLE}.adjust_network ;; - type: string - } - - dimension: first_reported_country { - sql: ${TABLE}.first_reported_country ;; - type: string - } - - dimension: first_reported_isp { - sql: ${TABLE}.first_reported_isp ;; - type: string - } - - dimension: install_source { - sql: ${TABLE}.install_source ;; - type: string - } - - dimension: new_profiles { - sql: ${TABLE}.new_profiles ;; - type: number - } - - dimension: repeat_user { - sql: ${TABLE}.repeat_user ;; - type: number - } - - dimension: retained_week_4 { - sql: ${TABLE}.retained_week_4 ;; - type: number - } - - dimension_group: first_seen { - sql: ${TABLE}.first_seen_date ;; - type: time - timeframes: [ - raw, - date, - week, - month, - quarter, - year, - ] - convert_tz: no - datatype: date - } - - dimension_group: submission { - sql: ${TABLE}.submission_date ;; - type: time - timeframes: [ - raw, - date, - week, - month, - quarter, - year, - ] - convert_tz: no - datatype: date - } - - sql_table_name: `mozdata.fenix.funnel_retention_week_4` ;; -} \ No newline at end of file diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/fenix/views/metrics_table.view.lkml /tmp/workspace/generated-lookml/fenix/views/metrics_table.view.lkml --- /tmp/workspace/looker-hub/fenix/views/metrics_table.view.lkml 2024-09-19 12:30:09.487191028 +0000 +++ /tmp/workspace/generated-lookml/fenix/views/metrics_table.view.lkml 2024-09-19 12:25:35.000000000 +0000 @@ -3081,6 +3081,26 @@ hidden: yes } + dimension: metrics__labeled_counter__netwerk_http3_0rtt_state { + sql: ${TABLE}.metrics.labeled_counter.netwerk_http3_0rtt_state ;; + hidden: yes + } + + dimension: metrics__labeled_counter__netwerk_http3_ech_outcome_grease { + sql: ${TABLE}.metrics.labeled_counter.netwerk_http3_ech_outcome_grease ;; + hidden: yes + } + + dimension: metrics__labeled_counter__netwerk_http3_ech_outcome_none { + sql: ${TABLE}.metrics.labeled_counter.netwerk_http3_ech_outcome_none ;; + hidden: yes + } + + dimension: metrics__labeled_counter__netwerk_http3_ech_outcome_real { + sql: ${TABLE}.metrics.labeled_counter.netwerk_http3_ech_outcome_real ;; + hidden: yes + } + dimension: metrics__labeled_counter__network_byte_range_request { sql: ${TABLE}.metrics.labeled_counter.network_byte_range_request ;; hidden: yes @@ -3516,6 +3536,11 @@ hidden: yes } + dimension: metrics__labeled_timing_distribution__netwerk_http3_0rtt_state_duration { + sql: ${TABLE}.metrics.labeled_timing_distribution.netwerk_http3_0rtt_state_duration ;; + hidden: yes + } + dimension: metrics__labeled_timing_distribution__network_http3_complete_load { sql: ${TABLE}.metrics.labeled_timing_distribution.network_http3_complete_load ;; hidden: yes @@ -17126,6 +17151,84 @@ } } +view: metrics_table__metrics__labeled_timing_distribution__netwerk_http3_0rtt_state_duration { + dimension: key { + sql: ${TABLE}.key ;; + type: string + } + + dimension: value__bucket_count { + sql: ${TABLE}.value.bucket_count ;; + type: number + group_label: "Value" + group_item_label: "Bucket Count" + } + + dimension: value__count { + sql: ${TABLE}.value.count ;; + type: number + group_label: "Value" + group_item_label: "Count" + } + + dimension: value__histogram_type { + sql: ${TABLE}.value.histogram_type ;; + type: string + group_label: "Value" + group_item_label: "Histogram Type" + } + + dimension: value__overflow { + sql: ${TABLE}.value.overflow ;; + type: number + group_label: "Value" + group_item_label: "Overflow" + } + + dimension: value__range { + sql: ${TABLE}.value.range ;; + hidden: yes + } + + dimension: value__sum { + sql: ${TABLE}.value.sum ;; + type: number + group_label: "Value" + group_item_label: "Sum" + } + + dimension: value__time_unit { + sql: ${TABLE}.value.time_unit ;; + type: string + group_label: "Value" + group_item_label: "Time Unit" + } + + dimension: value__underflow { + sql: ${TABLE}.value.underflow ;; + type: number + group_label: "Value" + group_item_label: "Underflow" + } + + dimension: value__values { + sql: ${TABLE}.value.values ;; + hidden: yes + } +} + +view: metrics_table__metrics__labeled_timing_distribution__netwerk_http3_0rtt_state_duration__value__values { + dimension: key { + sql: ${TABLE}.key ;; + type: string + } + + dimension: value { + sql: ${TABLE}.value ;; + type: number + } +} + view: metrics_table__metrics__labeled_timing_distribution__network_http3_complete_load { dimension: key { sql: ${TABLE}.key ;; diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/fenix/views/metrics.view.lkml /tmp/workspace/generated-lookml/fenix/views/metrics.view.lkml --- /tmp/workspace/looker-hub/fenix/views/metrics.view.lkml 2024-09-19 12:30:09.487191028 +0000 +++ /tmp/workspace/generated-lookml/fenix/views/metrics.view.lkml 2024-09-19 12:25:32.000000000 +0000 @@ -7183,6 +7183,74 @@ " } + dimension: metrics__labeled_counter__netwerk_http3_0rtt_state { + label: "Netwerk Http3 0Rtt State" + hidden: yes + sql: ${TABLE}.metrics.labeled_counter.netwerk_http3_0rtt_state ;; + group_label: "Netwerk" + group_item_label: "Http3 0Rtt State" + + link: { + label: "Glean Dictionary reference for Netwerk Http3 0Rtt State" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/netwerk_http3_0rtt_state" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Gather the outcome of 0-RTT usage: - \"not_used\": 0RTT_NOT_USED - \"succeeded\": 0RTT_USED_SUCCESS - \"rejected\": 0RTT_USED_REJECT - \"conn_error\": 0RTT_USED_CONN_ERROR - \"conn_closed_by_necko\": 0RTT_CONN_CLOSED_BY_NECKO +" + } + + dimension: metrics__labeled_counter__netwerk_http3_ech_outcome_grease { + label: "Netwerk Http3 Ech Outcome Grease" + hidden: yes + sql: ${TABLE}.metrics.labeled_counter.netwerk_http3_ech_outcome_grease ;; + group_label: "Netwerk" + group_item_label: "Http3 Ech Outcome Grease" + + link: { + label: "Glean Dictionary reference for Netwerk Http3 Ech Outcome Grease" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/netwerk_http3_ech_outcome_grease" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Success / Fail Rates for HTTP3 when a GREASE ECH Extension was sent +" + } + + dimension: metrics__labeled_counter__netwerk_http3_ech_outcome_none { + label: "Netwerk Http3 Ech Outcome None" + hidden: yes + sql: ${TABLE}.metrics.labeled_counter.netwerk_http3_ech_outcome_none ;; + group_label: "Netwerk" + group_item_label: "Http3 Ech Outcome None" + + link: { + label: "Glean Dictionary reference for Netwerk Http3 Ech Outcome None" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/netwerk_http3_ech_outcome_none" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Success / Fail Rates for HTTP3 when No ECH Extension was sent +" + } + + dimension: metrics__labeled_counter__netwerk_http3_ech_outcome_real { + label: "Netwerk Http3 Ech Outcome Real" + hidden: yes + sql: ${TABLE}.metrics.labeled_counter.netwerk_http3_ech_outcome_real ;; + group_label: "Netwerk" + group_item_label: "Http3 Ech Outcome Real" + + link: { + label: "Glean Dictionary reference for Netwerk Http3 Ech Outcome Real" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/netwerk_http3_ech_outcome_real" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Success / Fail Rates for HTTP3 when a 'real' ECH Extension was sent +" + } + dimension: metrics__counter__netwerk_parent_connect_timeout { label: "Netwerk Parent Connect Timeout" hidden: no @@ -20219,6 +20287,170 @@ } } +view: metrics__metrics__labeled_counter__netwerk_http3_0rtt_state { + label: "Netwerk - Http3 0Rtt State" + + dimension: document_id { + type: string + sql: ${metrics.document_id} ;; + hidden: yes + } + + dimension: document_label_id { + type: string + sql: ${metrics.document_id}-${label} ;; + primary_key: yes + hidden: yes + } + + dimension: value { + type: number + sql: ${TABLE}.value ;; + hidden: yes + } + + dimension: label { + type: string + sql: ${TABLE}.key ;; + hidden: yes + } + + measure: count { + type: sum + sql: ${value} ;; + hidden: yes + } + + measure: client_count { + type: count_distinct + sql: case when ${value} > 0 then ${metrics.client_info__client_id} end ;; + hidden: yes + } +} + +view: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_grease { + label: "Netwerk - Http3 Ech Outcome Grease" + + dimension: document_id { + type: string + sql: ${metrics.document_id} ;; + hidden: yes + } + + dimension: document_label_id { + type: string + sql: ${metrics.document_id}-${label} ;; + primary_key: yes + hidden: yes + } + + dimension: value { + type: number + sql: ${TABLE}.value ;; + hidden: yes + } + + dimension: label { + type: string + sql: ${TABLE}.key ;; + hidden: yes + } + + measure: count { + type: sum + sql: ${value} ;; + hidden: yes + } + + measure: client_count { + type: count_distinct + sql: case when ${value} > 0 then ${metrics.client_info__client_id} end ;; + hidden: yes + } +} + +view: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_none { + label: "Netwerk - Http3 Ech Outcome None" + + dimension: document_id { + type: string + sql: ${metrics.document_id} ;; + hidden: yes + } + + dimension: document_label_id { + type: string + sql: ${metrics.document_id}-${label} ;; + primary_key: yes + hidden: yes + } + + dimension: value { + type: number + sql: ${TABLE}.value ;; + hidden: yes + } + + dimension: label { + type: string + sql: ${TABLE}.key ;; + hidden: yes + } + + measure: count { + type: sum + sql: ${value} ;; + hidden: yes + } + + measure: client_count { + type: count_distinct + sql: case when ${value} > 0 then ${metrics.client_info__client_id} end ;; + hidden: yes + } +} + +view: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_real { + label: "Netwerk - Http3 Ech Outcome Real" + + dimension: document_id { + type: string + sql: ${metrics.document_id} ;; + hidden: yes + } + + dimension: document_label_id { + type: string + sql: ${metrics.document_id}-${label} ;; + primary_key: yes + hidden: yes + } + + dimension: value { + type: number + sql: ${TABLE}.value ;; + hidden: yes + } + + dimension: label { + type: string + sql: ${TABLE}.key ;; + hidden: yes + } + + measure: count { + type: sum + sql: ${value} ;; + hidden: yes + } + + measure: client_count { + type: count_distinct + sql: case when ${value} > 0 then ${metrics.client_info__client_id} end ;; + hidden: yes + } +} + view: metrics__metrics__labeled_counter__network_byte_range_request { label: "Network - Byte Range Request" @@ -24611,6 +24843,84 @@ } } +view: metrics__metrics__labeled_timing_distribution__netwerk_http3_0rtt_state_duration { + dimension: key { + sql: ${TABLE}.key ;; + type: string + } + + dimension: value__bucket_count { + sql: ${TABLE}.value.bucket_count ;; + type: number + group_label: "Value" + group_item_label: "Bucket Count" + } + + dimension: value__count { + sql: ${TABLE}.value.count ;; + type: number + group_label: "Value" + group_item_label: "Count" + } + + dimension: value__histogram_type { + sql: ${TABLE}.value.histogram_type ;; + type: string + group_label: "Value" + group_item_label: "Histogram Type" + } + + dimension: value__overflow { + sql: ${TABLE}.value.overflow ;; + type: number + group_label: "Value" + group_item_label: "Overflow" + } + + dimension: value__range { + sql: ${TABLE}.value.range ;; + hidden: yes + } + + dimension: value__sum { + sql: ${TABLE}.value.sum ;; + type: number + group_label: "Value" + group_item_label: "Sum" + } + + dimension: value__time_unit { + sql: ${TABLE}.value.time_unit ;; + type: string + group_label: "Value" + group_item_label: "Time Unit" + } + + dimension: value__underflow { + sql: ${TABLE}.value.underflow ;; + type: number + group_label: "Value" + group_item_label: "Underflow" + } + + dimension: value__values { + sql: ${TABLE}.value.values ;; + hidden: yes + } +} + +view: metrics__metrics__labeled_timing_distribution__netwerk_http3_0rtt_state_duration__value__values { + dimension: key { + sql: ${TABLE}.key ;; + type: string + } + + dimension: value { + sql: ${TABLE}.value ;; + type: number + } +} + view: metrics__metrics__labeled_timing_distribution__network_http3_complete_load { dimension: key { sql: ${TABLE}.key ;; diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/fenix/views/user_characteristics_table.view.lkml /tmp/workspace/generated-lookml/fenix/views/user_characteristics_table.view.lkml --- /tmp/workspace/looker-hub/fenix/views/user_characteristics_table.view.lkml 2024-09-19 12:30:09.507191115 +0000 +++ /tmp/workspace/generated-lookml/fenix/views/user_characteristics_table.view.lkml 2024-09-19 12:26:23.000000000 +0000 @@ -368,6 +368,13 @@ group_item_label: "Characteristics Build Date" } + dimension: metrics__quantity__characteristics_camera_count { + sql: ${TABLE}.metrics.quantity.characteristics_camera_count ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Camera Count" + } + dimension: metrics__quantity__characteristics_color_accentcolor { sql: ${TABLE}.metrics.quantity.characteristics_color_accentcolor ;; type: number @@ -522,6 +529,41 @@ group_item_label: "Characteristics Font Size Variable Modified" } + dimension: metrics__quantity__characteristics_gl_version { + sql: ${TABLE}.metrics.quantity.characteristics_gl_version ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Gl Version" + } + + dimension: metrics__quantity__characteristics_group_count { + sql: ${TABLE}.metrics.quantity.characteristics_group_count ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Group Count" + } + + dimension: metrics__quantity__characteristics_group_count_wo_speakers { + sql: ${TABLE}.metrics.quantity.characteristics_group_count_wo_speakers ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Group Count Wo Speakers" + } + + dimension: metrics__quantity__characteristics_ice_order { + sql: ${TABLE}.metrics.quantity.characteristics_ice_order ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Ice Order" + } + + dimension: metrics__quantity__characteristics_ice_sd { + sql: ${TABLE}.metrics.quantity.characteristics_ice_sd ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Ice Sd" + } + dimension: metrics__quantity__characteristics_inner_height { sql: ${TABLE}.metrics.quantity.characteristics_inner_height ;; type: number @@ -613,6 +655,13 @@ group_item_label: "Characteristics Max Touch Points" } + dimension: metrics__quantity__characteristics_microphone_count { + sql: ${TABLE}.metrics.quantity.characteristics_microphone_count ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Microphone Count" + } + dimension: metrics__quantity__characteristics_motion_decimals { sql: ${TABLE}.metrics.quantity.characteristics_motion_decimals ;; type: number @@ -795,6 +844,13 @@ group_item_label: "Characteristics Size Mode" } + dimension: metrics__quantity__characteristics_speaker_count { + sql: ${TABLE}.metrics.quantity.characteristics_speaker_count ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Speaker Count" + } + dimension: metrics__quantity__characteristics_submission_schema { sql: ${TABLE}.metrics.quantity.characteristics_submission_schema ;; type: number @@ -809,6 +865,20 @@ group_item_label: "Characteristics Target Frame Rate" } + dimension: metrics__quantity__characteristics_voices_count { + sql: ${TABLE}.metrics.quantity.characteristics_voices_count ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Voices Count" + } + + dimension: metrics__quantity__characteristics_voices_local_count { + sql: ${TABLE}.metrics.quantity.characteristics_voices_local_count ;; + type: number + group_label: "Metrics Quantity" + group_item_label: "Characteristics Voices Local Count" + } + dimension: metrics__quantity__characteristics_zoom_count { sql: ${TABLE}.metrics.quantity.characteristics_zoom_count ;; type: number @@ -1117,6 +1187,55 @@ group_item_label: "Characteristics Font Size Variable Western" } + dimension: metrics__string__characteristics_gl_fragment_shader { + sql: ${TABLE}.metrics.string.characteristics_gl_fragment_shader ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Gl Fragment Shader" + } + + dimension: metrics__string__characteristics_gl_renderer { + sql: ${TABLE}.metrics.string.characteristics_gl_renderer ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Gl Renderer" + } + + dimension: metrics__string__characteristics_gl_renderer_raw { + sql: ${TABLE}.metrics.string.characteristics_gl_renderer_raw ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Gl Renderer Raw" + } + + dimension: metrics__string__characteristics_gl_vendor { + sql: ${TABLE}.metrics.string.characteristics_gl_vendor ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Gl Vendor" + } + + dimension: metrics__string__characteristics_gl_vendor_raw { + sql: ${TABLE}.metrics.string.characteristics_gl_vendor_raw ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Gl Vendor Raw" + } + + dimension: metrics__string__characteristics_gl_version_raw { + sql: ${TABLE}.metrics.string.characteristics_gl_version_raw ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Gl Version Raw" + } + + dimension: metrics__string__characteristics_gl_vertex_shader { + sql: ${TABLE}.metrics.string.characteristics_gl_vertex_shader ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Gl Vertex Shader" + } + dimension: metrics__string__characteristics_intl_locale { sql: ${TABLE}.metrics.string.characteristics_intl_locale ;; type: string @@ -1229,6 +1348,34 @@ group_item_label: "Characteristics Version" } + dimension: metrics__string__characteristics_voices_all_ssdeep { + sql: ${TABLE}.metrics.string.characteristics_voices_all_ssdeep ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Voices All Ssdeep" + } + + dimension: metrics__string__characteristics_voices_default { + sql: ${TABLE}.metrics.string.characteristics_voices_default ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Voices Default" + } + + dimension: metrics__string__characteristics_voices_local_ssdeep { + sql: ${TABLE}.metrics.string.characteristics_voices_local_ssdeep ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Voices Local Ssdeep" + } + + dimension: metrics__string__characteristics_voices_nonlocal_ssdeep { + sql: ${TABLE}.metrics.string.characteristics_voices_nonlocal_ssdeep ;; + type: string + group_label: "Metrics String" + group_item_label: "Characteristics Voices Nonlocal Ssdeep" + } + dimension: metrics__string__glean_client_annotation_experimentation_id { sql: ${TABLE}.metrics.string.glean_client_annotation_experimentation_id ;; type: string @@ -1346,6 +1493,62 @@ group_item_label: "Characteristics Errors" } + dimension: metrics__text2__characteristics_gl_extensions { + sql: ${TABLE}.metrics.text2.characteristics_gl_extensions ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Gl Extensions" + } + + dimension: metrics__text2__characteristics_gl_extensions_raw { + sql: ${TABLE}.metrics.text2.characteristics_gl_extensions_raw ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Gl Extensions Raw" + } + + dimension: metrics__text2__characteristics_gl_minimal_source { + sql: ${TABLE}.metrics.text2.characteristics_gl_minimal_source ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Gl Minimal Source" + } + + dimension: metrics__text2__characteristics_gl_params_extensions { + sql: ${TABLE}.metrics.text2.characteristics_gl_params_extensions ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Gl Params Extensions" + } + + dimension: metrics__text2__characteristics_gl_params_v1 { + sql: ${TABLE}.metrics.text2.characteristics_gl_params_v1 ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Gl Params V1" + } + + dimension: metrics__text2__characteristics_gl_params_v2 { + sql: ${TABLE}.metrics.text2.characteristics_gl_params_v2 ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Gl Params V2" + } + + dimension: metrics__text2__characteristics_gl_precision_fragment { + sql: ${TABLE}.metrics.text2.characteristics_gl_precision_fragment ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Gl Precision Fragment" + } + + dimension: metrics__text2__characteristics_gl_precision_vertex { + sql: ${TABLE}.metrics.text2.characteristics_gl_precision_vertex ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Gl Precision Vertex" + } + dimension: metrics__text2__characteristics_ice_foundations { sql: ${TABLE}.metrics.text2.characteristics_ice_foundations ;; type: string @@ -1374,6 +1577,34 @@ group_item_label: "Characteristics Media Capabilities" } + dimension: metrics__text2__characteristics_media_capabilities_h264 { + sql: ${TABLE}.metrics.text2.characteristics_media_capabilities_h264 ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Media Capabilities H264" + } + + dimension: metrics__text2__characteristics_media_capabilities_not_efficient { + sql: ${TABLE}.metrics.text2.characteristics_media_capabilities_not_efficient ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Media Capabilities Not Efficient" + } + + dimension: metrics__text2__characteristics_media_capabilities_not_smooth { + sql: ${TABLE}.metrics.text2.characteristics_media_capabilities_not_smooth ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Media Capabilities Not Smooth" + } + + dimension: metrics__text2__characteristics_media_capabilities_unsupported { + sql: ${TABLE}.metrics.text2.characteristics_media_capabilities_unsupported ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Media Capabilities Unsupported" + } + dimension: metrics__text2__characteristics_media_devices { sql: ${TABLE}.metrics.text2.characteristics_media_devices ;; type: string @@ -1395,6 +1626,20 @@ group_item_label: "Characteristics Voices" } + dimension: metrics__text2__characteristics_voices_sample { + sql: ${TABLE}.metrics.text2.characteristics_voices_sample ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Voices Sample" + } + + dimension: metrics__text2__characteristics_voices_sha1 { + sql: ${TABLE}.metrics.text2.characteristics_voices_sha1 ;; + type: string + group_label: "Metrics Text2" + group_item_label: "Characteristics Voices Sha1" + } + dimension: metrics__text2__characteristics_webglinfo { sql: ${TABLE}.metrics.text2.characteristics_webglinfo ;; type: string diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/fenix/views/user_characteristics.view.lkml /tmp/workspace/generated-lookml/fenix/views/user_characteristics.view.lkml --- /tmp/workspace/looker-hub/fenix/views/user_characteristics.view.lkml 2024-09-19 12:30:09.507191115 +0000 +++ /tmp/workspace/generated-lookml/fenix/views/user_characteristics.view.lkml 2024-09-19 12:26:22.000000000 +0000 @@ -167,6 +167,24 @@ " } + dimension: metrics__quantity__characteristics_camera_count { + label: "Characteristics Camera Count" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_camera_count ;; + type: number + group_label: "Characteristics" + group_item_label: "Camera Count" + + link: { + label: "Glean Dictionary reference for Characteristics Camera Count" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_camera_count" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Number of cameras available on the device. +" + } + dimension: metrics__string__characteristics_canvasdata1 { label: "Characteristics Canvasdata1" hidden: no @@ -1391,6 +1409,330 @@ " } + dimension: metrics__text2__characteristics_gl_extensions { + label: "Characteristics Gl Extensions" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_gl_extensions ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Extensions" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Extensions" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_extensions" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The list of OpenGL extensions supported by the user's system. +" + } + + dimension: metrics__text2__characteristics_gl_extensions_raw { + label: "Characteristics Gl Extensions Raw" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_gl_extensions_raw ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Extensions Raw" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Extensions Raw" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_extensions_raw" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The raw list of OpenGL extensions supported by the user's system. +" + } + + dimension: metrics__string__characteristics_gl_fragment_shader { + label: "Characteristics Gl Fragment Shader" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_gl_fragment_shader ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Fragment Shader" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Fragment Shader" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_fragment_shader" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Hash of the transformed source of the fragment shader. +" + } + + dimension: metrics__text2__characteristics_gl_minimal_source { + label: "Characteristics Gl Minimal Source" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_gl_minimal_source ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Minimal Source" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Minimal Source" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_minimal_source" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Transformed source of the minimal shader. +" + } + + dimension: metrics__text2__characteristics_gl_params_extensions { + label: "Characteristics Gl Params Extensions" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_gl_params_extensions ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Params Extensions" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Params Extensions" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_params_extensions" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The list of GL parameters of the extensions. +" + } + + dimension: metrics__text2__characteristics_gl_params_v1 { + label: "Characteristics Gl Params V1" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_gl_params_v1 ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Params V1" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Params V1" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_params_v1" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The list of GL parameters of GL1. +" + } + + dimension: metrics__text2__characteristics_gl_params_v2 { + label: "Characteristics Gl Params V2" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_gl_params_v2 ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Params V2" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Params V2" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_params_v2" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The list of GL parameters of GL2. +" + } + + dimension: metrics__text2__characteristics_gl_precision_fragment { + label: "Characteristics Gl Precision Fragment" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_gl_precision_fragment ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Precision Fragment" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Precision Fragment" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_precision_fragment" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Precisions of the fragment shader. +" + } + + dimension: metrics__text2__characteristics_gl_precision_vertex { + label: "Characteristics Gl Precision Vertex" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_gl_precision_vertex ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Precision Vertex" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Precision Vertex" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_precision_vertex" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Precisions of the vertex shader. +" + } + + dimension: metrics__string__characteristics_gl_renderer { + label: "Characteristics Gl Renderer" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_gl_renderer ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Renderer" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Renderer" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_renderer" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The OpenGL renderer string. +" + } + + dimension: metrics__string__characteristics_gl_renderer_raw { + label: "Characteristics Gl Renderer Raw" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_gl_renderer_raw ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Renderer Raw" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Renderer Raw" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_renderer_raw" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The raw OpenGL renderer string. +" + } + + dimension: metrics__string__characteristics_gl_vendor { + label: "Characteristics Gl Vendor" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_gl_vendor ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Vendor" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Vendor" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_vendor" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The OpenGL vendor string. +" + } + + dimension: metrics__string__characteristics_gl_vendor_raw { + label: "Characteristics Gl Vendor Raw" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_gl_vendor_raw ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Vendor Raw" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Vendor Raw" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_vendor_raw" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The raw OpenGL vendor string. +" + } + + dimension: metrics__quantity__characteristics_gl_version { + label: "Characteristics Gl Version" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_gl_version ;; + type: number + group_label: "Characteristics" + group_item_label: "Gl Version" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Version" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_version" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The version of OpenGL supported by the user's system. +" + } + + dimension: metrics__string__characteristics_gl_version_raw { + label: "Characteristics Gl Version Raw" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_gl_version_raw ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Version Raw" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Version Raw" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_version_raw" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The raw OpenGL version string. +" + } + + dimension: metrics__string__characteristics_gl_vertex_shader { + label: "Characteristics Gl Vertex Shader" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_gl_vertex_shader ;; + type: string + group_label: "Characteristics" + group_item_label: "Gl Vertex Shader" + + link: { + label: "Glean Dictionary reference for Characteristics Gl Vertex Shader" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_gl_vertex_shader" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Hash of the transformed source of the vertex shader. +" + } + + dimension: metrics__quantity__characteristics_group_count { + label: "Characteristics Group Count" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_group_count ;; + type: number + group_label: "Characteristics" + group_item_label: "Group Count" + + link: { + label: "Glean Dictionary reference for Characteristics Group Count" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_group_count" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Number of device groups reported by the device. +" + } + + dimension: metrics__quantity__characteristics_group_count_wo_speakers { + label: "Characteristics Group Count Wo Speakers" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_group_count_wo_speakers ;; + type: number + group_label: "Characteristics" + group_item_label: "Group Count Wo Speakers" + + link: { + label: "Glean Dictionary reference for Characteristics Group Count Wo Speakers" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_group_count_wo_speakers" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Number of device groups without speakers reported by the device. +" + } + dimension: metrics__text2__characteristics_ice_foundations { label: "Characteristics Ice Foundations" hidden: no @@ -1409,6 +1751,42 @@ " } + dimension: metrics__quantity__characteristics_ice_order { + label: "Characteristics Ice Order" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_ice_order ;; + type: number + group_label: "Characteristics" + group_item_label: "Ice Order" + + link: { + label: "Glean Dictionary reference for Characteristics Ice Order" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_ice_order" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Unique ICE foundations occurrence count +" + } + + dimension: metrics__quantity__characteristics_ice_sd { + label: "Characteristics Ice Sd" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_ice_sd ;; + type: number + group_label: "Characteristics" + group_item_label: "Ice Sd" + + link: { + label: "Glean Dictionary reference for Characteristics Ice Sd" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_ice_sd" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "ICE foundation discovery latency standard deviation sum multiplied by 1000 +" + } + dimension: metrics__quantity__characteristics_inner_height { label: "Characteristics Inner Height" hidden: no @@ -1769,6 +2147,78 @@ " } + dimension: metrics__text2__characteristics_media_capabilities_h264 { + label: "Characteristics Media Capabilities H264" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_media_capabilities_h264 ;; + type: string + group_label: "Characteristics" + group_item_label: "Media Capabilities H264" + + link: { + label: "Glean Dictionary reference for Characteristics Media Capabilities H264" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_media_capabilities_h264" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Levels of support for H264 codec. +" + } + + dimension: metrics__text2__characteristics_media_capabilities_not_efficient { + label: "Characteristics Media Capabilities Not Efficient" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_media_capabilities_not_efficient ;; + type: string + group_label: "Characteristics" + group_item_label: "Media Capabilities Not Efficient" + + link: { + label: "Glean Dictionary reference for Characteristics Media Capabilities Not Efficient" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_media_capabilities_not_efficient" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Which, if any, media types are not power efficient. +" + } + + dimension: metrics__text2__characteristics_media_capabilities_not_smooth { + label: "Characteristics Media Capabilities Not Smooth" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_media_capabilities_not_smooth ;; + type: string + group_label: "Characteristics" + group_item_label: "Media Capabilities Not Smooth" + + link: { + label: "Glean Dictionary reference for Characteristics Media Capabilities Not Smooth" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_media_capabilities_not_smooth" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Which, if any, media types are not smooth. +" + } + + dimension: metrics__text2__characteristics_media_capabilities_unsupported { + label: "Characteristics Media Capabilities Unsupported" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_media_capabilities_unsupported ;; + type: string + group_label: "Characteristics" + group_item_label: "Media Capabilities Unsupported" + + link: { + label: "Glean Dictionary reference for Characteristics Media Capabilities Unsupported" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_media_capabilities_unsupported" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Which, if any, media types are not supported. +" + } + dimension: metrics__text2__characteristics_media_devices { label: "Characteristics Media Devices" hidden: no @@ -1787,6 +2237,24 @@ " } + dimension: metrics__quantity__characteristics_microphone_count { + label: "Characteristics Microphone Count" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_microphone_count ;; + type: number + group_label: "Characteristics" + group_item_label: "Microphone Count" + + link: { + label: "Glean Dictionary reference for Characteristics Microphone Count" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_microphone_count" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Number of microphones available on the device. +" + } + dimension: metrics__text2__characteristics_missing_fonts { label: "Characteristics Missing Fonts" hidden: no @@ -2651,6 +3119,24 @@ " } + dimension: metrics__quantity__characteristics_speaker_count { + label: "Characteristics Speaker Count" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_speaker_count ;; + type: number + group_label: "Characteristics" + group_item_label: "Speaker Count" + + link: { + label: "Glean Dictionary reference for Characteristics Speaker Count" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_speaker_count" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Number of speakers available on the device. +" + } + dimension: metrics__quantity__characteristics_submission_schema { label: "Characteristics Submission Schema" hidden: no @@ -2831,6 +3317,150 @@ " } + dimension: metrics__string__characteristics_voices_all_ssdeep { + label: "Characteristics Voices All Ssdeep" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_voices_all_ssdeep ;; + type: string + group_label: "Characteristics" + group_item_label: "Voices All Ssdeep" + + link: { + label: "Glean Dictionary reference for Characteristics Voices All Ssdeep" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_voices_all_ssdeep" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "ssdeep hash of all speechSynthesis voices. +" + } + + dimension: metrics__quantity__characteristics_voices_count { + label: "Characteristics Voices Count" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_voices_count ;; + type: number + group_label: "Characteristics" + group_item_label: "Voices Count" + + link: { + label: "Glean Dictionary reference for Characteristics Voices Count" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_voices_count" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Number of speechSynthesis voices available to the user. +" + } + + dimension: metrics__string__characteristics_voices_default { + label: "Characteristics Voices Default" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_voices_default ;; + type: string + group_label: "Characteristics" + group_item_label: "Voices Default" + + link: { + label: "Glean Dictionary reference for Characteristics Voices Default" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_voices_default" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "The default speechSynthesis voice. +" + } + + dimension: metrics__quantity__characteristics_voices_local_count { + label: "Characteristics Voices Local Count" + hidden: yes + sql: ${TABLE}.metrics.quantity.characteristics_voices_local_count ;; + type: number + group_label: "Characteristics" + group_item_label: "Voices Local Count" + + link: { + label: "Glean Dictionary reference for Characteristics Voices Local Count" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_voices_local_count" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Number of local speechSynthesis voices available to the user. +" + } + + dimension: metrics__string__characteristics_voices_local_ssdeep { + label: "Characteristics Voices Local Ssdeep" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_voices_local_ssdeep ;; + type: string + group_label: "Characteristics" + group_item_label: "Voices Local Ssdeep" + + link: { + label: "Glean Dictionary reference for Characteristics Voices Local Ssdeep" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_voices_local_ssdeep" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "ssdeep hash of local speechSynthesis voices. +" + } + + dimension: metrics__string__characteristics_voices_nonlocal_ssdeep { + label: "Characteristics Voices Nonlocal Ssdeep" + hidden: yes + sql: ${TABLE}.metrics.string.characteristics_voices_nonlocal_ssdeep ;; + type: string + group_label: "Characteristics" + group_item_label: "Voices Nonlocal Ssdeep" + + link: { + label: "Glean Dictionary reference for Characteristics Voices Nonlocal Ssdeep" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_voices_nonlocal_ssdeep" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "ssdeep hash of non-local speechSynthesis voices. +" + } + + dimension: metrics__text2__characteristics_voices_sample { + label: "Characteristics Voices Sample" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_voices_sample ;; + type: string + group_label: "Characteristics" + group_item_label: "Voices Sample" + + link: { + label: "Glean Dictionary reference for Characteristics Voices Sample" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_voices_sample" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "Names of 5 sample speechSynthesis voices. +" + } + + dimension: metrics__text2__characteristics_voices_sha1 { + label: "Characteristics Voices Sha1" + hidden: yes + sql: ${TABLE}.metrics.text2.characteristics_voices_sha1 ;; + type: string + group_label: "Characteristics" + group_item_label: "Voices Sha1" + + link: { + label: "Glean Dictionary reference for Characteristics Voices Sha1" + url: "https://dictionary.telemetry.mozilla.org/apps/fenix/metrics/characteristics_voices_sha1" + icon_url: "https://dictionary.telemetry.mozilla.org/favicon.png" + } + + description: "SHA1 hash of all the voices. +" + } + dimension: metrics__text2__characteristics_webglinfo { label: "Characteristics Webglinfo" hidden: no diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/firefox_desktop/explores/metrics.explore.lkml /tmp/workspace/generated-lookml/firefox_desktop/explores/metrics.explore.lkml --- /tmp/workspace/looker-hub/firefox_desktop/explores/metrics.explore.lkml 2024-09-19 12:30:09.515191150 +0000 +++ /tmp/workspace/generated-lookml/firefox_desktop/explores/metrics.explore.lkml 2024-09-19 12:28:46.000000000 +0000 @@ -398,6 +398,26 @@ sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_eh_response_version}) AS metrics__metrics__labeled_counter__netwerk_eh_response_version ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_eh_response_version.document_id} ;; } + join: metrics__metrics__labeled_counter__netwerk_http3_0rtt_state { + relationship: one_to_many + sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_http3_0rtt_state}) AS metrics__metrics__labeled_counter__netwerk_http3_0rtt_state ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_http3_0rtt_state.document_id} ;; + } + + join: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_grease { + relationship: one_to_many + sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_http3_ech_outcome_grease}) AS metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_grease ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_grease.document_id} ;; + } + + join: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_none { + relationship: one_to_many + sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_http3_ech_outcome_none}) AS metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_none ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_none.document_id} ;; + } + + join: metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_real { + relationship: one_to_many + sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__netwerk_http3_ech_outcome_real}) AS metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_real ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__netwerk_http3_ech_outcome_real.document_id} ;; + } + join: metrics__metrics__labeled_counter__network_byte_range_request { relationship: one_to_many sql: LEFT JOIN UNNEST(${metrics.metrics__labeled_counter__network_byte_range_request}) AS metrics__metrics__labeled_counter__network_byte_range_request ON ${metrics.document_id} = ${metrics__metrics__labeled_counter__network_byte_range_request.document_id} ;; diff -x '.*' -bur --no-dereference --new-file /tmp/workspace/looker-hub/firefox_desktop/views/clients_first_seen_v2.view.lkml /tmp/workspace/generated-lookml/firefox_desktop/views/clients_first_seen_v2.view.lkml --- /tmp/workspace/looker-hub/firefox_desktop/views/clients_first_seen_v2.view.lkml 2024-09-19 12:30:09.523191185 +0000 +++ /tmp/workspace/generated-lookml/firefox_desktop/views/clients_first_seen_v2.view.lkml 2024-09-19 12:25:40.000000000 +0000 @@ -8,122 +8,146 @@ dimension: app_build_id { sql: ${TABLE}.app_build_id ;; type: string + description: "The application build reported by the client." } dimension: app_name { sql: ${TABLE}.app_name ;; type: string + description: "The name of the installed app/browser." } dimension: app_version { sql: ${TABLE}.app_version ;; type: string + description: "The application version." } dimension: apple_model_id { sql: ${TABLE}.apple_model_id ;; type: string + description: "The model IDs for Apple desktop devices. Applies to Mac only." } dimension: architecture { sql: ${TABLE}.architecture ;; type: string + description: "The application architecture reported by the client." } dimension: attribution_campaign { sql: ${TABLE}.attribution_campaign ;; type: string + description: "Identifier of the particular campaign that led to the download of the product." } dimension: attribution_content { sql: ${TABLE}.attribution_content ;; type: string + description: "Identifier to indicate the particular link within a campaign." } dimension: attribution_dlsource { sql: ${TABLE}.attribution_dlsource ;; type: string + description: "Identifier that indicates where installations of Firefox originated." } dimension: attribution_dltoken { sql: ${TABLE}.attribution_dltoken ;; type: string + description: "Unique token created at Firefox download time." } dimension: attribution_experiment { sql: ${TABLE}.attribution_experiment ;; type: string + description: "Funnel experiment parameters." } dimension: attribution_medium { sql: ${TABLE}.attribution_medium ;; type: string + description: "Category of the source, such as 'organic' for a search engine." } dimension: attribution_source { sql: ${TABLE}.attribution_source ;; type: string + description: "Referring partner domain, when install happens via a known partner." } dimension: attribution_ua { sql: ${TABLE}.attribution_ua ;; type: string + description: "Client's user agent, which corresponds to the web browser used to download the Firefox installer." } dimension: city { sql: ${TABLE}.city ;; type: string + description: "City retrieved as a result of a geographic lookup based on the client's IP address." } dimension: client_id { sql: ${TABLE}.client_id ;; hidden: yes + description: "Unique ID for the client installation." } dimension: country { sql: ${TABLE}.country ;; type: string map_layer_name: countries + description: "The ISO 3166-1 alpha-2 country code." } dimension: db_version { sql: ${TABLE}.db_version ;; type: string + description: "The specific geo database version used." } dimension: distribution_id { sql: ${TABLE}.distribution_id ;; type: string + description: "The value of the `distribution.id` preference that identifies the Firefox distribution." } dimension: document_id { sql: ${TABLE}.document_id ;; hidden: yes + description: "The document ID specified in the URI when the client sent this message." } dimension: engine_data_load_path { sql: ${TABLE}.engine_data_load_path ;; type: string + description: "The anonymized path of the engine xml file. For details on the components refer to the metadata for telemetry.new_profile." } dimension: engine_data_name { sql: ${TABLE}.engine_data_name ;; type: string + description: "The name of the default search engine." } dimension: engine_data_origin { sql: ${TABLE}.engine_data_origin ;; type: string + description: "The origin of the search engine. The value will be default for engines that are built-in or from distribution partners, verified for user-installed engines with valid verification hashes, unverified for non-default engines without verification hash, and invalid for engines with broken verification hashes." } dimension: engine_data_submission_url { sql: ${TABLE}.engine_data_submission_url ;; type: string + description: "The HTTP url we would use to search. For privacy, we don’t record this for user-installed engines." } dimension: locale { sql: ${TABLE}.locale ;; type: string + description: "The best locale that the application should be localized to." } dimension: metadata__first_seen_date_source_ping { @@ -131,6 +155,7 @@ type: string group_label: "Metadata" group_item_label: "First Seen Date Source Ping" + description: "Ping that reported the first seen date (main, first_shutdown or new_profile)." } dimension: metadata__reported_main_ping { @@ -138,6 +163,7 @@ type: yesno group_label: "Metadata" group_item_label: "Reported Main Ping" + description: "Indicates wether the client ever reported a main ping." } dimension: metadata__reported_new_profile_ping { @@ -145,6 +171,7 @@ type: yesno group_label: "Metadata" group_item_label: "Reported New Profile Ping" + description: "Indicates wether the client ever reported a new profile ping." } dimension: metadata__reported_shutdown_ping { @@ -152,76 +179,91 @@ type: yesno group_label: "Metadata" group_item_label: "Reported Shutdown Ping" + description: "Indicates wether the client ever reported a first shutdown ping." } dimension: normalized_channel { sql: ${TABLE}.normalized_channel ;; type: string + description: "The Firefox channel, set to Other for unrecognized channel names." } dimension: normalized_os { sql: ${TABLE}.normalized_os ;; type: string + description: "The OS name, set to Other for unrecognized OS names." } dimension: normalized_os_version { sql: ${TABLE}.normalized_os_version ;; type: string + description: "The OS version." } dimension: partner_distribution_version { sql: ${TABLE}.partner_distribution_version ;; type: string + description: "The value selected for the `distribution.version` preference in the Partner Distribution Configuration File." } dimension: partner_distributor { sql: ${TABLE}.partner_distributor ;; type: string + description: "The value of the `app.distributor` preference in the Partner Distribution Configuration File." } dimension: partner_distributor_channel { sql: ${TABLE}.partner_distributor_channel ;; type: string + description: "The value of the `app.distributor.channel` preference in the Partner Distribution Configuration File." } dimension: partner_id { sql: ${TABLE}.partner_id ;; type: string + description: "The value of the `mozilla.partner.id` preference in the Partner Distribution Configuration File." } dimension: platform_version { sql: ${TABLE}.platform_version ;; type: string + description: "The appliction platform version reported by the client." } dimension: profile_group_id { sql: ${TABLE}.profile_group_id ;; type: string + description: "A UUID identifying the profile's group on a single device and allowing user-oriented correlation of data" } dimension: sample_id { sql: ${TABLE}.sample_id ;; type: number + description: "Sample ID to limit query results during an analysis." } dimension: startup_profile_selection_reason { sql: ${TABLE}.startup_profile_selection_reason ;; type: string + description: "How the profile was selected during startup. Possible reasons are: unknown: Generally should not happen, set as a default in case no other reason occurred. profile-manager: The profile was selected by the profile manager. profile-reset: The profile was selected for reset, normally this would mean a restart. restart: The user restarted the application, the same profile as previous will be used. argument-profile: The profile was selected by the --profile command line argument. argument-p: The profile was selected by the -p command line argument. firstrun-claimed-default: A first run of a dedicated profiles build chose the old default profile to be the default for this install. firstrun-skipped-default: A first run of a dedicated profiles build skipped over the old default profile and created a new profile. restart-claimed-default: A first run of a dedicated profiles build after a restart chose the old default." } dimension: ```

⚠️ Only part of the diff is displayed.

Link to full diff