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

[MathieuDB]

Hello @Akshith_Rajesh,

In order to connect Trino to Unity Catalog HMS, please use this configuration instead:

hive.metastore.uri=https://<DATABRICKS_HOST>:443/api/2.0/unity-hms-proxy/metadata
hive.metastore.http.client.bearer-token=${ENV:DATABRICKS_TOKEN}
hive.metastore.http.client.additional-headers=X-Databricks-Catalog-Name:<DATABRICKS_UNITY_CATALOG_NAME>
hive.metastore.http.client.authentication.type=BEARER