Get the thrift hive.metastore.uri for Databricks unity catalog

[Akshith_Rajesh]

I am trying to connect to Unity catalog meta store tables using Presto 
Based on the presto documentation I need to use the below configuration to connect to delta tables in the unity catalog 

https://prestodb.io/docs/current/connector/hive.html

So from where can I get the hive metastore.URI from data bricks 

connector.name=hive
hive.metastore.uri=thrift://localhost:9083
hive.s3.aws-access-key=<s3-access-key>
hive.s3.aws-secret-key=<s3-secret-key>

#Databricks #UnityCatalog

[Kaniz_Fatma]

Hi @Akshith_Rajesh , In Databricks, the Hive metastore URI is not directly exposed to users. However, you can interact with the metastore using Spark SQL commands. If you're using an external metastore, the URI would be something you've configured and should have access to.

If you're trying to use the Glue Catalog as your metastore, you can enable it using the configuration spark.databricks.hive.metastore.glueCatalog.enabled=true. This configuration should be set before the cluster startup or before creating the SparkSession or SparkContext.