cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Python databricks sql.connect takes 10minutes exact to connect to Serverless SQL Datawarehouse

PaulMarsh
New Contributor II

โ€Ž06-28-2024 08:33 AM

Have tried this with both the SQL Warehouse up and running and turned off. The connection eventually is made and works without issue, but the initial connect() takes 10minutes to establish. 

No other connectivity issues between the box and the Warehouse. And it is a consistent 10minutes. Any thoughts are much appreciated.

Python 64-bit 3.12

Databricks-sql-connector 3.2

 

0 Kudos
1 REPLY 1

PaulMarsh
New Contributor II

โ€Ž07-01-2024 11:16 AM

@Retired_mod thank you for the reply, it seems the issue came down to the script was running with Python 3.12 and I should have been using 3.11.9

 

0 Kudos

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
Announcements