topic Connecting Delta Tables from any Tools in Data Engineering

Connecting Delta Tables from any Tools

Databricks_7045 — Thu, 03 Mar 2022 17:45:31 GMT

Hi Team,

To access SQL Tables we use tools like TOAD , SQL SERVER MANAGEMENT STUDIO (SSMS).

Is there any tool to connect and access Databricks Delta tables.

Please let us know.

Thank you

Re: Connecting Delta Tables from any Tools

BilalAslamDbrx — Fri, 04 Mar 2022 12:29:03 GMT

Hey there, there are lots of different ways to do this. Here's a quick summary:

Programmatically: You generally need running compute to query Delta tables. If you use a Databricks All Purpose Cluster, you can then query tables using JDBC/ODBC drivers.

Via a SQL tool: it's easy to connect to Databricks from lots of SQL tools using the JDBC driver. Some examples are here.

Re: Connecting Delta Tables from any Tools

Anonymous — Tue, 12 Apr 2022 16:29:43 GMT

Hi @Rajesh Vinukonda

Hope you are doing well. Thanks for sending in your question. Were you able to find a solution to your query?