Forum Discussion

dozer_1985's avatar
dozer_1985
Regular Visitor
2 years ago

Delta Tables with Liquid Clustering Applied

Hi all,   Looking for some general advice if anyone out there can help. I'm trying to access data in a Blob Storage Container in Azure Data Lake Storage Gen 2. Liquid Clustering has been applied to...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Read data from a clustered table

You can read data in a clustered table using any Delta Lake client that supports reading deletion vectors. For best query results, include clustering keys in your query filters, as in the following example:

SQL
dozer_1985's avatar
dozer_1985
Regular Visitor
2 years ago

Hi, 

 

Thanks for the response. Not using Databricks, we only use Databricks to create views, Power BI uses Power Query functions to access directly to Storage Accounts. 


We opted for that approach as it takes too long to spin up a cluster when people want to access, alternative is to run a cluster all day, but we didn't want to do that due to cost.