You want to optimize your queries for cost and performance. How should you structure your data?
Partition table data by create_date, location_id and device_version
Partition table data by create_date cluster table data by location_Id and device_version
Cluster table data by create_date location_id and device_version
Cluster table data by create_date partition by locationed and device_version
Submit