All Content
explore our new search
Create your FIRST Lakehouse in Microsoft Fabric
Microsoft Fabric
Jun 13, 2023 3:00 PM

Create your FIRST Lakehouse in Microsoft Fabric

by HubSite 365 about Guy in a Cube

Data AnalyticsMicrosoft FabricLearning Selection

You started your journey into Microsoft Fabric. Ted wants to help you understand how to create your first Lakehouse and start getting data into OneLake!

Create your FIRST Lakehouse in Microsoft Fabric You started your journey into Microsoft Fabric. Ted wants to help you understand how to create your first Lakehouse and start getting data into OneLake! What is a lakehouse in Microsoft Fabric?…

Create a lakehouse in Microsoft Fabric…

Microsoft Fabric Lakehouse is a novel data architecture platform for storing, managing, and analyzing both structured and unstructured data. Its scalability and flexibility make it an ideal solution for managing large data volumes and leveraging diverse tools and frameworks for data processing and analysis. The platform is designed to integrate seamlessly with other data management and analytics tools for a comprehensive data engineering and analytics solution. However, it's important to note that as of now, Microsoft Fabric is in its preview phase.

One of the critical features of the Lakehouse is the creation of an SQL endpoint and a default dataset. This function enables users to work directly with delta tables in the lake, from data ingestion to reporting, ensuring a smooth and efficient user experience. However, the default warehouse is read-only, and it doesn't support the full T-SQL surface area of a transactional data warehouse. Also, only delta format tables are available in the SQL Endpoint; parquet, CSV, and other formats are not currently supported.

Another important function is the automatic table discovery and registration feature. With this, any file dropped into the Lakehouse's managed area is validated for structured formats and automatically registered into the metastore, saving time and effort for data engineers and scientists.

Interactions with the Lakehouse and its data can be done in several ways, including the Lakehouse explorer, notebooks, pipelines, Apache Spark job definitions, and Dataflows Gen 2. These options provide a range of flexibility and tools to make the most of the data stored in the Lakehouse, making it a versatile choice for diverse data needs.


Discover the Power of Lakehouse in Microsoft Fabric

A Lakehouse in Microsoft Fabric is a unified data platform that combines the capabilities of a data warehouse and a data lake. This innovation simplifies data architecture and allows organizations to leverage the benefits of both data storage systems in a single solution.

By creating a Lakehouse, you will be able to store structured and unstructured data, allowing for better data analysis and insights. You can also expect faster query processing and improved data governance, making your data-driven decision-making more efficient and powerful.

Start your journey into Microsoft Fabric by learning how to create your first Lakehouse and explore its capabilities to revolutionize your data storage and analysis strategies. Embrace the potential of this cutting-edge technology and boost your Power BI skills to new heights.


Read the full article Create your FIRST Lakehouse in Microsoft Fabric

Learn about Create your FIRST Lakehouse in Microsoft Fabric


Microsoft Fabric is a platform designed to help users manage and store data in a secure and efficient way. Lakehouse is a feature of Microsoft Fabric that allows users to store and analyze data in a unified repository. To create a Lakehouse in Microsoft Fabric, users must first create a data lake, which is a repository for storing and analyzing data in its raw format. Once the data lake has been created, users can then create a Lakehouse that is associated with the data lake. This allows users to query and analyze data in the data lake using the Lakehouse. Finally, users can use the Lakehouse to get data into OneLake, a platform for analyzing and visualizing data. Ted Vilutis is an expert in the field of Microsoft Fabric and can provide additional guidance on how to create a Lakehouse in Microsoft Fabric. For more information on how to use Microsoft Fabric, such as taking Power BI skills to the next level, visit Guy in a Cube courses.


More links on about Create your FIRST Lakehouse in Microsoft Fabric

Create a lakehouse, ingest sample data, and build a report
May 23, 2023 — Learn how to create a lakehouse, ingest data into a table, transform it, and use the data to create reports.
Create a lakehouse with OneLake - Microsoft Fabric
May 23, 2023 — In the upper left corner of the workspace home page, select New and then Show all. · Scroll down and choose Lakehouse under the Data engineering ...
Create a lakehouse - Microsoft Fabric
May 23, 2023 — Learn how to create a lakehouse from the Data Engineering homepage, the Workspace view, or the Create hub.
Lakehouse end-to-end scenario: overview and architecture
4 days ago — It helps you build a basic understanding of Fabric, including the different experiences and how they integrate, as well as the professional ...
What is a lakehouse? - Microsoft Fabric
May 23, 2023 — A lakehouse is a collection of files, folders, and tables that represent a database over a data lake used by Apache Spark and SQL for big ...
Options to get data into the Fabric Lakehouse
May 23, 2023 — In Microsoft Fabric, there are a few ways you can get data into a lakehouse: File upload from local computer. Run a copy tool in pipelines. Set ...
Prepare and transform data in the lakehouse
May 23, 2023 — From the list of existing notebooks, select the 01 - Create Delta Tables notebook and select Open. In the open notebook in Lakehouse explorer, ...
Integrating Microsoft Fabric with Databricks
May 30, 2023 — To demonstrate the above two approaches, you need to first create a Lakehouse database in your Fabric workspace as documented here.


Lakehouse, Microsoft Fabric, Ted Vilutis, Twitter, Guy in a Cube, Power BI