Question

Your organization uses BigQuery flat-rate reservations. You created a reservation named 'etl-res' with 500 slots and assigned it at the organization level to a folder called 'data-eng'. A new project 'nightly-loads' was placed inside the 'data-eng' folder, but you also want that single project's queries to run against a separate 'priority-res' reservation with 200 slots instead of the folder's assignment. What is the correct way to achieve this?

Accepted Answer

Create an assignment linking the 'nightly-loads' project directly to 'priority-res'; the more specific project-level assignment overrides the inherited folder-level assignment.

Answer

Delete the folder-level assignment because reservations cannot be assigned at the folder level, then reassign each project individually.

Answer

Move 'nightly-loads' out of the 'data-eng' folder, since a project can only use a reservation from a folder it does not belong to.

Answer

Add the 200 slots from 'priority-res' into 'etl-res' and use query labels to route 'nightly-loads' queries to the additional capacity.