data-engineer-pro video for a logistics firm named TransGlide Inc. streams real-time package-tracking information into an Apache Kafka pipeline, which then
A logistics firm named TransGlide Inc. streams real-time package-tracking information into an Apache Kafka pipeline, which then feeds into BigQuery . The data analysts at your organization want to perform geospatial analysis on the full lifecycle of each package using the data stored in BigQuery. The existing table was initially set up with partitioning based on the data ingestion date . However, over time, the queries have become slower to execute. You need to apply a modification to improve BigQuery query performance. What should you do?