Unity Catalog + Medallion Architecture

shane_t
New Contributor II

I am looking for a reference architecture or an example on how to organize unity catalog while adhering to the medallion architecture.

What are some common naming conventions and methods?

How to you isolate environments (dev/prod)?

I was thinking of something like this:

- One "catalog" per environment.

- One "schema" per  set of tables with gold/silver/bronze versions

Example:

lakehouse_dev (catalog)

- bronze_widgets (schema)

  -- table1_bronze, table2_bronze, etc

- silver_widgets (schema)

  -- table1_silver, table2_silver, etc

- gold_widgets (schema)

 -- table1_gold, table2_gold, etc

lakehouse_prod (catalog)

- bronze_widgets (schema)

  -- table1_bronze, table2_bronze, etc

- silver_widgets (schema)

  -- table1_silver, table2_silver, etc

- gold_widgets (schema)

 -- table1_gold, table2_gold, etc

I'd love get get some other peoples thoughts on how they have implemented this in their organization.  Thanks!