bq_sql_2

bq_sql_2.sql

-- data for 1 day: 479 MB scanned
SELECT *
FROM `bigquery-public-data.google_trends.international_top_terms` 
WHERE refresh_date = DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY);

-- data for 2 days: 955 MB scanned
SELECT *
FROM `bigquery-public-data.google_trends.international_top_terms` 
WHERE refresh_date > DATE_SUB(CURRENT_DATE, INTERVAL 3 DAY);

-- no partition filter: whole table scanned (15 GB)
SELECT *
FROM `bigquery-public-data.google_trends.international_top_terms`;