cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

1 ACCEPTED SOLUTION

Accepted Solutions

BilalAslamDbrx
Honored Contributor II
Honored Contributor II

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

2 REPLIES 2

BilalAslamDbrx
Honored Contributor II
Honored Contributor II

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
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?