cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Warehousing & Analytics
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

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

Go to solution
Anonymous
Not applicable

โ€Ž06-04-2021 11:26 AM

 
Labels:
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions

Go to solution
User16783855117
Contributor II

โ€Ž06-07-2021 07:30 AM

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.

View solution in original post

0 Kudos
1 REPLY 1

Go to solution
User16783855117
Contributor II

โ€Ž06-07-2021 07:30 AM

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.
0 Kudos
Announcements
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.