This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 37%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
How to connect from SSMS or azure data studio to azure databricks delta lake? I am looking for a capability similar to https://docs.databricks.com/integrations/bi/workbenchj.html
This is not about moving delta lake tables into synpase or sql server . Also not about querying delta lake tables from synpase serverless sql pool.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi @prasadvaze ,
Thanks for using Microsoft Q&A !!
As per my understanding, you want to use only SSMS/Azure Data Studio to Azure Databricks Delta Lake.
As far as I know, it is not possible to use either of these two tools to connect to Azure Databricks delta lake. In case you want to use any other tool, you could however use DbVisualizer tool for the connection.
If you want to use only SSMS or Azure Data Studio, could you please help providing detailed use case so that I can internally provide your feedback to the products team? You can also provide your feedback over Azure Databricks feedback site over here so that community can upvote and products team can plan to include the feature in the available tooling.
Thanks
Saurabh
Hi @prasadvaze ,
We haven't heard back from you. Just wanted to check if you are able to look into my previous reply.
Thanks
Saurabh
Hi @prasadvaze ,
We haven't heard back from you. Just wanted to check if you are you still facing the issue? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Thanks
Saurabh
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
How do you use dbVisualizer to connect to Azure Databricks Delta Lake?
I can use Microsoft Access to connect to Azure Databricks Delta Lake, so it must be possible to use SSMS and Azure Data Studio to do the same.
@Saurabh Sharma : I'm guessing it's not possible to use SSMS to connect to DataBricks lakehouse, but is it possible to use SSMS to connect to a lakehouse inside Microsoft Fabric?
NOTE: I'm wondering if this might be one reason a team might chose Microsoft Fabric over DataBricks.