Hi everyone, in this blogpsot I'll experiment with Data Factory in Microsoft Fabric. I'll create a Data lake in the Data Lakehouse experience and I'll load some data from an Azure SQL Database, which I've prepared for this blogpost with a demo database AdventureWorksLT and w'll load the data in the Data lake.
Let's go and see how it works.
Setting up a Demo database in Azure SQL Database
Firstly, I've created a SQL database in Azure for this blogpost. Go to Microsoft Azure and search for Azure SQL database and click on Create.
These are the standard settings for a SQL Database and I choose nothing to change here.
I take the smallest database setting in order to save expenses.
Click through the tabs until you see the the Additional Settings. Here I select the AdventureWorksLT Database.
And we are finished in Microsoft Azure.
Step 1 : Create the Data Lakehouse
The next step is to create a Lake house in Microsoft Fabric. Click on Lake House (Preview).
Enter a name for the Lake house and press Create.
There are "Files" and there are "Tables" folders in Lake House. Now the tables are managed by Fabric and the files are unmanaged. In the files section we are going to build a Data lake.