dataops-ci-bot
commented
4 days ago Integration report for "DENG-4175 fix formatting of UDF SQL"
sql.diff
Click to expand!
```diff Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/udf: organic_vs_paid_desktop Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/udf: organic_vs_paid_mobile diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_histogram_aggregates_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_histogram_aggregates_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_histogram_aggregates_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_histogram_aggregates_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -20,6 +20,6 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_histogram_aggregates_v1 - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__latest_versions_v1 - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_clients_daily_histogram_aggregates_v1 + - glam_etl.firefox_desktop_glam_nightly__clients_histogram_aggregates_v1 + - glam_etl.firefox_desktop_glam_nightly__latest_versions_v1 + - glam_etl.firefox_desktop_glam_nightly__view_clients_daily_histogram_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_histogram_aggregates_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_histogram_aggregates_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_histogram_aggregates_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_histogram_aggregates_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -60,7 +60,7 @@ SELECT * FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_histogram_aggregates_v1` + glam_etl.firefox_desktop_glam_nightly__clients_histogram_aggregates_v1 WHERE sample_id >= @min_sample_id AND sample_id <= @max_sample_id @@ -78,7 +78,7 @@ FROM extracted_accumulated LEFT JOIN - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__latest_versions_v1` + glam_etl.firefox_desktop_glam_nightly__latest_versions_v1 USING (channel) WHERE -- allow for builds to be slighly ahead of the current submission date, to @@ -98,7 +98,7 @@ CAST(app_version AS INT64) AS app_version, unnested_histogram_aggregates AS histogram_aggregates FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_clients_daily_histogram_aggregates_v1`, + glam_etl.firefox_desktop_glam_nightly__view_clients_daily_histogram_aggregates_v1, UNNEST(histogram_aggregates) unnested_histogram_aggregates WHERE submission_date = @submission_date @@ -118,7 +118,7 @@ FROM extracted_daily LEFT JOIN - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__latest_versions_v1` + glam_etl.firefox_desktop_glam_nightly__latest_versions_v1 USING (channel) WHERE -- allow for builds to be slighly ahead of the current submission date, to diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_scalar_aggregates_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_scalar_aggregates_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_scalar_aggregates_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_scalar_aggregates_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -20,6 +20,6 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__latest_versions_v1 - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1 + - glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 + - glam_etl.firefox_desktop_glam_nightly__latest_versions_v1 + - glam_etl.firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_scalar_aggregates_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_scalar_aggregates_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_scalar_aggregates_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__clients_scalar_aggregates_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -89,7 +89,7 @@ SELECT * FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1` + glam_etl.firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1 WHERE submission_date = @submission_date ), @@ -131,7 +131,7 @@ FROM filtered_aggregates AS scalar_aggs LEFT JOIN - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__latest_versions_v1` + glam_etl.firefox_desktop_glam_nightly__latest_versions_v1 USING (channel) WHERE -- allow for builds to be slighly ahead of the current submission date, to @@ -212,9 +212,9 @@ scalar_aggs.channel, scalar_aggregates FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1` AS scalar_aggs + glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 AS scalar_aggs LEFT JOIN - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__latest_versions_v1` + glam_etl.firefox_desktop_glam_nightly__latest_versions_v1 USING (channel) WHERE -- allow for builds to be slighly ahead of the current submission date, to diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_probe_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_probe_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_probe_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_probe_counts_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_probe_counts_v1 + - glam_etl.firefox_desktop_glam_nightly__view_probe_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_probe_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_probe_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_probe_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_probe_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -23,7 +23,7 @@ IF(agg_type = "percentiles", mozfun.glam.histogram_cast_json(aggregates), NULL) ) AS percentiles, FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_probe_counts_v1` + `glam_etl.firefox_desktop_glam_nightly__view_probe_counts_v1` WHERE total_users > 10 GROUP BY diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_user_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_user_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_user_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_user_counts_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_user_counts_v1 + - glam_etl.firefox_desktop_glam_nightly__view_user_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_user_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_user_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_user_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__extract_user_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -13,7 +13,7 @@ total_users DESC ) AS rank FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_user_counts_v1` + `glam_etl.firefox_desktop_glam_nightly__view_user_counts_v1` ) SELECT channel, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_bucket_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_bucket_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_bucket_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_bucket_counts_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_histogram_aggregates_v1 + - glam_etl.firefox_desktop_glam_nightly__clients_histogram_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_bucket_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_bucket_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_bucket_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_bucket_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -29,7 +29,7 @@ COALESCE(combo.os, table.os) AS os, COALESCE(combo.app_build_id, table.app_build_id) AS app_build_id FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_histogram_aggregates_v1` table + glam_etl.firefox_desktop_glam_nightly__clients_histogram_aggregates_v1 table CROSS JOIN static_combos combo ), diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_percentiles_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_percentiles_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_percentiles_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_percentiles_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__histogram_probe_counts_v1 + - glam_etl.firefox_desktop_glam_nightly__histogram_probe_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_percentiles_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_percentiles_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_percentiles_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_percentiles_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -11,4 +11,4 @@ ('99.9', mozfun.glam.percentile(99.9, aggregates, metric_type)) ] AS aggregates FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__histogram_probe_counts_v1` + glam_etl.firefox_desktop_glam_nightly__histogram_probe_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_probe_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_probe_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_probe_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_probe_counts_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__histogram_bucket_counts_v1 + - glam_etl.firefox_desktop_glam_nightly__histogram_bucket_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_probe_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_probe_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_probe_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__histogram_probe_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -56,7 +56,7 @@ CAST(ROUND(SUM(record.value)) AS INT64) ) AS aggregates FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__histogram_bucket_counts_v1` + glam_etl.firefox_desktop_glam_nightly__histogram_bucket_counts_v1 GROUP BY ping_type, os, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__latest_versions_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__latest_versions_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__latest_versions_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__latest_versions_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1 + - glam_etl.firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__latest_versions_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__latest_versions_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__latest_versions_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__latest_versions_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -5,7 +5,7 @@ channel, app_version FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1` + glam_etl.firefox_desktop_glam_nightly__view_clients_daily_scalar_aggregates_v1 WHERE submission_date BETWEEN DATE_SUB(@submission_date, INTERVAL 28 DAY) diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_bucket_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_bucket_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_bucket_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_bucket_counts_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 + - glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_bucket_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_bucket_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_bucket_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_bucket_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -104,7 +104,7 @@ COALESCE(combo.os, table.os) AS os, COALESCE(combo.app_build_id, table.app_build_id) AS app_build_id FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1` table + glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 table CROSS JOIN static_combos combo ), diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_percentiles_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_percentiles_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_percentiles_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_percentiles_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 + - glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_percentiles_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_percentiles_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_percentiles_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_percentiles_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -3,7 +3,7 @@ SELECT * EXCEPT (scalar_aggregates) FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1` + glam_etl.firefox_desktop_glam_nightly__clients_scalar_aggregates_v1 CROSS JOIN UNNEST(scalar_aggregates) ), diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_probe_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_probe_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_probe_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_probe_counts_v1/metadata.yaml 2024-06-27 16:56:41.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__scalar_bucket_counts_v1 + - glam_etl.firefox_desktop_glam_nightly__scalar_bucket_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_probe_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_probe_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_probe_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/firefox_desktop_glam_nightly__scalar_probe_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -31,7 +31,7 @@ SUM(count) ) AS aggregates FROM - `glam-fenix-dev.glam_etl.firefox_desktop_glam_nightly__scalar_bucket_counts_v1` + glam_etl.firefox_desktop_glam_nightly__scalar_bucket_counts_v1 GROUP BY ping_type, os, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -20,6 +20,6 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1 - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1 - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_histogram_aggregates_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_histogram_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -60,7 +60,7 @@ SELECT * FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1` + glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1 WHERE sample_id >= @min_sample_id AND sample_id <= @max_sample_id @@ -78,7 +78,7 @@ FROM extracted_accumulated LEFT JOIN - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1` + glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1 USING (channel) WHERE -- allow for builds to be slighly ahead of the current submission date, to @@ -98,7 +98,7 @@ CAST(app_version AS INT64) AS app_version, unnested_histogram_aggregates AS histogram_aggregates FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_histogram_aggregates_v1`, + glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_histogram_aggregates_v1, UNNEST(histogram_aggregates) unnested_histogram_aggregates WHERE submission_date = @submission_date @@ -118,7 +118,7 @@ FROM extracted_daily LEFT JOIN - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1` + glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1 USING (channel) WHERE -- allow for builds to be slighly ahead of the current submission date, to diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -10,6 +10,6 @@ init.sql: - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1 - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -89,7 +89,7 @@ SELECT * FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1` + glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1 WHERE submission_date = @submission_date ), @@ -131,7 +131,7 @@ FROM filtered_aggregates AS scalar_aggs LEFT JOIN - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1` + glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1 USING (channel) WHERE -- allow for builds to be slighly ahead of the current submission date, to @@ -212,9 +212,9 @@ scalar_aggs.channel, scalar_aggregates FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1` AS scalar_aggs + glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 AS scalar_aggs LEFT JOIN - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1` + glam_etl.org_mozilla_fenix_glam_nightly__latest_versions_v1 USING (channel) WHERE -- allow for builds to be slighly ahead of the current submission date, to diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_probe_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_probe_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_probe_counts_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_probe_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_probe_counts_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__view_probe_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_probe_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_probe_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_probe_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_probe_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -23,7 +23,7 @@ IF(agg_type = "percentiles", mozfun.glam.histogram_cast_json(aggregates), NULL) ) AS percentiles, FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_probe_counts_v1` + `glam_etl.org_mozilla_fenix_glam_nightly__view_probe_counts_v1` WHERE total_users > 10 GROUP BY diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_user_counts_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__view_user_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__extract_user_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -13,7 +13,7 @@ total_users DESC ) AS rank FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_user_counts_v1` + `glam_etl.org_mozilla_fenix_glam_nightly__view_user_counts_v1` ) SELECT channel, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -29,7 +29,7 @@ COALESCE(combo.os, table.os) AS os, COALESCE(combo.app_build_id, table.app_build_id) AS app_build_id FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1` table + glam_etl.org_mozilla_fenix_glam_nightly__clients_histogram_aggregates_v1 table CROSS JOIN static_combos combo ), diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_percentiles_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_percentiles_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_percentiles_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_percentiles_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_percentiles_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_percentiles_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_percentiles_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_percentiles_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -9,4 +9,4 @@ ('95', mozfun.glam.percentile(95, aggregates, metric_type)) ] AS aggregates FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1` + glam_etl.org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__histogram_probe_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -56,7 +56,7 @@ CAST(ROUND(SUM(record.value)) AS INT64) ) AS aggregates FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1` + glam_etl.org_mozilla_fenix_glam_nightly__histogram_bucket_counts_v1 GROUP BY ping_type, os, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__latest_versions_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -5,7 +5,7 @@ channel, app_version FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1` + glam_etl.org_mozilla_fenix_glam_nightly__view_clients_daily_scalar_aggregates_v1 WHERE submission_date BETWEEN DATE_SUB(@submission_date, INTERVAL 28 DAY) diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -79,7 +79,7 @@ app_build_id, channel, FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1` + glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 GROUP BY app_build_id, channel @@ -90,7 +90,7 @@ SELECT * FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1` + glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 INNER JOIN build_ids USING (app_build_id, channel) diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_percentiles_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_percentiles_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_percentiles_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_percentiles_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_percentiles_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_percentiles_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_percentiles_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_percentiles_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -3,7 +3,7 @@ SELECT * EXCEPT (scalar_aggregates) FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1` + glam_etl.org_mozilla_fenix_glam_nightly__clients_scalar_aggregates_v1 CROSS JOIN UNNEST(scalar_aggregates) ), diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/metadata.yaml /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/metadata.yaml 2024-06-27 16:56:44.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/metadata.yaml 2024-06-27 16:56:42.000000000 +0000 @@ -8,4 +8,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1 + - glam_etl.org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/query.sql /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/glam-fenix-dev/glam_etl/org_mozilla_fenix_glam_nightly__scalar_probe_counts_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -31,7 +31,7 @@ SUM(count) ) AS aggregates FROM - `glam-fenix-dev.glam_etl.org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1` + glam_etl.org_mozilla_fenix_glam_nightly__scalar_bucket_counts_v1 GROUP BY ping_type, os, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/mozfun/bits28/examples/extract_week_specific_bits.sql /tmp/workspace/generated-sql/sql/mozfun/bits28/examples/extract_week_specific_bits.sql --- /tmp/workspace/main-generated-sql/sql/mozfun/bits28/examples/extract_week_specific_bits.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/mozfun/bits28/examples/extract_week_specific_bits.sql 2024-06-27 16:55:48.000000000 +0000 @@ -3,6 +3,6 @@ mozfun.bits28.range(days_seen_bits, -13 + 0, 7) AS week_0_bits, mozfun.bits28.range(days_seen_bits, -13 + 7, 7) AS week_1_bits FROM - `mozdata.telemetry.clients_last_seen` + telemetry.clients_last_seen WHERE submission_date > '2020-01-01' diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/mozfun/norm/examples/fenix_app_info.sql /tmp/workspace/generated-sql/sql/mozfun/norm/examples/fenix_app_info.sql --- /tmp/workspace/main-generated-sql/sql/mozfun/norm/examples/fenix_app_info.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/mozfun/norm/examples/fenix_app_info.sql 2024-06-27 16:55:48.000000000 +0000 @@ -12,12 +12,12 @@ SELECT extract_fields('org_mozilla_firefox_beta', m).* FROM - `mozdata.org_mozilla_firefox_beta.metrics` AS m + org_mozilla_firefox_beta.metrics AS m UNION ALL SELECT extract_fields('org_mozilla_fenix', m).* FROM - `mozdata.org_mozilla_fenix.metrics` AS m + org_mozilla_fenix.metrics AS m ) SELECT DATE(submission_timestamp) AS submission_date, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/dashboard_health_v1/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/dashboard_health_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/dashboard_health_v1/metadata.yaml 2024-06-27 16:56:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/dashboard_health_v1/metadata.yaml 2024-06-27 16:56:43.000000000 +0000 @@ -19,5 +19,5 @@ # Generated by bigquery_etl.dependency references: query.sql: - - moz-fx-data-bq-performance.release_criteria.rc_flattened_test_data_v1 - - moz-fx-data-bq-performance.release_criteria.release_criteria_helper + - rc_flattened_test_data_v1 + - release_criteria_helper diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/dashboard_health_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/dashboard_health_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/dashboard_health_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/dashboard_health_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -8,7 +8,7 @@ IFNULL(test_extra_options, '') AS test_extra_options, IFNULL(subtest_name, '') AS subtest_name FROM - `moz-fx-data-bq-performance.release_criteria.rc_flattened_test_data_v1` + rc_flattened_test_data_v1 WHERE task_group_time >= TIMESTAMP_SUB(current_timestamp, INTERVAL 28 DAY) ), @@ -23,7 +23,7 @@ ARRAY_TO_STRING(ARRAY_AGG(DISTINCT rc_test_name), '\n') AS rc_test_name, COUNT(*) AS defined_criteria FROM - `moz-fx-data-bq-performance.release_criteria.release_criteria_helper` + release_criteria_helper GROUP BY framework, platform, diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_summary_v1/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_summary_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_summary_v1/metadata.yaml 2024-06-27 16:56:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_summary_v1/metadata.yaml 2024-06-27 16:56:43.000000000 +0000 @@ -17,4 +17,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - moz-fx-data-bq-performance.release_criteria.release_criteria_v1 + - release_criteria_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_summary_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_summary_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_summary_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_summary_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -26,13 +26,13 @@ SAFE_DIVIDE(rc_three_week_prior_average - rc_value, rc_value) AS three_week_pct_change, SAFE_DIVIDE(rc_four_week_prior_average - rc_value, rc_value) AS four_week_pct_change, FROM - `moz-fx-data-bq-performance.release_criteria.release_criteria_v1` AS a + release_criteria_v1 AS a WHERE task_group_time = ( SELECT MAX(task_group_time) FROM - `moz-fx-data-bq-performance.release_criteria.release_criteria_v1` AS b + release_criteria_v1 AS b WHERE a.project = b.project AND a.platform = b.platform diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_v1/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_v1/metadata.yaml 2024-06-27 16:56:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_v1/metadata.yaml 2024-06-27 16:56:43.000000000 +0000 @@ -18,5 +18,5 @@ references: query.sql: - dp2-prod.sumo.release_calendar - - moz-fx-data-bq-performance.release_criteria.rc_flattened_test_data_v1 - - moz-fx-data-bq-performance.release_criteria.release_criteria_helper + - rc_flattened_test_data_v1 + - release_criteria_helper diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/release_criteria_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -11,7 +11,7 @@ IFNULL(test_extra_options, '') AS test_extra_options ) FROM - `moz-fx-data-bq-performance.release_criteria.release_criteria_helper` + release_criteria_helper WHERE rc_test_name IS NOT NULL AND rc_test_name != 'exclude' @@ -38,7 +38,7 @@ included_rc.rc_target_value, included_rc.rc_target_app, FROM - `moz-fx-data-bq-performance.release_criteria.rc_flattened_test_data_v1` AS flattened + rc_flattened_test_data_v1 AS flattened LEFT JOIN rc_included_tests AS included_rc ON flattened.framework = included_rc.framework diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/stale_tests_v1/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/stale_tests_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/stale_tests_v1/metadata.yaml 2024-06-27 16:56:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/stale_tests_v1/metadata.yaml 2024-06-27 16:56:43.000000000 +0000 @@ -17,4 +17,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - moz-fx-data-bq-performance.release_criteria.release_criteria_v1 + - release_criteria_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/stale_tests_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/stale_tests_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-bq-performance/release_criteria/stale_tests_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-bq-performance/release_criteria/stale_tests_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -6,14 +6,14 @@ rc_test_name, task_group_time FROM - `moz-fx-data-bq-performance.release_criteria.release_criteria_v1` AS a + release_criteria_v1 AS a WHERE `moz-fx-data-bq-performance.udf.is_stale_test`(task_group_time, test_tier) AND task_group_time = ( SELECT MAX(task_group_time) FROM - `moz-fx-data-bq-performance.release_criteria.release_criteria_v1` AS b + release_criteria_v1 AS b WHERE a.project = b.project AND a.platform = b.platform diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/users_services_daily_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/users_services_daily_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/users_services_daily_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/users_services_daily_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -69,7 +69,7 @@ submission_timestamp, user_id_sha256, service, - `moz-fx-data-shared-prod.udf.mode_last`(ARRAY_AGG(country) OVER w1) AS country, + udf.mode_last(ARRAY_AGG(country) OVER w1) AS country, udf_contains_tier1_country(ARRAY_AGG(country) OVER w1) AS seen_in_tier1_country, LOGICAL_OR(event_name = 'reg_complete') OVER w1 AS registered, -- we cannot count distinct here because the window is ordered by submission_timestamp diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/users_services_last_seen_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/users_services_last_seen_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/users_services_last_seen_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/accounts_backend_derived/users_services_last_seen_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -12,7 +12,7 @@ CAST(registered AS INT64) AS days_registered_bits, * EXCEPT (submission_date, registered, seen_in_tier1_country), FROM - `moz-fx-data-shared-prod.accounts_backend_derived.users_services_daily_v1` + accounts_backend_derived.users_services_daily_v1 WHERE submission_date = @submission_date ), @@ -28,24 +28,24 @@ submission_date ) FROM - `moz-fx-data-shared-prod.accounts_backend_derived.users_services_last_seen_v1` + accounts_backend_derived.users_services_last_seen_v1 WHERE submission_date = DATE_SUB(@submission_date, INTERVAL 1 DAY) -- Filter out rows from yesterday that have now fallen outside the 28-day window. - AND `moz-fx-data-shared-prod.udf.shift_28_bits_one_day`(days_seen_bits) > 0 + AND udf.shift_28_bits_one_day(days_seen_bits) > 0 ) SELECT @submission_date AS submission_date, IF(_current.user_id_sha256 IS NOT NULL, _current, _previous).* REPLACE ( - `moz-fx-data-shared-prod.udf.combine_adjacent_days_28_bits`( + udf.combine_adjacent_days_28_bits( _previous.days_seen_bits, _current.days_seen_bits ) AS days_seen_bits, - `moz-fx-data-shared-prod.udf.combine_adjacent_days_28_bits`( + udf.combine_adjacent_days_28_bits( _previous.days_seen_in_tier1_country_bits, _current.days_seen_in_tier1_country_bits ) AS days_seen_in_tier1_country_bits, - `moz-fx-data-shared-prod.udf.coalesce_adjacent_days_28_bits`( + udf.coalesce_adjacent_days_28_bits( _previous.days_registered_bits, _current.days_registered_bits ) AS days_registered_bits diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_by_experiment_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_by_experiment_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_by_experiment_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_by_experiment_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -11,7 +11,7 @@ tile_id, user_prefs, FROM - `moz-fx-data-shared-prod.activity_stream_bi.impression_stats_flat_v1` + activity_stream_bi.impression_stats_flat_v1 CROSS JOIN UNNEST(experiments) AS experiment WHERE diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_flat_v1/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_flat_v1/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_flat_v1/metadata.yaml 2024-06-27 16:56:47.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_flat_v1/metadata.yaml 2024-06-27 16:56:46.000000000 +0000 @@ -29,4 +29,4 @@ # Generated by bigquery_etl.dependency references: query.sql: - - moz-fx-data-shared-prod.activity_stream_stable.impression_stats_v1 + - activity_stream_stable.impression_stats_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_flat_v1/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_flat_v1/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_flat_v1/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/activity_stream_bi/impression_stats_flat_v1/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -23,7 +23,7 @@ ANY_VALUE(experiments) AS experiments, sample_id FROM - `moz-fx-data-shared-prod.activity_stream_stable.impression_stats_v1` + activity_stream_stable.impression_stats_v1 CROSS JOIN UNNEST(tiles) AS flattened_tiles WITH OFFSET AS alt_pos diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_dau_v2/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_dau_v2/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_dau_v2/metadata.yaml 2024-06-27 16:57:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_dau_v2/metadata.yaml 2024-06-27 16:57:39.000000000 +0000 @@ -28,4 +28,4 @@ - workgroup:amo/nonprod references: query.sql: - - moz-fx-data-shared-prod.amo_prod.amo_stats_dau_v2 + - amo_prod.amo_stats_dau_v2 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_dau_v2/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_dau_v2/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_dau_v2/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_dau_v2/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -7,7 +7,7 @@ SELECT * FROM - `moz-fx-data-shared-prod.amo_prod.amo_stats_dau_v2` + amo_prod.amo_stats_dau_v2 WHERE submission_date = @submission_date AND ( diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_installs_v3/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_installs_v3/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_installs_v3/metadata.yaml 2024-06-27 16:57:45.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_installs_v3/metadata.yaml 2024-06-27 16:57:39.000000000 +0000 @@ -28,5 +28,5 @@ - workgroup:amo/nonprod references: query.sql: - - moz-fx-data-shared-prod.amo_dev.amo_stats_dau_v2 - - moz-fx-data-shared-prod.amo_prod.amo_stats_installs_v3 + - amo_dev.amo_stats_dau_v2 + - amo_prod.amo_stats_installs_v3 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_installs_v3/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_installs_v3/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_installs_v3/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_dev/amo_stats_installs_v3/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -6,12 +6,12 @@ addon_id, TO_HEX(SHA256(addon_id)) AS hashed_addon_id FROM - `moz-fx-data-shared-prod.amo_dev.amo_stats_dau_v2` + amo_dev.amo_stats_dau_v2 ) SELECT installs.* FROM - `moz-fx-data-shared-prod.amo_prod.amo_stats_installs_v3` AS installs + amo_prod.amo_stats_installs_v3 AS installs -- This join will filter out all addon_ids that are not already present -- in the dev dau table, so we don't need to duplicate the list of addons -- approved for dev here. diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_prod/amo_stats_dau_v2/metadata.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_prod/amo_stats_dau_v2/metadata.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_prod/amo_stats_dau_v2/metadata.yaml 2024-06-27 16:57:40.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_prod/amo_stats_dau_v2/metadata.yaml 2024-06-27 16:57:40.000000000 +0000 @@ -33,5 +33,5 @@ - workgroup:amo/prod references: query.sql: - - moz-fx-data-shared-prod.amo_prod.desktop_addons_by_client_v1 - - moz-fx-data-shared-prod.amo_prod.fenix_addons_by_client_v1 + - amo_prod.desktop_addons_by_client_v1 + - amo_prod.fenix_addons_by_client_v1 diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_prod/amo_stats_dau_v2/query.sql /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_prod/amo_stats_dau_v2/query.sql --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/amo_prod/amo_stats_dau_v2/query.sql 2024-06-27 16:56:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/amo_prod/amo_stats_dau_v2/query.sql 2024-06-27 16:55:48.000000000 +0000 @@ -13,13 +13,13 @@ *, 'Desktop' AS app FROM - `moz-fx-data-shared-prod.amo_prod.desktop_addons_by_client_v1` + amo_prod.desktop_addons_by_client_v1 UNION ALL SELECT *, 'Fenix' AS app FROM - `moz-fx-data-shared-prod.amo_prod.fenix_addons_by_c ```⚠️ Only part of the diff is displayed.
Checklist for reviewer:
<username>:<branch>of the fork as parameter. The parameter will also show up in the logs of themanual-trigger-required-for-forkCI task together with more detailed instructions.For modifications to schemas in restricted namespaces (see
CODEOWNERS):┆Issue is synchronized with this Jira Task