mozilla / bigquery-etl

Bigquery ETL
https://mozilla.github.io/bigquery-etl
Mozilla Public License 2.0
249 stars 98 forks source link

Use Glean repositories config from probe-info service for logical app names and channels #1466

Open jklukas opened 3 years ago

jklukas commented 3 years ago

The JSON configuration file at https://probeinfo.telemetry.mozilla.org/glean/repositories contains deprecation status, channel, and "description" giving a logical app name like "Firefox for iOS".

We should consume that configuration as a source of truth for generating views such as nondesktop_clients_last_seen where we are currently identifying Fenix channels by hand.

We could also use this configuration while generating user-facing views on top of the historical ping tables. We could inject description as normalized_app_name, channel as normalized_channel, etc.

jklukas commented 3 years ago

We now do this for baseline_clients_* views in bqetl glean_usage generate