If the cache is full, then what gets dropped first?
Knowledge DropLast tested: May 2021Looker's default max cache size is 2GB. This can be changed with the --on-d...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
How does "Clear Cache and Refresh" work, what if I close the browser?
Knowledge DropLast tested: Jan 21, 2019Looker only replaces the existing cache key when the query is complete;...
Which table does cached results get stored in the internal database?
Knowledge DropLast tested: May 14, 2020 Where can I find my cached results?Within every Looker directory there...
Can you bust the cache instance-wide via the API ?
Knowledge DropLast tested: Oct 7, 2019Nope, but you can bust the cache per-model using Datagroups. This post t...
What gets stored in the /looker/.cache/ directory?
Knowledge DropLast tested: May 14, 2020 The .cache directory in a looker instance is the local cache layer tha...
Why am I seeing different values when I have totals turned on then when I don't?
Knowledge DropLast tested: Apr 23, 2019 Since totals require an extra sql query, the query is different then w...
Does running a query from cache produce a new History ID?
Knowledge DropLast tested: May 13, 2020 Yes.History view entries in system activity have a Result Source field...
In the `update_datagroup` api call, will: {“stale_before”: now()} bust the cache?
Knowledge DropLast tested: Oct 1, 2019 Yes, this will blow the cache for that datagroup regardless of the trig...
System Activity History: Result source is "stale_cache"
Knowledge DropLast tested: May 28, 2020 If the value for the History table's Result Source field is "stale_cac...
What's the difference between memory cache, local cache, and remote cache?
Knowledge DropLast tested: Apr 29, 2020 These are the three locations where we'll store the cached values.Memo...
Will deleting a dashboard make it immediately inaccessible?
Knowledge DropLast tested: Mar 1, 2018 The quick answer is no! A user with the dashboard open in a tab will be...
What happens when you clear cache & refresh on a clustered instance?
Knowledge DropLast tested: Sep 19, 2017 First things first: See this post for information on clustered instanc...
Is prefetching allowed in Looker?
Knowledge DropLast tested: June 2021Prefetching is strongly discouraged. Use scheduling and datagroups instead...
What’s the largest number you can set max_cache_age to?
Knowledge DropLast tested: Jul 24, 2020 A hard limit is yet to be confirmed, but we've tested as much as 365 d...
What is cache_only_miss in the system activity History explore?
Knowledge DropLast tested: May 14, 2020 Looker has a feature that will fetch results from the cache if they ex...
Result Cache vs Rendered Cache
Knowledge DropLast tested: Sep 6, 2019 1. Result cache is the results that came from the db with minimal post ...
Does "clear cache and refresh" bust Datagroup cache?
Knowledge DropLast tested: March 21, 2021No. If we define a caching policy with a datagroup in our Explore or ...
Which `persist for` takes precedence out of PDTs, explores, models, etc.?
Knowledge DropLast tested: March 2021From Docs: "If persist_for is set for both a model and one of its explore...
Does a Looker instance restart bust the query cache?
Knowledge DropLast tested: May 2020No. Only datagroups or manually clicking “clearing cache and refresh” on a ...
Is it possible to change the default cache length?
Knowledge DropLast tested: May 2020The default cache length in Looker is one hour.This default is not configur...
Can you set datagroups to clear cache at a certain time of day?
Knowledge DropLast tested: March 2021Yes! Since datagroups use SQL triggers, you can use the exact same querie...
Why isn't Clear Cache and Refresh working?
Knowledge DropLast Tested: Jan 21, 2019Possible reasons that queries might still appear to pull from cache eve...
Will "Clear Cache and Refresh" affect filter suggestions?
Knowledge DropLast tested: March 2021No. The suggestions have their own cache that cannot be manually cleared ...
Does clearing cache clear the drill down cache?
Knowledge DropLast tested: March 2021No. When you clear cache, it only clears cache for the current query, not...
Are merge results cached?
Knowledge DropLast Tested: Dec 6, 2018 As of 5.12 there is an option to Clear Cache and Refresh on the merged ...
If we don't specify a `max_cache_age`on a datagroup, will it default to the 1 hour?
Knowledge DropLast Tested: Jan 21, 2019According to the datagroup docs, the cached results will be busted the ...
