Which table does cached results get stored in the internal database?

Knowledge Drop

Last tested: May 14, 2020
 

Where can I find my cached results?

Within every Looker directory there's a /looker/.cache directory which is where cached objects is actually stored (query results, internal objects, etc.) Check out this ​post to read more about this.

The internal database will have a cache_index table that will have metadata that points to each entry within the /looker/.cache directory. If something is stored on disk, then it'll have an entry in the cache_index internal db table.

Within this cache_index table, there's also a corresponding TTL (time to live) which will specify how long the objects are stored in cache.

The contents within the /looker/cache directory are all encrypted via 256 bit encryption

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 03:38 PM
Updated by: