DataBricks SQL: ODBC url to connect to DataBricks SQL tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-01-2023 02:03 AM
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?
- Labels:
-
Databricks SQL
-
Odbc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-01-2023 02:24 AM
Hi @Manu Kumarโ ,
Can you please mention the error that you are getting while connecting through ODBC?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-01-2023 02:44 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-01-2023 04:57 AM
Do you have the correct driver installed? https://docs.databricks.com/integrations/jdbc-odbc-bi.html#download-the-odbc-driver
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-05-2023 12:26 AM
This. I think you're using the MSSQL (SQL Server) driver. You need the one for Databricks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-16-2023 10:35 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-16-2023 10:42 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-21-2023 06:32 AM
@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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ04-11-2023 01:14 AM
Hi @Nathan Anthonyโ - Yes, we have reached out to Hasura team. For now, they don't support connection with Databricks SQL.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ03-21-2023 11:15 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ04-14-2023 12:35 AM
Hi,
Can you please try to connect once after disabling VPN in your local system (if its enabled)?
Thanks.