Hi Team.
One simple case and i need your help.
I have 140 csv files that i want to implement medallion architecture.
In Bronze layer i'm using a lakehouse as a landing area, using copy data from exernal source with schedule trigger.
In Silver layer should i use lakehouse too? How do i get those files from bronze to silver?
In silver i only need to append the files and rename columns, clean data.
From silver to gold, same question: Lakehouse or Warehouse? It is similar to a sql table, only structured data