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?
