bigquery_etl/glam/templates/view_probe_counts_v1.sql (19 lines of code) (raw):
{{ header }}
CREATE OR REPLACE VIEW
`{{ project }}.{{ dataset }}.{{ prefix }}__view_probe_counts_v1`
AS
WITH all_counts AS (
SELECT
*
FROM
`{{ project }}.{{ dataset }}.{{ prefix }}__scalar_probe_counts_v1`
UNION ALL
SELECT
*
FROM
`{{ project }}.{{ dataset }}.{{ prefix }}__histogram_probe_counts_v1`
)
SELECT
*
FROM
all_counts