Bugzilla

I created tables `normalized_os_name` and `normalized_os_version` in the static dataset in derived datasets and shared prod.  To get the normalized os version you would need to do something like 
```
...
FROM
  `moz-fx-data-shared-prod.telemetry_stable.main_v4`
RIGHT JOIN
  `static.normalized_os_version` norm_os
ON
  (environment.system.os.name = norm_os.os_name
  AND REGEXP_CONTAINS(environment.system.os.version, norm_os.os_version))
```
This is a bit awkward because UDFs don't allow reading from a table.  Chris, is this way good enough for your use case?

Also the plan is to keep the table as a csv in `bigquery-etl` so it will be easy to change.

I created tables `normalized_os_name` and `normalized_os_version` in the static dataset in derived datasets and shared prod.  To get the normalized os version you would need to do something like 
```
...
FROM
  `moz-fx-data-shared-prod.telemetry_stable.main_v4`
LEFT JOIN
  `static.normalized_os_version` norm_os
ON
  (environment.system.os.name = norm_os.os_name
  AND REGEXP_CONTAINS(environment.system.os.version, norm_os.os_version))
```
This is a bit awkward because UDFs don't allow reading from a table.  Chris, is this way good enough for your use case?

Also the plan is to keep the table as a csv in `bigquery-etl` so it will be easy to change.