Using the metastore for data lakehouse I have several follow up questions to your answer:

  1. Will companies generally have only one database that represents the data lakehouse?
  2. Will bronze tables be kept in the above database or will it have a separate database just for source data, or no database assignment at all?
  3. Files brought into as bronze tables will converted to Delta/Parqette?
  4. Will tables created in Silver tier be named with silver as a prefix or suffix, and if not how can we differentiate the silver tables from the gold?

I have not seen the best practice naming conventions anywhere.