In this data recipe series, Microsoft Fabric – Data Warehouse will be explored. As a starting point, a blank Fabric workspace is used. You can sign up for a free Fabric trial by using the following URL: Data Analytics | Microsoft Fabric
In this data recipe, we will create a brand-new Data Warehouse in Fabric. Once created, we will connect to our Data Warehouse using Azure Data Studio.
Recipe Overview
Preparation time: 10 minutes
Ingredients
- Microsoft Fabric – Data Warehouse
- Azure Data Studio
Step-by-Step Recipe
As a first step, we need to sign in to Microsoft Fabric. To sign in, we can use the following URL: https://app.fabric.microsoft.com/. As soon as we have signed in, we navigate to the bottom left corner where we can choose the Fabric experience we would like to have.
In our case, we will be choosing Synapse > Data Warehouse. You can access this menu by clicking on the icon in the bottom left corner. (any of the icons shown in the image below can be visualized)
Fabric Cooking Tip
Depending on the chosen Fabric experience, you will get different options when clicking on the “New” Button.
As a next step, we create our brand new data warehouse by clicking the “New” button in the top left of the center screen, just beneath your workspace name.
In the extensive list, we search for “Warehouse” and confirm by clicking on the Warehouse.
Now we provide the name for the warehouse, in my case I choose, wh-bite-size-data.
As soon as we confirm by clicking the Create button, our new Data Warehouse in Fabric is created.
Connect from Azure Data Studio
To create the connection from Azure Data Studio to our newly created Fabric Data Warehouse, we first navigate to the settings icon in the top left corner (when you are in the Warehouse)
After clicking the settings icon, navigate to the About section and at the bottom of the page, you can find the SQL connection string that we need.
As a next step, we open Azure Data Studio and create a new Connection. We choose Microsoft SQL Server as the Connection type, and we will be using Parameters as the input type. This may seem a bit confusing though.
As a server, you paste the copied connection string from your warehouse. As the Authentication type, choose Microsoft Entra ID. To complete the authentication process, choose the account that you want to use to connect with the Fabric Data Warehouse.
Once the authentication is configured, you can choose the database you want to connect to. In my case, my wh-bite-size-data.
Finally, we click the Connect button. If everything goes right, you should be successfully connected.
Enjoy your cooking adventure!
Bon appétit!