MariuszK
Valued Contributor III

For orchestration you can use Databricks workflows or ADF.
The organization for lakehouse should be:

Staging -> bronze
gold -> "Data Warehouse" / Data marts
You can read more here about migration and how to replicated data warehouse to medalion:
https://medium.com/@mariusz_kujawski/migration-from-oracle-data-warehouse-to-databricks-lakehouse-6e...