@Walter_C  @Rjdudley 

Thank you both for the reply. However, my question is: Unity Catalog is not just catalogs, schemas, and tables, right? Even if we configure the desired external location for these, other things are still being stored in the metastore, which itself is in an undesired location. The issue I see is that the storage location of the metastore is not modifiable. It seems we need to create a new metastore and remove the old one. I'm wondering how we can do this without losing data.

Thanks for your attention!