Connecting to Databricks using Python(VS Code)

Ankur_K — Sun, 22 Oct 2023 07:04:19 GMT

I'm trying to connect to tables/views in Databricks using Python(via VS Code). However, I'm getting the following error:-
File "C:\Users\XXXXXXXX\AppData\Roaming\Python\Python311\site-packages\urllib3\util\retry.py", line 592, in increment
raise MaxRetryError(_pool, url, error or ResponseError(cause))
urllib3.exceptions.MaxRetryError: HTTPSConnectionPool(host='xxx-lakehouse-prod.cloud.databricks.com', port=443): Max retries exceeded with
url: /sql/1.0/warehouses/293f5a865d0f529e (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: CA signature digest algorithm too weak (_ssl.c:992)')))

NO LUCK although I've gone through several posts in Databricks:-
https://community.databricks.com/t5/data-engineering/importing-ca-certificate-into-a-databricks-cluster/td-p/7304
https://community.databricks.com/t5/data-engineering/how-can-i-resolve-this-ssl-error-which-occurrs-when-calling/td-p/20793

Re: Connecting to Databricks using Python(VS Code)

Ankur_K — Sat, 04 Nov 2023 01:43:43 GMT

Thanks Kaniz!
1. I've checked the SSL certificate which is up-to-date.
2. Also attempted Specify SSL i.e. Version usingssl.PROTOCOL_TLSv1_2instead ofssl.PROTOCOL_SSLv3. It shoots deprecated warning.
3 "Add CA Certificate to Trusted Store":- I exported and added to my windows path(certs file).
Long story short:- none of them worked out for me.
My hunch:- my organisation might have configured firewall which prevents unauthorised APIs and causing certificate error message. Just working out my platform team if they can assist. Otherwise we can close this.

topic Connecting to Databricks using Python(VS Code) in Get Started Discussions

Connecting to Databricks using Python(VS Code)

Re: Connecting to Databricks using Python(VS Code)