How disable disk cache in SQL Warehouse (Azure Databricks)?
- 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:
-
Azure databricks
-
Cache
-
Delta Cache
-
SQL
-
Sql Warehouse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-24-2023 04:22 AM
Thanks @Kaniz Fatma! But this options is not available in Databricks SQL (SQL Warehouse). My question is about Databricks SQL.
Is there any options to disable disk cache in Databricks SQL?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-24-2023 03:18 AM
Hi @jlgr jlgr
Hope everything is going great.
Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.
Cheers!