Does Looker autorefresh update the cache?

[philip-ct]

We have a dashboard that autorefreshes every 10 minutes. In the docs, it says that it always pulls from the database for autorefreshes, but does this also update the cache as well?

https://cloud.google.com/looker/docs/editing-user-defined-dashboards#autorefresh

[Jiro · Accepted solution]

Hi Philip -- great question.  Yes, the autorefresh will set the new cache value once the query completes.

Also, autorefresh does not "clear cache" when it starts so if another query is manually run with the same sql and there is valid cache for that sql text, the manual query will be able to use it while the autorefresh is running. (i.e no gap on cache access for non-autorefresh queries)