bigquery_etl/glam/templates/clients_scalar_aggregates_v1.init.sql

{{ header }}
CREATE TABLE IF NOT EXISTS
  `{{ project }}.{{ destination_table }}`(
    {{ attributes_type }},
    scalar_aggregates {{ user_data_type }}
  )
PARTITION BY
  RANGE_BUCKET(app_version, GENERATE_ARRAY(0, 200, 1))
CLUSTER BY
  app_version,
  channel,
  client_id