---

" gold layer is the most processed and curated": the equivalent of this layer in Oracle is based on complex queries, and the results of this queries are materialized in tables. Do you mean that in Databricks I should not materialize this data? Sorry, I'm getting lost..

 You absolutely should materialize this data.  What I am saying is after this is calculated you can keep it in your Databricks gold layer, you don't need to copy it anywhere else.  You can use Delta Sharing to connect Power BI or Tableau directly to Databricks.  Saves you some work and gives you better data governance.