CODEWITHSUNDEEP
sqlgoogle-bigquery
David542
David542

Reputation: 110093

BigQuery quota for concurrent queries

We have an application that generates a filters panel based upon the columns that a user has stored. Here is an example:

enter image description here

These queries run simultaneously, so that we can load the sidebar in one go. Each action on a page leads to N + 1 concurrent queries where N = number of filters on a page. It's quite probable that when >5 users are using the application simultaneously, there will be "rate exceeded" exceptions.

Is there any way to request a way to relax this single quota? Unfortunately, this particular quota would make our application almost inoperable if we were to implement BQ for the backend.

Upvotes: 1

Views: 1782

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172944

I am not sure if you can change quota (you might want to contact your sales representative for this)
Meantime, if you really call all these N+1 queries simultaneously - I see another option which is to combine all those N+1 queries into one query thus reducing total queries volume a lot.
It is not clear from your question what exactly your queries looks like - depending on this making one query can be less or more of challenge - but this is definitely an option

Upvotes: 3

Related Questions