cancel
Showing results for 
Search instead for 
Did you mean: 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting to Databricks using Python(VS Code)

Ankur_K
New Contributor II

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-clus...
https://community.databricks.com/t5/data-engineering/how-can-i-resolve-this-ssl-error-which-occurrs-...

1 REPLY 1

Ankur_K
New Contributor II

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. 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group