Gilbert Quevauvilliers performs a comparison:
I saw that there was an update where it is now possible to use the Microsoft Fabric Warehouse to copy data directly from OneLake into the Warehouse.
This got me thinking, which would consume more capacity to get the data into the Warehouse table. As well as which one would be faster.
To do this I am going to be running a SQL query in the Warehouse.
Next, I will use a Notebook to copy the data from the OneLake files section to a Warehouse table.
Gilbert’s specific query involves loading data from a variety of CSV files into a lakehouse via notebook, and then into a warehouse table. Read on for the results.