Issue: Interactive Queries Exceeding 1,000 Limit in BigQuery

[kamalesh]

In my project, interactive queries are queuing up to over 1,800, even though the BigQuery documentation states the limit is 1,000. I need to understand why this is happening.

refer:

https://cloud.google.com/bigquery/quotas#:~:text=Maximum%20number%20of%20queued%20interactive%20quer...

[kamalesh]

Any update?

[jangemmar]

Hi @kamalesh,

Welcome to Google Cloud Community!

BigQuery is capable of identifying the number of queries that can run concurrently based on the available compute resources. The reason why you’re having 1.785k interactive queries in a day is because the queue length is limited to 1,000 interactive queries per project per region, regardless of whether the project is on-demand or using a reservation, but it doesn’t necessarily mean that you can only have 1,000 interactive queries in a day.

I hope the above information is helpful.

[kamalesh]

I want to clarify that the 1.785k pending interactive queries shown in the above screenshot were filtered based on the 'pending' state.
see below SS for more clarification

I look forward to your response

Thanks