AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.3K members online now
4.3K 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.