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?