How long are Queries stored for in Databricks SQL (SQL Analytics)? Can I modify the time duration?

[User16783855117 · Accepted solution]

Hi! There are a few different types of caching that are supported in Databricks SQL, and you can see the cache retention policy for each of these different types of cache by starting here - https://docs.databricks.com/sql/admin/query-caching.html Query Results caching and Delta Caching are based on the cluster, which means restarting the cluster will invalidate this cache.