How to Partition and Cluster the Following Query for Google Big Query?
Table Schema CREATE TABLE pudos ( unique_id STRING NOT NULL, ts DATETIME NOT NULL, pickup_zip STRING NOT NULL, pickup_long FLOAT64 NOT NULL, pickup_lat FLOAT64 NOT NULL, dest_zip STRING NOT NULL, dest_long FLOAT64 NOT NULL, dest_lat FLOAT64 NOT NULL); Query Pattern SELECT ts, unique_id, pickup_zip, dest_zip FROM pudos WHERE ts BETWEEN 2024-07-29 09:10:00 AND 2024-07-29 09:11:00; […]