Connecting Delta Tables from any Tools

[Databricks_7045]

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

[BilalAslamDbrx · Accepted solution]

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.

[Anonymous]

Hi @Rajesh Vinukonda​ 

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