“Unveiling the Magic: Crafting Your Dream Lakehouse in MS Fabric”

Shreya Mewada
AnalyticsHere
Published in
3 min readJul 16, 2023

Crafting Your Own Lakehouse Using MS Fabric

Fabric Overview:

Microsoft Fabric is a comprehensive corporate analytics solution that includes everything from data migration to data science, real-time analytics, and business intelligence. It provides a full set of services in one location, including data lake, data engineering, and data integration.

Fabric eliminates the need to patch together various services from various sources.

What is a Lakehouse?

Microsoft Fabric Lakehouse is a data architecture platform that allows you to store, manage, and analyze structured and unstructured data in one place. It is a scalable and adaptable system that enables organizations to process and analyze enormous amounts of data using several tools and frameworks. It connects with other data management and analytics applications to provide a complete data engineering and analytics solution.

How can you create a Lakehouse in Fabric?

Click on Power BI in the left-hand option below and select the data engineering option, as highlighted in the image:

Now, after clicking the Data Engineering option, check out the first page for Synapse Data Engineering:

Click on the Lakehouse (Preview), and the following pop-up will appear after clicking.

Name yourself Lakehouse with your choice of name. After adding your name and clicking on Create, you're lakehouse will be created

How can we upload a dataset to Lakehouse?

We have already seen how to make a Lakehouse, but if you want to add some files to it, it is very simple to do.
Let's see how we can add the files to it, Click on the file option, and you can add files to it by clicking on the upload option.

Click on the Upload files, and if you want to add new files to it, you can add them or if you want to overwrite existing files, you can just do it by clicking on the below option

Now you have successfully uploaded a file, and you can get an overview of the dataset you have uploaded:

Check out the earlier articles on fabric as well:
https://medium.com/analyticshere/unleash-the-power-of-onelake-the-ultimate-data-oasis-for-seamless-storage-and-collaboration-d2dec0ec950c

https://medium.com/analyticshere/microsoft-fabric-9e3f7f3c3e9a

--

--

Shreya Mewada
AnalyticsHere

Data Engineer @ FedEx | Building Pipelines |Helping Data 📊 to reach its Target📈