We've done similar on AWS, If this is regarding setting up backend storage for the metastore it can have a separate one (Ideally it should). Each catalog for each business unit/ workspace can have its own backend data lake too. This one would override the central one for storing managed table data. Metadata would point only to the root backend. Not sure if I answered your question. Or whether this is still an issue.