topic Re: databricks_sql_connector not connecting in Data Engineering

databricks_sql_connector not connecting

Upendra_Dwivedi — Tue, 20 May 2025 07:33:22 GMT

Hi All,

I am trying to connect to sql warehouse using a databricks_oauth auth type using databricks-sql-connector.

from databricks.sql import connect conn = connect( server_hostname="https://adb-xxxxxxxxxxxxxx.azuredatabricks.net/", http_path="/sql/1.0/warehouses/xxxxxxxxxxxxxx", auth_type="databricks-oauth" )

Now this query is running like forever, not able to connect. is there any limitation to this auth type?.

Re: databricks_sql_connector not connecting

MuthuLakshmi — Tue, 20 May 2025 07:59:15 GMT

@Upendra_Dwivedi
Have you installed the databricks-sdk dependency?

https://docs.databricks.com/aws/en/dev-tools/python-sql-connector

Re: databricks_sql_connector not connecting

Upendra_Dwivedi — Tue, 20 May 2025 08:25:43 GMT

Hi,
I am doing U2M auth and in the documentation it is not mentioned to instyall databricks-sdk.

Re: databricks_sql_connector not connecting

Upendra_Dwivedi — Tue, 20 May 2025 08:27:34 GMT

Also, i am doing this in Databricks. so maybe there are some restriction and i am not aware for those.