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: 

Forum Posts

ManuShell
by New Contributor III
  • 6557 Views
  • 10 replies
  • 7 kudos

DataBricks SQL: ODBC url to connect to DataBricks SQL tables

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?

  • 6557 Views
  • 10 replies
  • 7 kudos
Latest Reply
Sumit_Kumar
New Contributor III
  • 7 kudos

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

  • 7 kudos
9 More Replies
sondrewb
by New Contributor III
  • 5646 Views
  • 4 replies
  • 7 kudos

Resolved! Fastest way to get data into PowerBI

Hello. Databricks can be connected with PowerBi to visualize data. The process is described here. Of the various approaches described there, what is the fastest for large amounts of data? Are there even any difference in performance for the different...

  • 5646 Views
  • 4 replies
  • 7 kudos
Latest Reply
Anonymous
Not applicable
  • 7 kudos

Hi @sondrewb​ you can connect BI tools to Databricks SQL endpoints to query data in tables through an ODBC/JDBC protocol integrated in our Simba drivers. With Cloud Fetch, which we released in Databricks Runtime 8.3 and Simba ODBC 2.6.17 driver, we ...

  • 7 kudos
3 More Replies
User16753724663
by Valued Contributor
  • 5066 Views
  • 1 replies
  • 0 kudos

Unable to use JDBC/ODBC url with sql workbench

SQL Workbench is not able to connect to Cluster using JDBC/ODBC connection. Getting the following error. I used the configuration provided by the cluster (jdbc:spark://<host>.cloud.databricks.com:443/default;transportMode=http;ssl=1;httpPath=sql/prot...

  • 5066 Views
  • 1 replies
  • 0 kudos
Latest Reply
User16753724663
Valued Contributor
  • 0 kudos

As we are getting 401 error that means an authentication issue. We should use Personal access token for password.The username should be "token" and the password should be PAT token.

  • 0 kudos
Labels