search

mozilla / bigquery-etl

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

Don't aggregate by latest_version in clients_histogram_aggregates for glam desktop #901

Closed emtwo closed 10 months ago

emtwo commented 4 years ago

When the latest version changes, this causes data that should be merged together for a given set of dimensions to be aggregated separately.

emtwo commented 4 years ago

The correct aggregation is correctly done in the next step, but this could save a few rows in clients_histogram_aggregates if we don't aggregate using latest_version

emtwo commented 3 years ago

For reference: https://github.com/mozilla/bigquery-etl/blob/main/sql/moz-fx-data-shared-prod/telemetry_derived/clients_histogram_aggregates_v1/query.sql