Why use Warehouse instead of Lakehouse? (Wanting to use Notebook)

[frithjof_v]

I see some users are asking how to use Notebook to load data into Warehouse.

I am wondering, why not use Lakehouse instead of Warehouse, if there is a desire to use Notebook?

I thought one of the main points of using a Warehouse, is to work with T-SQL (stored procedures, etc.).

And if there is a desire to use Notebook (with python, pyspark, sparksql, etc.), then Lakehouse is a suitable data store.

Any users have any opinions why they want to use Warehouse instead of Lakehouse, even if they will use Notebook for data load?

Why not just use Lakehouse?

I am interested to hear people's opinions on this 😀

[KevinChant · Accepted solution]

Most popular reasons I tend to get during discussions is the T-SQL support, especially as far as setting permissions are concerned.

However, with the Lakehouse permissions currently in preview the latter could soon be a moot point.

[v-huijiey-msft]

Hi @frithjof_v ,

The Warehouse is optimised for structured data and supports T-SQL, a powerful language for querying and managing relational databases. Users who are familiar with T-SQL and need to execute complex queries, stored procedures, and transactions may prefer the Warehouse.

Lakehouse provides flexibility for unstructured and semi-structured data and supports various data processing engines such as PySpark and Spark SQL.

This article may be helpful to you:

Choosing Between the Lakehouse and Warehouse in Microsoft Fabric - Simple Talk (red-gate.com)

Ultimately, the choice between Warehouse and Lakehouse will depend on the specific needs and circumstances of the business.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[frithjof_v]

Thanks @v-huijiey-msft 😀

I am hoping to hear other users' opinions on this topic as well 😀

Best regards, Frithjof