Given the timing I think the following job is responsible for the truncation for comment #3 specifically: `gcloud --project moz-fx-data-bq-batch-prod alpha bq jobs describe de19647d-33e0-4346-ae77-51d8bff93f03` since it occurred at 2022-03-08T01:47:27.669973Z. ```yaml configuration: dryRun: false jobType: QUERY query: destinationTable: datasetId: contextual_services_stable projectId: moz-fx-data-shared-prod tableId: topsites_impression_v1 priority: INTERACTIVE query: |- SELECT _target.* FROM `moz-fx-data-shared-prod.contextual_services_stable.topsites_impression_v1` AS _target LEFT JOIN ( SELECT payload.scalars.parent.deletion_request_context_id AS _source_0 FROM `moz-fx-data-shared-prod.telemetry_stable.deletion_request_v4` WHERE DATE(submission_timestamp) >= '2022-01-10' AND DATE(submission_timestamp) < '2022-03-07' ) ON context_id = _source_0 WHERE (_source_0 IS NULL) AND CAST(submission_timestamp AS DATE) < '2022-03-07' useLegacySql: false writeDisposition: WRITE_TRUNCATE ```
Bug 1758949 Comment 5 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
Given the timing I think the following job is responsible for the truncation for comment #3 specifically: https://cloudlogging.app.goo.gl/ju2b7PaAshnqcciy7 `gcloud --project moz-fx-data-bq-batch-prod alpha bq jobs describe de19647d-33e0-4346-ae77-51d8bff93f03` since it occurred at 2022-03-08T01:47:27.669973Z. ```yaml configuration: dryRun: false jobType: QUERY query: destinationTable: datasetId: contextual_services_stable projectId: moz-fx-data-shared-prod tableId: topsites_impression_v1 priority: INTERACTIVE query: |- SELECT _target.* FROM `moz-fx-data-shared-prod.contextual_services_stable.topsites_impression_v1` AS _target LEFT JOIN ( SELECT payload.scalars.parent.deletion_request_context_id AS _source_0 FROM `moz-fx-data-shared-prod.telemetry_stable.deletion_request_v4` WHERE DATE(submission_timestamp) >= '2022-01-10' AND DATE(submission_timestamp) < '2022-03-07' ) ON context_id = _source_0 WHERE (_source_0 IS NULL) AND CAST(submission_timestamp AS DATE) < '2022-03-07' useLegacySql: false writeDisposition: WRITE_TRUNCATE ```