by
jlgr
• New Contributor II
- 4392 Views
- 2 replies
- 0 kudos
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#-...
- 4392 Views
- 2 replies
- 0 kudos
Latest Reply
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 ...
1 More Replies
by
Manoj
• Contributor II
- 6110 Views
- 9 replies
- 8 kudos
Hi Team, we are planning to connect Power BI directly to Data bricks, however data fetching using direct query isn't giving great performance, though we are using Zorder by and Partition etc.. We decided to use Delta Cache, but the cache tables area ...
- 6110 Views
- 9 replies
- 8 kudos
Latest Reply
@Hubert Dudek , I got a good news, I agree with @Werner Stinckens , SQL End Point is super fast, I have tested for 143 million records with Direct Query from power bi, result returned in 10-12 seconds. Don't even try doing incremental in power bi, ...
8 More Replies
- 1202 Views
- 1 replies
- 0 kudos
Basically I'm worried about the scenario where data that gets cached on Databricks SQL endpoints becomes out of sync with the source Delta table. If that were to happen and data was read from the cache it would be out of date/incorrect. Is this a con...
- 1202 Views
- 1 replies
- 0 kudos
Latest Reply
There are 3 types of caching. 1-Databricks SQL UI caching, 2-Query results caching , 3-Delta caching . (1) does not get invalidated. It's like your BI dashboard. BI dashboard needs to be manually refreshed.(2) and (3) gets auto invalidation.pls check...
