30 May 2019 · David-Spring ·       Add to Favorites   Report

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 2019

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied