K_Anudeep
Databricks Employee
Databricks Employee

Hello @dbernstein_tp ,

Generally, UC has a three-level naming convention: catalogue.schema.table, and currently, you are using something like staging.S_D.SCHEMA1_TableName

In my opinion, the right way to name it is to use staging.S_D_SCHEMA1.TableName, to represent the source schema instead of including it in the table name and also because it matches the medallion convention <env>_<zone>.<source_system>_<db>_<schema>.<table>

Therefore, as a best practice, I would suggest maintaining a single staging catalogue for bronze, but using one UC schema per source schema (or per source system). Avoid encoding the schema name into the table name when you can encode it into the UC schema level instead.
 

 
Anudeep

View solution in original post