topic Re: Connect to Databricks SQL Endpoint using Programming language in Warehousing & Analytics

Connect to Databricks SQL Endpoint using Programming language

Mat — Fri, 21 Mar 2025 12:55:24 GMT

Hi, I would like to know whether there is a feasibility/options available to connect to databricks sql endpoint using a programming language like java/scala/c#. I can see JDBC URL, but would like to whether it can be considered as any other jdbc connection string to execute a query and get the result.

Re: Connect to Databricks SQL Endpoint using Programming language

Mat — Wed, 18 May 2022 19:50:49 GMT

"Further to current Question(Not an answer 😞 )": Even 'Databricks SQL Connector', I can see this is available only for Python. Is there any databricks sql connector options available for scala/java/c# to execute query outside the databricks cluster to get the data. ?

Re: Connect to Databricks SQL Endpoint using Programming language

Håkon_Åmdal — Tue, 24 May 2022 10:06:13 GMT

Hi. As you say, you can use JDBC/ODBC to connect to the SQL endpoints with the drivers supplied by Databricks [1] [2]. For the programming language you want to use, use a JDBC interface/library to connect to the endpoints. For Java, this is built in [3]. For other languages, like python or go, you can use pyodbc [4] and alexbrainman/odbc [5] respectively.

[1] https://databricks.com/spark/jdbc-drivers-download

[2] https://databricks.com/spark/odbc-drivers-download

[3] https://www.javatpoint.com/java-jdbc

[4] https://github.com/mkleehammer/pyodbc

[5] https://github.com/alexbrainman/odbc

Re: Connect to Databricks SQL Endpoint using Programming language

Atanu — Thu, 26 May 2022 09:45:54 GMT

I think databricks connect will be feasible solution. https://docs.databricks.com/dev-tools/databricks-connect.html and JDBC driver also be an option. Please let me know if this helps. @Mathavan Mani

Re: Connect to Databricks SQL Endpoint using Programming language

StephanieAlba — Mon, 13 Nov 2023 23:58:52 GMT