This issue is oddly only on an Azure Windows 10 VM. I Dont have this on my workstation or my personal computer so it seems to be host config related. The VM where the issue is i have a simple python script that connects to the Azure Databricks SQL endpoint and issues a query. If i run the script it can fail numerous times in a row and then randomly succeed. I did a Wireshark trace and found that the failure happened when the client tries to do a handshake with tls v1. There is no documentation on the connection about configuring the tls version and the fact that it works flawlessly on all other workstations tells me this Python Databricks Connector module is using system config somewhere to decide what version of tls to initiate a handshake with. To make things more interesting. I am using the exact same Python runtime and modules having copied the entire Python folder to the VM from a working desktop.
here is the issue captured via Wireshark
