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. Create a GCS bucket
2. Open 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!1s...
2. For each table, click Snapshot and set Snapshot time to Sep 23 (Sep 24 works as well)