- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2025 06:27 PM
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.