discovery.view.lkml

view: discovery {
  dimension: additional_properties {
    sql: ${TABLE}.additional_properties ;;
    type: string
  }

  dimension: client_info__android_sdk_version {
    sql: ${TABLE}.client_info.android_sdk_version ;;
    type: string
    group_label: "Client Info"
    group_item_label: "Android Sdk Version"
  }

  dimension: client_info__app_build {
    sql: ${TABLE}.client_info.app_build ;;
    type: string
    group_label: "Client Info"
    group_item_label: "App Build"
  }

  dimension: client_info__app_channel {
    sql: ${TABLE}.client_info.app_channel ;;
    type: string
    group_label: "Client Info"
    group_item_label: "App Channel"
  }

  dimension: client_info__app_display_version {
    sql: ${TABLE}.client_info.app_display_version ;;
    type: string
    group_label: "Client Info"
    group_item_label: "App Display Version"
  }

  dimension: client_info__architecture {
    sql: ${TABLE}.client_info.architecture ;;
    type: string
    group_label: "Client Info"
    group_item_label: "Architecture"
  }

  dimension: client_info__client_id {
    sql: ${TABLE}.client_info.client_id ;;
    hidden: yes
  }

  dimension: client_info__device_manufacturer {
    sql: ${TABLE}.client_info.device_manufacturer ;;
    type: string
    group_label: "Client Info"
    group_item_label: "Device Manufacturer"
  }

  dimension: client_info__device_model {
    sql: ${TABLE}.client_info.device_model ;;
    type: string
    group_label: "Client Info"
    group_item_label: "Device Model"
  }

  dimension: client_info__first_run_date {
    sql: ${TABLE}.client_info.first_run_date ;;
    type: string
    group_label: "Client Info"
    group_item_label: "First Run Date"
  }

  dimension: client_info__locale {
    sql: ${TABLE}.client_info.locale ;;
    type: string
    group_label: "Client Info"
    group_item_label: "Locale"
  }

  dimension: client_info__os {
    sql: ${TABLE}.client_info.os ;;
    type: string
    group_label: "Client Info"
    group_item_label: "Os"
  }

  dimension: client_info__os_version {
    sql: ${TABLE}.client_info.os_version ;;
    type: string
    group_label: "Client Info"
    group_item_label: "Os Version"
  }

  dimension: client_info__telemetry_sdk_build {
    sql: ${TABLE}.client_info.telemetry_sdk_build ;;
    type: string
    group_label: "Client Info"
    group_item_label: "Telemetry Sdk Build"
  }

  dimension: document_id {
    sql: ${TABLE}.document_id ;;
    hidden: yes
  }

  dimension: events {
    sql: ${TABLE}.events ;;
    hidden: yes
  }

  dimension: metadata__geo__city {
    sql: ${TABLE}.metadata.geo.city ;;
    type: string
    group_label: "Metadata Geo"
    group_item_label: "City"
  }

  dimension: metadata__geo__country {
    sql: ${TABLE}.metadata.geo.country ;;
    type: string
    group_label: "Metadata Geo"
    group_item_label: "Country"
    map_layer_name: countries
  }

  dimension: metadata__geo__db_version {
    sql: ${TABLE}.metadata.geo.db_version ;;
    type: string
    group_label: "Metadata Geo"
    group_item_label: "Db Version"
  }

  dimension: metadata__geo__subdivision1 {
    sql: ${TABLE}.metadata.geo.subdivision1 ;;
    type: string
    group_label: "Metadata Geo"
    group_item_label: "Subdivision1"
  }

  dimension: metadata__geo__subdivision2 {
    sql: ${TABLE}.metadata.geo.subdivision2 ;;
    type: string
    group_label: "Metadata Geo"
    group_item_label: "Subdivision2"
  }

  dimension: metadata__header__date {
    sql: ${TABLE}.metadata.header.date ;;
    type: string
    group_label: "Metadata Header"
    group_item_label: "Date"
  }

  dimension: metadata__header__dnt {
    sql: ${TABLE}.metadata.header.dnt ;;
    type: string
    group_label: "Metadata Header"
    group_item_label: "Dnt"
  }

  dimension: metadata__header__parsed_x_source_tags {
    sql: ${TABLE}.metadata.header.parsed_x_source_tags ;;
    hidden: yes
  }

  dimension: metadata__header__x_debug_id {
    sql: ${TABLE}.metadata.header.x_debug_id ;;
    type: string
    group_label: "Metadata Header"
    group_item_label: "X Debug Id"
  }

  dimension: metadata__header__x_pingsender_version {
    sql: ${TABLE}.metadata.header.x_pingsender_version ;;
    type: string
    group_label: "Metadata Header"
    group_item_label: "X Pingsender Version"
  }

  dimension: metadata__header__x_source_tags {
    sql: ${TABLE}.metadata.header.x_source_tags ;;
    type: string
    group_label: "Metadata Header"
    group_item_label: "X Source Tags"
  }

  dimension: metadata__isp__db_version {
    sql: ${TABLE}.metadata.isp.db_version ;;
    type: string
    group_label: "Metadata Isp"
    group_item_label: "Db Version"
  }

  dimension: metadata__isp__name {
    sql: ${TABLE}.metadata.isp.name ;;
    type: string
    group_label: "Metadata Isp"
    group_item_label: "Name"
  }

  dimension: metadata__isp__organization {
    sql: ${TABLE}.metadata.isp.organization ;;
    type: string
    group_label: "Metadata Isp"
    group_item_label: "Organization"
  }

  dimension: metadata__user_agent__browser {
    sql: ${TABLE}.metadata.user_agent.browser ;;
    type: string
    group_label: "Metadata User Agent"
    group_item_label: "Browser"
  }

  dimension: metadata__user_agent__os {
    sql: ${TABLE}.metadata.user_agent.os ;;
    type: string
    group_label: "Metadata User Agent"
    group_item_label: "Os"
  }

  dimension: metadata__user_agent__version {
    sql: ${TABLE}.metadata.user_agent.version ;;
    type: string
    group_label: "Metadata User Agent"
    group_item_label: "Version"
  }

  dimension: metrics__jwe {
    sql: ${TABLE}.metrics.jwe ;;
    hidden: yes

    link: {
      label: "Glean Dictionary reference for jwe"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/jwe"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__labeled_counter__glean_error_invalid_label {
    sql: ${TABLE}.metrics.labeled_counter.glean_error_invalid_label ;;
    hidden: yes

    link: {
      label: "Glean Dictionary reference for glean_error_invalid_label"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/glean_error_invalid_label"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__labeled_counter__glean_error_invalid_overflow {
    sql: ${TABLE}.metrics.labeled_counter.glean_error_invalid_overflow ;;
    hidden: yes

    link: {
      label: "Glean Dictionary reference for glean_error_invalid_overflow"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/glean_error_invalid_overflow"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__labeled_counter__glean_error_invalid_state {
    sql: ${TABLE}.metrics.labeled_counter.glean_error_invalid_state ;;
    hidden: yes

    link: {
      label: "Glean Dictionary reference for glean_error_invalid_state"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/glean_error_invalid_state"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__labeled_counter__glean_error_invalid_value {
    sql: ${TABLE}.metrics.labeled_counter.glean_error_invalid_value ;;
    hidden: yes

    link: {
      label: "Glean Dictionary reference for glean_error_invalid_value"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/glean_error_invalid_value"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__labeled_counter__technology_space_travel {
    sql: ${TABLE}.metrics.labeled_counter.technology_space_travel ;;
    hidden: yes

    link: {
      label: "Glean Dictionary reference for technology_space_travel"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/technology_space_travel"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__labeled_counter__test_burnham_space_travel {
    sql: ${TABLE}.metrics.labeled_counter.test_burnham_space_travel ;;
    hidden: yes

    link: {
      label: "Glean Dictionary reference for test_burnham_space_travel"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/test_burnham_space_travel"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__labeled_rate {
    sql: ${TABLE}.metrics.labeled_rate ;;
    hidden: yes

    link: {
      label: "Glean Dictionary reference for labeled_rate"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/labeled_rate"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__string__mission_identifier {
    sql: ${TABLE}.metrics.string.mission_identifier ;;
    type: string
    group_label: "Metrics String"
    group_item_label: "Mission Identifier"

    link: {
      label: "Glean Dictionary reference for mission_identifier"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/mission_identifier"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__string__mission_status {
    sql: ${TABLE}.metrics.string.mission_status ;;
    type: string
    group_label: "Metrics String"
    group_item_label: "Mission Status"

    link: {
      label: "Glean Dictionary reference for mission_status"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/mission_status"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__string__test_burnham_mission {
    sql: ${TABLE}.metrics.string.test_burnham_mission ;;
    type: string
    group_label: "Metrics String"
    group_item_label: "Test Burnham Mission"

    link: {
      label: "Glean Dictionary reference for test_burnham_mission"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/test_burnham_mission"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__string__test_burnham_position {
    sql: ${TABLE}.metrics.string.test_burnham_position ;;
    type: string
    group_label: "Metrics String"
    group_item_label: "Test Burnham Position"

    link: {
      label: "Glean Dictionary reference for test_burnham_position"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/test_burnham_position"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__string__test_burnham_status {
    sql: ${TABLE}.metrics.string.test_burnham_status ;;
    type: string
    group_label: "Metrics String"
    group_item_label: "Test Burnham Status"

    link: {
      label: "Glean Dictionary reference for test_burnham_status"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/test_burnham_status"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__string__test_burnham_test_name {
    sql: ${TABLE}.metrics.string.test_burnham_test_name ;;
    type: string
    group_label: "Metrics String"
    group_item_label: "Test Burnham Test Name"

    link: {
      label: "Glean Dictionary reference for test_burnham_test_name"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/test_burnham_test_name"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__string__test_name {
    sql: ${TABLE}.metrics.string.test_name ;;
    type: string
    group_label: "Metrics String"
    group_item_label: "Test Name"

    link: {
      label: "Glean Dictionary reference for test_name"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/test_name"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__uuid__test_burnham_test_run {
    sql: ${TABLE}.metrics.uuid.test_burnham_test_run ;;
    type: string
    group_label: "Metrics Uuid"
    group_item_label: "Test Burnham Test Run"

    link: {
      label: "Glean Dictionary reference for test_burnham_test_run"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/test_burnham_test_run"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: metrics__uuid__test_run {
    sql: ${TABLE}.metrics.uuid.test_run ;;
    type: string
    group_label: "Metrics Uuid"
    group_item_label: "Test Run"

    link: {
      label: "Glean Dictionary reference for test_run"
      url: "https://dictionary.protosaur.dev/apps/burnham/metrics/test_run"
      icon_url: "https://dictionary.protosaur.dev/favicon.png"
    }
  }

  dimension: normalized_app_name {
    sql: ${TABLE}.normalized_app_name ;;
    type: string
  }

  dimension: normalized_channel {
    sql: ${TABLE}.normalized_channel ;;
    type: string
  }

  dimension: normalized_country_code {
    sql: ${TABLE}.normalized_country_code ;;
    type: string
  }

  dimension: normalized_os {
    sql: ${TABLE}.normalized_os ;;
    type: string
  }

  dimension: normalized_os_version {
    sql: ${TABLE}.normalized_os_version ;;
    type: string
  }

  dimension: ping_info__end_time {
    sql: ${TABLE}.ping_info.end_time ;;
    type: string
    group_label: "Ping Info"
    group_item_label: "End Time"
  }

  dimension: ping_info__experiments {
    sql: ${TABLE}.ping_info.experiments ;;
    hidden: yes
  }

  dimension: ping_info__ping_type {
    sql: ${TABLE}.ping_info.ping_type ;;
    type: string
    group_label: "Ping Info"
    group_item_label: "Ping Type"
  }

  dimension: ping_info__reason {
    sql: ${TABLE}.ping_info.reason ;;
    type: string
    group_label: "Ping Info"
    group_item_label: "Reason"
  }

  dimension: ping_info__seq {
    sql: ${TABLE}.ping_info.seq ;;
    type: number
    group_label: "Ping Info"
    group_item_label: "Seq"
  }

  dimension: ping_info__start_time {
    sql: ${TABLE}.ping_info.start_time ;;
    type: string
    group_label: "Ping Info"
    group_item_label: "Start Time"
  }

  dimension: sample_id {
    sql: ${TABLE}.sample_id ;;
    type: number
  }

  dimension_group: metadata__header__parsed {
    sql: ${TABLE}.metadata.header.parsed_date ;;
    type: time
    timeframes: [
      raw,
      time,
      date,
      week,
      month,
      quarter,
      year,
    ]
    group_label: "Metadata Header"
    group_item_label: "Parsed Date"
  }

  dimension_group: ping_info__parsed_end {
    sql: ${TABLE}.ping_info.parsed_end_time ;;
    type: time
    timeframes: [
      raw,
      time,
      date,
      week,
      month,
      quarter,
      year,
    ]
    group_label: "Ping Info"
    group_item_label: "Parsed End Time"
  }

  dimension_group: ping_info__parsed_start {
    sql: ${TABLE}.ping_info.parsed_start_time ;;
    type: time
    timeframes: [
      raw,
      time,
      date,
      week,
      month,
      quarter,
      year,
    ]
    group_label: "Ping Info"
    group_item_label: "Parsed Start Time"
  }

  dimension_group: submission {
    sql: ${TABLE}.submission_timestamp ;;
    type: time
    timeframes: [
      raw,
      time,
      date,
      week,
      month,
      quarter,
      year,
    ]
  }

  measure: clients {
    type: count_distinct
    sql: ${client_info__client_id} ;;
  }

  measure: ping_count {
    type: count
  }

  sql_table_name: `mozdata.burnham.discovery` ;;
}