Knowledge DropLast tested: May 2021Looker's default max cache size is 2GB. This can be changed with the --on-d...
Knowledge DropLast tested: Jan 21, 2019Looker only replaces the existing cache key when the query is complete;...
Knowledge DropLast tested: May 14, 2020 Where can I find my cached results?Within every Looker directory there...
Knowledge DropLast tested: Oct 7, 2019Nope, but you can bust the cache per-model using Datagroups. This post t...
Knowledge DropLast tested: May 14, 2020 The .cache directory in a looker instance is the local cache layer tha...
Knowledge DropLast tested: Apr 23, 2019 Since totals require an extra sql query, the query is different then w...
Knowledge DropLast tested: May 13, 2020 Yes.History view entries in system activity have a Result Source field...
Knowledge DropLast tested: Oct 1, 2019 Yes, this will blow the cache for that datagroup regardless of the trig...
Knowledge DropLast tested: May 28, 2020 If the value for the History table's Result Source field is "stale_cac...
Knowledge DropLast tested: Apr 29, 2020 These are the three locations where we'll store the cached values.Memo...
Knowledge DropLast tested: Mar 1, 2018 The quick answer is no! A user with the dashboard open in a tab will be...
Knowledge DropLast tested: Sep 19, 2017 First things first: See this post for information on clustered instanc...
Knowledge DropLast tested: June 2021Prefetching is strongly discouraged. Use scheduling and datagroups instead...
Knowledge DropLast tested: Jul 24, 2020 A hard limit is yet to be confirmed, but we've tested as much as 365 d...
Knowledge DropLast tested: May 14, 2020 Looker has a feature that will fetch results from the cache if they ex...
Knowledge DropLast tested: Sep 6, 2019 1. Result cache is the results that came from the db with minimal post ...
Knowledge DropLast tested: March 21, 2021No. If we define a caching policy with a datagroup in our Explore or ...
Knowledge DropLast tested: March 2021From Docs: "If persist_for is set for both a model and one of its explore...
Knowledge DropLast tested: May 2020No. Only datagroups or manually clicking “clearing cache and refresh” on a ...
Knowledge DropLast tested: May 2020The default cache length in Looker is one hour.This default is not configur...
Knowledge DropLast tested: March 2021Yes! Since datagroups use SQL triggers, you can use the exact same querie...
Knowledge DropLast Tested: Jan 21, 2019Possible reasons that queries might still appear to pull from cache eve...
Knowledge DropLast tested: March 2021No. The suggestions have their own cache that cannot be manually cleared ...
Knowledge DropLast tested: March 2021No. When you clear cache, it only clears cache for the current query, not...
Knowledge DropLast Tested: Dec 6, 2018 As of 5.12 there is an option to Clear Cache and Refresh on the merged ...
Knowledge DropLast Tested: Jan 21, 2019According to the datagroup docs, the cached results will be busted the ...