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?

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.