How would you query specific partitions in a BigQuery table?

How would you query specific partitions in a BigQuery table?
A . Use the DAY column in the WHERE clause
B . Use the EXTRACT(DAY) clause
C . Use the __PARTITIONTIME pseudo-column in the WHERE clause
D . Use DATE BETWEEN in the WHERE clause

View Answer

Answer: C

Explanation:

Partitioned tables include a pseudo column named _PARTITIONTIME that contains a date-based timestamp for data loaded into the table. To limit a query to particular partitions (such as Jan 1st and 2nd of 2017), use a clause similar to this:

WHERE _PARTITIONTIME BETWEEN TIMESTAMP (‘2017-01-01’) AND TIMESTAMP (‘2017-01-02’)

Reference: https://cloud.google.com/bigquery/docs/partitioned-tables#the_partitiontime_pseudo_column