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:

`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
```
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
```

Back to Bug 1758949 Comment 5