mozilla / bigquery-etl

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

DENG-3186 start managed backfill of desktop_engagement_clients_v1 #5691

Closed kwindau closed 1 month ago

kwindau commented 1 month ago

Checklist for reviewer:

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

┆Issue is synchronized with this Jira Task

dataops-ci-bot commented 1 month ago

Integration report for "DENG-3186 start managed backfill of desktop_engagement_clients_v1"

sql.diff

Click to expand! ```diff Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1: backfill.yaml diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1/backfill.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1/backfill.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1/backfill.yaml 1970-01-01 00:00:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1/backfill.yaml 2024-05-30 19:46:03.000000000 +0000 @@ -0,0 +1,7 @@ +2024-05-30: + start_date: 2019-01-01 + end_date: 2024-05-29 + reason: Loading new table; related to DENG-3186 + watchers: + - kwindau@mozilla.com + status: Initiate ```

Link to full diff

dataops-ci-bot commented 1 month ago

Integration report for "DENG-3186 update start date for backfill"

sql.diff

Click to expand! ```diff Only in /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1: backfill.yaml diff -bur --no-dereference --new-file /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1/backfill.yaml /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1/backfill.yaml --- /tmp/workspace/main-generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1/backfill.yaml 1970-01-01 00:00:00.000000000 +0000 +++ /tmp/workspace/generated-sql/sql/moz-fx-data-shared-prod/telemetry_derived/desktop_engagement_clients_v1/backfill.yaml 2024-05-30 19:59:03.000000000 +0000 @@ -0,0 +1,7 @@ +2024-05-30: + start_date: 2021-01-01 + end_date: 2024-05-29 + reason: Loading new table; related to DENG-3186 + watchers: + - kwindau@mozilla.com + status: Initiate ```

Link to full diff