You run a CDC process that loads 1 GB every 10 minutes into a temp table and then merges into a 10 TB target. To move from on-demand to predictable cost using reservations, where should you assign the BigQuery reservation?

BigQuery reservations are allocated at the project level, providing dedicated slots for all queries within that project. This ensures predictable performance and cost for all workloads, including your CDC process. Assigning the reservation to the project allows you to manage and monitor slot usage across all jobs originating from that project. Creating a reservation for a dataset or a specific job is not an available BigQuery feature; reservations are broader in scope. While a service account runs the job, BigQuery reservations are not directly assigned to service accounts but rather to the projects where those service accounts operate. Therefore, the project is the correct and most effective level to apply a BigQuery reservation for predictable cost and performance.