Databricks Community

ManuShell · ‎03-01-2023

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 · ‎03-01-2023

Hi @Manu Kumar ,

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

Ajay Kumar Pandey

ManuShell · ‎03-01-2023

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 · ‎03-01-2023

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

BilalAslamDbrx · ‎03-05-2023

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

Anonymous · ‎03-16-2023

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 · ‎03-16-2023

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 · ‎03-21-2023

@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 · ‎04-11-2023

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

Thanks

Anonymous · ‎03-21-2023

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.