Shared Hive External Metastore Drop table issue

Soma
Valued Contributor

hi Team ,

We are using a shared hive metastore for connecting to dev and prod as

we need cross DB access for certain ML use-cases.

Currently we are having issues as "DROP TABLE COMMAND" directly drops the table without checking the underlying location

Have anyone have a suggestion for avoiding this scenario or how to add storage based authorizatino in databrick

https://cwiki.apache.org/confluence/display/Hive/Storage+Based+Authorization+in+the+Metastore+Server

Note: We cant have high concurrency cluster due to cost issues