Databricks: SQL Warehouse Delta table JDBC PKIX Error

Question

I have created delta table and able to run the query from SQL Warehouse. But when I try to connect using JDBC from local machine, I am getting below error. For PKIX error, I know we need to import the certificate in to JRE. How to get the cert file for JDBC connection? Or is there any other way to fix this error?

Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Answer 1

Hello @Shastri, Madhusudan (KT) ,
Thanks for the question and using MS Q&A platform.

As we understand the ask here is how tio get rid of the mentioned error , please do let us know if its not accurate.
Let me start with the fact that I do not have an environment to test this . I did found out the below ask with the same error and I think you can have a look .
https://knowledge.informatica.com/s/article/000174467?language=en_US
Please do let me if you have any queries.
Thanks
Himanshu

---

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators