- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2025 09:17 AM
@chexa_WeeIf both projects (databricks) are in different cloud regions, you can have 2 metastores which is a straight forward implementation. Otherwise, below are the possibilities.
Easiest Approach - You can’t have two metastores unless they are in separate cloud regions. In your case, I recommend creating a catalog for each of Bronze, Silver, and Gold, and then setting up project-specific schemas and objects within those catalogs.
Complex with more admin maintenace
If you have more than one storage, then ofcourse, you can have a setup like below. However, you end up with more catalogs and lot maintenance on admin side.
Storage1
Catalog11(Bronze) -- Schema -- Objects
Catalog12(Silver) -- Schema -- Objects
Catalog13(Gold) -- Schema -- Objects
Storage2
Catalog21(Bronze) -- Schema -- Objects
Catalog22(Silver) -- Schema -- Objects
Catalog23(Gold) -- Schema -- Objects
Having more catalogs and storage layers can also lead to more complex data governance and maintenance efforts. Please mark this as a solution if it addresses your question.