yes you're right, metastore can be shared between workspace and it is an isolated for example the first time when we create a workspace with Aws (because i familiar with it) an default hive metastore will be created. And later then we can create a new metastore and can connect that metastore to exist workspace so now we have two metastore for using​ purpose.