Best practice for organizing data objects using Unity Catalog
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2023 07:46 AM
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?
Labels:
- Labels:
-
Organize
-
Unity Catalog