Creating Date-Partitioned Tables in BigQueryGo to Lab
"Why did the previous query return 0 records but still scan through 1.74GB of data?" First of all it's "returns" and also the structure of the question isn't totally correct! Like this phrase too "Update the ORDER BY clause to show the oldest partitions first. The date you see there Add this query and run it:"
Lovely lab, creating new tables and mastering SQL!! Bonus !! Loving every moment!!
Don't understand where the 'stn' comes from in the inner query when creating the partitioned table: (SELECT ANY_VALUE(name) FROM `bigquery-public-data.noaa_gsod.stations` AS stations WHERE stations.usaf = stn) AS station_name