Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
shivam_agarwal
New Member

setup of medallion architecture

Hi all, I'm relatively new to MIcrosoft Fabric. I am going through the docs but as a beginner, it is really getting overwhelming.I wanted to know what is the step by step process to setup a medallion architecture?

2 ACCEPTED SOLUTIONS
govindarajan_d
Solution Supplier
Solution Supplier

Hi @shivam_agarwal ,

 

There are multiple ways you can setup Medallion architecture:

Using Lakehouses/Warehouses and each zone (bronze, silver and gold) in separate workspace. This is advantageous as you can separate the access based on workspace. But I found it to be effective only if I use entirely Lakehouse or Warehouse. If you need Spark, then you can go entirely with Lakehouse or else just Warehouse if you plan to use plain T-SQL. This boils down to the skillset of the team.  

 

The other approach would be having all three layers in same workspace or just silver and gold in same workspace so that you can mix Lakehouse/Warehouse very easily as both silver and gold are in the same workspace. 

 

For a more step-by-step process, follow this exercise:

mslearn-fabric (microsoftlearning.github.io)

 

View solution in original post

AndyDDC
Solution Sage
Solution Sage

I have a part 1 in a small series where I'm looking at medallion architecture and what data loading options there are 

 

https://www.serverlesssql.com/lakehouse-zones/

View solution in original post

2 REPLIES 2
AndyDDC
Solution Sage
Solution Sage

I have a part 1 in a small series where I'm looking at medallion architecture and what data loading options there are 

 

https://www.serverlesssql.com/lakehouse-zones/

govindarajan_d
Solution Supplier
Solution Supplier

Hi @shivam_agarwal ,

 

There are multiple ways you can setup Medallion architecture:

Using Lakehouses/Warehouses and each zone (bronze, silver and gold) in separate workspace. This is advantageous as you can separate the access based on workspace. But I found it to be effective only if I use entirely Lakehouse or Warehouse. If you need Spark, then you can go entirely with Lakehouse or else just Warehouse if you plan to use plain T-SQL. This boils down to the skillset of the team.  

 

The other approach would be having all three layers in same workspace or just silver and gold in same workspace so that you can mix Lakehouse/Warehouse very easily as both silver and gold are in the same workspace. 

 

For a more step-by-step process, follow this exercise:

mslearn-fabric (microsoftlearning.github.io)

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

Top Solution Authors