cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

How can we connect to the databricks managed metastore

AP
New Contributor III

Hi, I am trying to take advantage of the treasure trove of the information that metastore contains and take some actions to improve performance. In my case, the metastore is managed by databricks, we don't use external metastore.

How can I connect to the metastore and query it. I scanned the cluster logs to see some entries that has the JDBC information, but the user ID is really vague and password of course not available.

2 REPLIES 2

Prabakar
Databricks Employee
Databricks Employee

@AKSHAY PALLERLA​ to get the jdbc/odbc information you can get it from the cluster configuration.

In the cluster configuration page, under advanced options, you have JDBC/ODBC tab. Click on that tab and it should give you the details you are looking for.

image

AP
New Contributor III

Thanks Prabakar. I appreciate your response. However, I already have the details. Now, my question is what do I do with those details? I have the details in the following format

config=DbMetastoreConfig{host=somemetastoreprefix.mysql.database.azure.com, port=xxxx, dbName=orgnxxx, user=randomvalues@somemetastoreprefix})

DataSource Jdbc URL: jdbc:mariadb://somemetastoreprefix.mysql.database.azure.com:xxxx/orgxxx?useSSL=true&sslMode=VERIFY_CA&disableSslHostnameVerification=true&trustServerCertificate=false&serverSslCert=/databricks/common/mysql-ssl-ca-cert.crt

Specifying those in the options tab you in this case is not necessary since Databricks Run time will take care of establishing connectivity since it is a managed resource.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group