Lakehouse vs Warehouse performance

[Srisakthi]

Hello All,

Lakehouse supports optimization techniques like v-order, vaccum, liquid clustering, partitioning and it feels like it will give better performance when we build report on top of it. But warehouse lack few features like liquid clustering, partitioning will it affect performance on reporting?

Is there any benchamarking for performance of lakehouse vs warehouse.

@Anonymous 

@frithjof_v  any help is much appreciated and it will help me to take decision on to go with Lakehouse vs warehouse

Regards,

Srisakthi

[FabianSchut · Accepted solution]

Hi,

Microsoft has quite some documentation in choosing between lakehouses or warehouses:
https://learn.microsoft.com/en-us/fabric/get-started/decision-guide-lakehouse-warehouse
https://learn.microsoft.com/en-us/fabric/get-started/decision-guide-data-store

However, those are not always focussing on performance. This article desribes the difference in performance better for several use cases:
https://sqlreitse.com/2024/05/31/testing-azure-fabric-capacity-data-warehouse-vs-lakehouse-performan...

[Srisakthi]

Thank youso much  @FabianSchut ,

The last link on performance article gives good view and it will help everyone for considering lakehouse or warehouse.

thanks again!

Regards,

Srisakthi