You hit the 2,000 concurrent on‑demand BigQuery slots per project limit and cannot add projects. What should you do to provide predictable slot capacity and priority?

Switching to flat-rate pricing is the correct solution because it allows you to purchase dedicated BigQuery slots, providing predictable capacity and avoiding the 2,000 concurrent on-demand slot limit. With flat-rate pricing, you can allocate these purchased slots across your projects and establish a hierarchical priority model using reservations, ensuring critical workloads receive the necessary resources. Converting batch queries to interactive queries would consume slots faster and not address the capacity issue. Creating an additional project would still be subject to the same 2,000 on-demand slot limit per project. Increasing the concurrent slots per project via the Quotas page is not an option for on-demand slots beyond the default limit; flat-rate pricing is the mechanism for dedicated capacity.