SQL Warehouse - Turning off caching

KosmaS — Tue, 07 Jan 2025 22:05:20 GMT

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?

Re: SQL Warehouse - Turning off caching

Walter_C — Tue, 07 Jan 2025 22:16:35 GMT

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

topic SQL Warehouse - Turning off caching in Warehousing & Analytics

SQL Warehouse - Turning off caching

Re: SQL Warehouse - Turning off caching