Connecting Delta Tables from any Tools

Databricks_7045
New Contributor III

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
Databricks Employee
Databricks Employee

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.

View solution in original post

Anonymous
Not applicable

Hi @Rajesh Vinukonda​ 

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