Forum Discussion
Responsive ResidentImplementing Medallion Architecture in Fabric : Bronze Layer ingesting data from a SQL Server
Hi alfBI if you take a look at this document there is a section "Medallion architecture in Fabric" which says "In a typical medallion architecture implementation in Fabric, the bronze zone stores the data in the same format as the data source. When the data source is a relational database, Delta tables are a good choice"
https://learn.microsoft.com/en-us/fabric/onelake/onelake-medallion-lakehouse-architecture
Are you looking at creating a pure landing zone before your bronze/raw zone? Depending on your source data it may not be necessary to have a landing zone.
Most Valuable ProfessionalHi alfBI if you take a look at this document there is a section "Medallion architecture in Fabric" which says "In a typical medallion architecture implementation in Fabric, the bronze zone stores the data in the same format as the data source. When the data source is a relational database, Delta tables are a good choice"
https://learn.microsoft.com/en-us/fabric/onelake/onelake-medallion-lakehouse-architecture
Are you looking at creating a pure landing zone before your bronze/raw zone? Depending on your source data it may not be necessary to have a landing zone.
daircomResolver II
AndyDDC ,
If I move a file to the bronze layer I should transform it into a table right? (using a notebook for example)
Is the table also supposed to be in the bronze layer (so that both the file and the table it is based on are in the bronze layer), or should the file be in the bronze layer and the table based on the file in the silver layer?