From the course: Learning Microsoft Fabric

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Differences between lakehouses and warehouses

Differences between lakehouses and warehouses - Microsoft Fabric Tutorial

From the course: Learning Microsoft Fabric

Start my 1-month free trial Buy for my team

Differences between lakehouses and warehouses

“

- If you're storing data inside of Microsoft Fabric, you have a decision to make. Should you store data in a lakehouse or a warehouse? There's a lot of similarities between the two. They both use a limited set of T-SQL, which means there's some functions that are not supported, including the ability to create cursors or temp tables. Both can store up to a terabyte of data per table based on your license, of course. And both store data as Spark Delta tables inside of OneLake. These things are the same. And you can create a pipeline to add data to either a lakehouse or a warehouse. The difference between a lakehouse and a warehouse are the methods that can be used to add data to a warehouse, the methods used to update the data. And the structure inside the data storage container, the default maintenance structure, and multi-table transactions. For multi-table transactions, you might want to say insert one record. And if that works, then update a table. That's what I mean by that. If…

Contents