DataBricks SQL: ODBC url to connect to DataBricks SQL tables

[ManuShell]

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?

[Ajay-Pandey]

Hi @Manu Kumar​ ,

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

[ManuShell]

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

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]

Do you have the correct driver installed? https://docs.databricks.com/integrations/jdbc-odbc-bi.html#download-the-odbc-driver

[BilalAslamDbrx]

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

[Anonymous]

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]

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]

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

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

Thanks

[Anonymous]

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]

Hi,

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

Thanks.