3 ms·
If someone can post instructions, I’d be happy to follow them and make a copy as well.
by jagged-chisel 1y ago
If 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)