Quota Error: Too many concurrent queries, when querying Big Query with Data Studio?
I have a Google Data Studio that uses fetches from a Google Big Query View. I am running into "Quota Error: Too many concurrent queries.
Solution:
My preferred option for these cases is to copy the query results out of BigQuery into temporary storage (sheets, GCS, MySQL...) and have Data Studio read the results from there. The best place depends on the shape of your data and the results you are trying to visualize.
Other options - depending on your exact use case:
- Turn on caching in Data Studio, which will pre-fetch data and run queries against cache.
- Materialize the view, so that the queries will run faster.
- Reduce the number of components on the page so that they don't generate as many queries
David-Spring
posted on 30 May 19Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment