How disable disk cache in SQL Warehouse (Azure Databricks)?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2023 11:57 PM
Hi! I want to disable disk cache for SQL Warehouse in Azure Databricks, but it seems that is not possible. Is it correct?
You can't use this configuration for SQL Warehouse (https://learn.microsoft.com/en-US/azure/databricks/optimizations/disk-cache#--enable-or-disable-the-...), and if you use parameter USED_CACHE_RESULT=false (https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/parameters/use_cached_result) only is disable Spark cache, not for disk cache.
Could someone confirm it?
Thanks!!
Labels:
- Labels:
-
Azure databricks
-
Delta Cache
-
SQL
-
Sql Warehouse