[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1056) about databricks-sql-python

[susodapop]

It seems the exception is due to a self-signed certificate somewhere in the chain.

You can disable SSL entirely by adding _tls_no_verify=True to your connection arguments when building a connection.

For example:

from databricks import sql
import os

with sql.connect(server_hostname = os.getenv("DATABRICKS_SERVER_HOSTNAME"),
                 http_path       = os.getenv("DATABRICKS_HTTP_PATH"),
                 access_token    = os.getenv("DATABRICKS_TOKEN"),
                 _tls_no_verify=True) as connection:

...

[nicolai-at-ruhrdot]

@susodapop Thank you! The problem turned out to be a local one (using Pipenv on macOS with an M2 chip). Certificates were not properly installed for my Python version, resulting in the virtual environment not being able to access them and receiving the SSL CERTIFICATE_VERIFY_FAILED error.

I was able to solve this with the following command, if anyone on Mac is having the same problem:
/Applications/Python\ 3.7/Install\ Certificates.command

[susodapop]

Thanks for sharing your solution!