Microsoft Fabric: Role of the Silver Lakehouse in the Medallion Architecture

The Silver layer is where we apply standardization to our source datasets. This standardization aligns field names across sources, applies common data cleaning operations and organizes the data into a well known structure. The Silver layer, which is generally stored at full-fidelity (i.e. the granularity of the data is the same in the Silver layer as it is in the Bronze layer) provides the foundation for the Gold layer, where we may have many projections of the Silver data in different forms and at different granularities, depending on the downstream need.

In this video we're going to talk about the role the Silver Lakehouse plays in the Medallion architecture, including what it's used for and whom it benefits.

00:00 Intro
00:13 Architecture diagram recap
01:18 Silver Lakehouse principles
04:10 Why is the Silver Lakehouse useful?
04:38 Who is the Silver Lakehouse for?
05:48 Roundup & Outro

Useful links:

📖 Microsoft Fabric Medallion Architecture official docs: https://learn.microsoft.com/en-us/fab...

Series contents:

📺 Part 1 - Lakehouse & Medallion Architecture -    • Microsoft Fabric: Lakehouse & Medalli...  
📺 Part 2 - Planning and Architecting a Data Project -    • Microsoft Fabric: Inspecting 28 MILLI...  
📺 Part 3 - Ingest Data -    • Microsoft Fabric: Ingesting 5GB into ...  
📺 Part 4 - Creating a shortcut to ADLS Gen2 in Fabric -    • Microsoft Fabric: Creating a OneLake ...  
📺 Part 5 - Navigating OneLake data locally -    • Microsoft Fabric: Local OneLake Tools  
📺 Part 6 - Role of the Silver layer in the Medallion Architecture - THIS VIDEO!
📺 Part 7 - Processing Bronze to Silver -    • Microsoft Fabric: Processing Bronze t...  
📺 Part 8 - Good Notebook Development Practices -    • Microsoft Fabric: Good Notebook Devel...  

If you want to learn more about Fabric, take a look at some of our other content:

🤖 [Course] Microsoft Fabric: from Descriptive to Predictive Analytics:    • Microsoft Fabric: Machine Learning Tu...  
👉 Perspectives on #MicrosoftFabric: https://endjin.com/what-we-think/talk...
👉 A Tour Around #MicrosoftFabric: https://endjin.com/what-we-think/talk...
👉 Introduction to #MicrosoftFabric: https://endjin.com/blog/2023/05/intro...

and find all the rest of our content here: https://endjin.com/blog/2023/05/micro...

#Microsoft #PowerBI #MicrosoftFabric #lakehouse #datalake #onelake #data #ai #analytics #medallion #bronze #silver #gold