Issue with Lakebridge transpile installation – SSL Certificate Error

[aravindan_tk]

Hi Team,

I am trying to use Lakebridge to test a small piece of code for conversion. The base installation of Lakebridge worked fine, but when I attempt to install transpile, I encounter SSL-related errors. I even tried to hardcode of the certificates still failing.

Environment & Versions Tried

• Python 3.13

   

  22:40:24 ERROR [src/databricks/labs/lakebridge.install-transpile] URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Missing Authority Key Identifier (_ssl.c:1032)>

  • Python 3.10 & 3.11

     

    Could not fetch URL https://pypi.org/simple/pip/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host='pypi.org', port=443): Max retries exceeded with url: /simple/pip/ (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:997)'))) - skipping

    What I Tried

    • Tested with multiple Python versions (3.10, 3.11, 3.13)

    • Installation of base Lakebridge works fine

    • Error only occurs while installing transpile

      Has anyone faced a similar issue? Could you please guide me on how to resolve the SSL certificate verification error during transpile installation?

      Thanks in advance!