bigquery_etl/glam/templates/view_clients_daily_scalar_aggregates_v1.sql

{{ header }}
-- View to union daily scalar aggregates with date partitioning
CREATE OR REPLACE VIEW
  `{{ project }}.{{ dataset }}.{{ prefix }}__view_clients_daily_scalar_aggregates_v1`
AS
SELECT
  * EXCEPT (submission_date),
  DATE(_PARTITIONTIME) AS submission_date
FROM
  `{{ project }}.{{ dataset }}.{{ prefix }}__clients_daily_scalar_aggregates*`