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
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
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: 

SQL Warehouse - Turning off caching

KosmaS
New Contributor III

yesterday

Hi All,

I'd like to do some benchmarking and I need to turn off caching on my SQL Warehouse Server. However, whatever I try I receive quite high level of caching after running my queries (>60%). I tried to turn off my server, but it automatically wakes up right away and it didn't help. I tried as well 'SET use_cached_result = false' from this page, which didn't help as well:  https://docs.databricks.com/en/sql/user/queries/query-caching.html

Could you advise me how to proceed to be sure that cache is turned off when I run my query?

0 Kudos
1 REPLY 1

Walter_C
Databricks Employee
Databricks Employee

yesterday

To disable query result caching, you can run SET use_cached_result = false in the SQL editor.

0 Kudos

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group
Announcements