How to Create Lakehouse in Microsoft Fabric

What is Lakehouse architecture?

Lakehouse architecture is the modern data management architecture that combines data lakes and data warehouses. The intent is to reduce data redundancy and the complex process of updating data at multiple locations using complex data-sharing strategies. 

In this architecture, data resides in one place and can be shared across all platforms, from development to analytics. This ensures that there are a lot of benefits listed below.

  • Improved data consistency, removes data silos.
  • More control over data
  • Single source of truth
  • There is less overhead to organizing and managing data
  • Cost-effective

What is Microsoft Fabric?

Microsoft Fabric is a new offering by Microsoft that unifies all the data needs, from data gathering to delivering intelligent solutions. You can do almost everything on this platform that requires any kind of interaction with data.

Building the first Lakehouse in Microsoft Fabric

1. From the Fabric home page, select the 'Data Engineering' tile.

2. Create a workspace in Microsoft Fabric; in my case, it is 'dp_engineering'.

3. Create a lakehouse in Microsoft Fabric; click on the Create navigation item on the left side.

4. Select lakehouse; assign a name to the lakehouse; in my case its 'varun_demo_lakehouse'.

5. Wait for a minute, and you will get the view below.

Lakehouse 

Our lakehouse view looks like the one below.

Lakehouse Demo

6. Now, click Start with sample data on the lakehouse homepage.

7. Once ready, you can select the explore option from the top right.

Lakehouse explorer

Below is the view of the SQL analytics endpoint.

SQL Query to view SQL analytics endpoints

Finally, continue to explore your data engineering journey.

I will keep on posting more articles in the coming days.


Similar Articles