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

[PaulMarsh]

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

[Kaniz_Fatma]

Hi @PaulMarsh, 

1. • Consider using connection pooling to improve connection performance. Connection pooling maintains a pool of reusable connections, reducing the overhead of establishing new connections.
   • In your connection string, try adding the following parameters:

     server=MyServer;database=MyDatabase;Min Pool Size=1;Max Pool Size=100
     

     This configuration ensures that the connection pool always maintains at least one connection and can...¹.
   • Note that while this approach can solve the delay issue, it’s generally recommended to avoid persistent connections unless necessary.

[PaulMarsh]

@Kaniz_Fatma 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