mozilla / bigquery-etl

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

DENG-3096 rename column name #5807

Closed kwindau closed 2 weeks ago

kwindau commented 2 weeks ago

Checklist for reviewer:

For modifications to schemas in restricted namespaces (see CODEOWNERS):

┆Issue is synchronized with this Jira Task

dataops-ci-bot commented 2 weeks ago

Integration report for "DENG-3096 rename column name"

sql.diff

Click to expand! ```diff diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/cloudflare_derived/os_usage_v1/query.py /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/cloudflare_derived/os_usage_v1/query.py --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/cloudflare_derived/os_usage_v1/query.py 2024-06-19 17:36:14.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/cloudflare_derived/os_usage_v1/query.py 2024-06-19 17:35:59.000000000 +0000 @@ -340,7 +340,7 @@ Location AS location, DeviceType AS device_type FROM `moz-fx-data-shared-prod.cloudflare_derived.os_errors_stg` -WHERE CAST(StartTime as date) = DATE_SUB('{args.date}', INTERVAL 4 DAY) """ +WHERE StartDate = DATE_SUB('{args.date}', INTERVAL 4 DAY) """ load_err_to_gold = client.query(os_usg_errors_stg_to_gold_query) load_err_to_gold.result() ```

Link to full diff