Connect to Databricks SQL Endpoint using Programming language

[Mat]

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.

[Mat]

"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. ?

[Håkon_Åmdal]

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

[Atanu]

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​ 

[Kaniz]

Hi @Mathavan Mani​, We haven’t heard from you on the last response from @Atanu Sarkar​ , and I was checking back to see if you have a resolution yet. If you have any solution, please do share that same with the community as it can be helpful to others. Otherwise, we will respond with more details and try to help.

[StephanieRivera]

I found a similar question on Stackoverflow https://stackoverflow.com/questions/77477103/ow-to-properly-connect-to-azure-databricks-warehouse-fr...