4 ms·
To people interested in archiving this, it's still in the 7 days time history in BigQuery Public Dataset: For instance: SELECT country FROM `bigquery-publ
by Sayrus 1y ago
To people interested in archiving this, it's still in the 7 days time history in BigQuery Public Dataset:
For instance:
SELECT
country
FROM
`bigquery-public-data.google_political_ads.geo_spend`
FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY)
GROUP BY country;
- wizzwizz4 1y agoCould someone get Archive Team on this? https://archiveteam.org https://archiveteam.org
- Pikamander2 1y ago/r/DataHoarder as well https://www.reddit.com/r/DataHoarder/ https://www.reddit.com/r/DataHoarder/
- Sayrus 1y agoI dumped the all active tables (advertiser_declared_stats, advertiser_geo_spend, advertiser_stats, advertiser_weekly_spend, geo_spend, creative_stats) in CSV format. I'd prefer if someone did an archive where they are confident in the integrity of the dumped data but at least that version exists.
- meindnoch 1y ago[flagged]
- Sayrus 1y agoWhat a snarky comment. As said just one comment under (https://news.ycombinator.com/item?id=45413138 https://news.ycombinator.com/item?id=45413138), I made my own backup. But as someone who's not actively using BigQuery, I'm not confident in the data integrity so I'd prefer if someone confident in their abilities could make an archive as well.
- dredmorbius 1y ago<https://news.ycombinator.com/item?id=9972849 https://news.ycombinator.com/item?id=9972849>
- simonw 1y agoWhat does "7 days time" mean in this context?
- Sayrus 1y agohttps://cloud.google.com/bigquery/docs/access-historical-data https://cloud.google.com/bigquery/docs/access-historical-dat... BigQuery supports a sort of "time travel" / point-in-time querying. By default and for those datasets it's enabled for 7 days which means you can query data as it was up-to 7 days ago.
- jagged-chisel 1y agoIf someone can post instructions, I’d be happy to follow them and make a copy as well.
- Sayrus 1y agoFor what it's worth, my own procedure: 1. Create a GCS bucket 2. Open https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1sbigquery-public-data!2sgoogle_political_ads https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1s... 3. For each table under google_political_ads, run the following query: SELECT * FROM `bigquery-public-data.google_political_ads.<TABLE>` FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY) GROUP BY country; 3. Export as CSV in GCS Another procedure that is probably better but requires BigTable is: 1. Open https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1sbigquery-public-data!2sgoogle_political_ads https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1s... 2. For each table, click Snapshot and set Snapshot time to Sep 23 (Sep 24 works as well)
- secondcoming 1y agoOhh, Google’s BQ query bills are about to go through the roof!