Explanation:
Partitioned tables in BigQuery include a pseudo column named _PARTITIONTIME that contains a date-based timestamp for data loaded into the table. To query specific partitions, such as January 1st and 2nd of 2017, you can use a clause like this: WHERE _PARTITIONTIME BETWEEN TIMESTAMP('2017-01-01') AND TIMESTAMP('2017-01-02'). This method efficiently limits your query to the specified partitions. For more details, refer to the BigQuery documentation on partitioned tables.
What is the correct method to query specific partitions in a BigQuery table?
A
Use the DAY column in the WHERE clause
B
Use DATE BETWEEN in the WHERE clause
C
Use the EXTRACT(DAY) clause
D
Use the __PARTITIONTIME pseudo-column in the WHERE clause
No comments yet.