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
Esteemed Contributor III
Esteemed Contributor III

@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.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!