cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

DataBricks SQL: ODBC url to connect to DataBricks SQL tables

ManuShell
New Contributor III

Hello Everyone,

We are trying to connect DataBricks SQL warehouse using ODBC url but we are not able to do it. We can see only JDBC url in connection details which works fine.

Was anyone able to connect using ODBC url? Can someone please help?

10 REPLIES 10

Ajay-Pandey
Esteemed Contributor III

Hi @Manu Kumarโ€‹ ,

Can you please mention the error that you are getting while connecting through ODBC?

Ajay Kumar Pandey

Hi, Please see attached error and below is the url, we are using.Capture 

Driver={ODBC Driver 17 for SQL Server};Server=tcp:adb-8***************.9.azuredatabricks.net,443;HTTPPath=/sql/1.0/warehouses/75**********7;ThriftTransport=2;SSL=1;AuthMech=3;UID=token;PWD=dap**********************a

Anonymous
Not applicable

This. I think you're using the MSSQL (SQL Server) driver. You need the one for Databricks.

Anonymous
Not applicable

Hi @Manu Kumarโ€‹ 

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!

ManuShell
New Contributor III

Hi @Vidula Khannaโ€‹ 

No it is not resolved yet. We are trying to connect Databricks SQL from Hasura API and it seems that It is not supported.

NateAnth
Databricks Employee
Databricks Employee

@Manu Kumarโ€‹ , The Hasura application needs to provide the Databricks driver or a way for you to add your own drivers. Have you reached out to them to see if this is on their roadmap?

ManuShell
New Contributor III

Hi @Nathan Anthonyโ€‹  - Yes, we have reached out to Hasura team. For now, they don't support connection with Databricks SQL.

Thanks

Anonymous
Not applicable

Hi @Manu Kumarโ€‹ 

I'm sorry you could not find a solution to your problem in the answers provided.

Our community strives to provide helpful and accurate information, but sometimes an immediate solution may only be available for some issues.

I suggest providing more information about your problem, such as specific error messages, error logs or details about the steps you have taken. This can help our community members better understand the issue and provide more targeted solutions.

Alternatively, you can consider contacting the support team for your product or service. They may be able to provide additional assistance or escalate the issue to the appropriate section for further investigation.

Thank you for your patience and understanding, and please let us know if there is anything else we can do to assist you.

Sumit_Kumar
New Contributor III

Hi,

Can you please try to connect once after disabling VPN in your local system (if its enabled)?

Thanks.

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