How "Prefetch cache" works
I have couple of dashboards, which are using BQ as the underlying data base.
I'm reading here:
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.