Databricks: SQL Warehouse Delta table JDBC PKIX Error

Shastri, Madhusudan (KT) 1 Reputation point
2022-07-19T04:16:52.423+00:00

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

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,845 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,281 Reputation points Microsoft Employee
    2022-07-19T21:19:07.13+00:00

    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 130616-image.png or upvote 130671-image.png 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