Best practice for organizing data objects using Unity Catalog

ossinova
Contributor II

I was wondering if there is a best practice or recommended way to organize data objects (tables) in Unity Catalog.

Following the medallion architecture, how should one organize and name these three namespaces:

  • Catalog(s)
  • Schema(s)
  • Table(s)

Example:

  • Catalog: environment specific (dev / test / prod)
  • Schema: layer specific (bronze / silver / gold)
  • Table: tablename (sourceX_employee)

Example2:

  • Catalog: environment and source specific (dev_sourceX / test_sourceX / prod_sourceX)
  • Schema: layer specific (bronze / silver / gold)
  • Table: tablename (employee)

How are you organizing your tables?