Data Studio
2.2K members online now
2.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

How "Prefetch cache" works

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi!

I have couple of dashboards, which are using BQ as the underlying data base.
I'm reading here:

https://support.google.com/datastudio/answer/7020039?hl=en

that Data Studio supports something, which is called "Prefetch cache"

Can anyone explain a bit more about that feature, i.e.:

* what kind of queries I can expect, while  data is being prefetched,

* how often data is being prefetched.

The reason I'm asking is that we see some requests coming from Data Studio, which are always ending with(I'm looking at BQ audit logs):

"Resources exceeded during query execution."

Those queries are basically trying to dump large parts of tables.