:wlach identified that the Numbers That Matter dashboard shows issues back to August 17th. That coincides with when :whd moved the stub installer pipeline family to the new network configuration. That's past the 14 day retention window that was on the table, so we initially thought the data was lost. But it appears that BQ time travel (which allows looking at snapshots up to 7 days old) allows us to see an extra 7 days, so we can recover this. First, we need an appropriate snapshot timestamp: ``` SELECT UNIX_MILLIS(CURRENT_TIMESTAMP() - INTERVAL 6 day - INTERVAL 22 hour) -- 1630100775333 ``` Then we can craft a `bq cp` invocation to save off that snapshot that will look something like: ``` bq cp moz-fx-data-shared-prod:payload_bytes_raw.stub_installer@1630100775000 dest ```
Bug 1729069 Comment 4 Edit History
Note: The actual edited comment in the bug view page will always show the original commenter’s name and original timestamp.
:wlach identified that the Numbers That Matter dashboard shows issues back to August 17th. That coincides with when :whd moved the stub installer pipeline family to the new network configuration. That's past the 14 day retention window that was on the table, so we initially thought the data was lost. But it appears that BQ time travel (which allows looking at snapshots up to 7 days old) allows us to see an extra 7 days, so we can recover this. First, we need an appropriate snapshot timestamp: ``` SELECT UNIX_MILLIS(CURRENT_TIMESTAMP() - INTERVAL 6 day - INTERVAL 22 hour) -- 1630100775333 ``` Then we can craft a `bq cp` invocation to save off that snapshot that will look something like: ``` bq cp moz-fx-data-shared-prod:payload_bytes_raw.stub_installer@1630100775000 moz-fx-data-shared-prod:payload_bytes_raw.stub_installer_snapshot_bug1729069 ```