Hello Rjdudley,

To answer your first part, no we don't need to copy or migrate data.
We are supposed at a point in time to leave Oracle and do everything in Databricks. This is at least what we are asked to evaluate, based on the current needs and all things implemented since a so long time in Oracle.
Your description of bronze, silver and gold is exactly the logic we already have in the structure we organized in Oracle, even if of course we are not using this terminology.
At least, on the functional side, what is described with Bronze, Silver and Gold is the same as what we already do in Oracle and what we plan to do in Databricks.
You said: " You can share data directly from Databricks to reporting tools like PowerBI or Tableau without copying the data.". I don't really understand this, sorry.
" 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..