sql_generators/glean_usage/templates/baseline_clients_daily_v1.schema.yaml

fields:
- mode: NULLABLE
  name: submission_date
  type: DATE
- mode: NULLABLE
  name: client_id
  type: STRING
- mode: NULLABLE
  name: sample_id
  type: INTEGER
- mode: NULLABLE
  name: first_run_date
  type: DATE
- mode: NULLABLE
  name: durations
  type: INTEGER
- mode: NULLABLE
  name: days_seen_session_start_bits
  type: INTEGER
- mode: NULLABLE
  name: days_seen_session_end_bits
  type: INTEGER
- mode: NULLABLE
  name: normalized_channel
  type: STRING
- mode: NULLABLE
  name: normalized_os
  type: STRING
- mode: NULLABLE
  name: normalized_os_version
  type: STRING
- mode: NULLABLE
  name: android_sdk_version
  type: STRING
- mode: NULLABLE
  name: locale
  type: STRING
- mode: NULLABLE
  name: city
  type: STRING
- mode: NULLABLE
  name: country
  type: STRING
- mode: NULLABLE
  name: app_build
  type: STRING
- mode: NULLABLE
  name: app_channel
  type: STRING
- mode: NULLABLE
  name: app_display_version
  type: STRING
- mode: NULLABLE
  name: architecture
  type: STRING
- mode: NULLABLE
  name: device_manufacturer
  type: STRING
- mode: NULLABLE
  name: device_model
  type: STRING
- mode: NULLABLE
  name: telemetry_sdk_build
  type: STRING
- mode: NULLABLE
  name: first_seen_date
  type: DATE
- mode: NULLABLE
  name: is_new_profile
  type: BOOLEAN
- mode: NULLABLE
  name: isp
  type: STRING
- mode: NULLABLE
  name: distribution_id
  type: STRING
- mode: NULLABLE
  name: geo_subdivision
  type: STRING
- mode: NULLABLE
  name: profile_group_id
  type: STRING
- mode: NULLABLE
  name: install_source
  type: STRING
- mode: NULLABLE
  name: windows_build_number
  type: INTEGER
- mode: NULLABLE
  name: browser_engagement_uri_count
  type: INTEGER
- mode: NULLABLE
  name: browser_engagement_active_ticks
  type: INTEGER
- mode: NULLABLE
  name: legacy_telemetry_client_id
  type: STRING
- mode: NULLABLE
  name: is_default_browser
  type: BOOLEAN
- mode: NULLABLE
  name: attribution
  type: RECORD
  fields:
  - mode: NULLABLE
    name: campaign
    type: STRING
    description: The attribution campaign (e.g. 'mozilla-org').
  - mode: NULLABLE
    name: content
    type: STRING
    description: The attribution content (e.g. 'firefoxview').
  - mode: NULLABLE
    name: medium
    type: STRING
    description: The attribution medium (e.g. 'organic' for a search engine).
  - mode: NULLABLE
    name: source
    type: STRING
    description: The attribution source (e.g. 'google-play').
  - mode: NULLABLE
    name: term
    type: STRING
    description: The attribution term (e.g. 'browser with developer tools for android').
- mode: NULLABLE
  name: distribution
  type: RECORD
  fields:
  - mode: NULLABLE
    name: name
    type: STRING
    description: The distribution name (e.g. 'MozillaOnline').