09-21-2023 08:31 AM
The Notebook UI doesn't always provide the best experience for running exploratory SQL queries. Is there a way for me to use SQL Server Management Studio (SSMS) to connect to DataBricks?
See Also:
https://learn.microsoft.com/en-us/answers/questions/740986/how-to-connect-from-ssms-or-azure-data-st...
09-22-2023 12:50 AM
What you can do is define a SQL endpoint as a linked server. Like that you can use SSMS and T-SQL.
However, it has some drawbacks (no/bad query pushdown, no caching).
Here is an excellent blog of Kyle Hale of databricks:
Tutorial: Create a Databricks SQL Linked Server in SQL Server | by Kyle Hale | Medium
If you are in the MS ecosystem, his blog is definitely worth checking out.
09-22-2023 12:50 AM
What you can do is define a SQL endpoint as a linked server. Like that you can use SSMS and T-SQL.
However, it has some drawbacks (no/bad query pushdown, no caching).
Here is an excellent blog of Kyle Hale of databricks:
Tutorial: Create a Databricks SQL Linked Server in SQL Server | by Kyle Hale | Medium
If you are in the MS ecosystem, his blog is definitely worth checking out.
05-22-2024 11:06 AM
That looks like a pretty good solution, but some organizations aren't going to give developers the permission to implement something like that.
Also, not only is it a pain to connect SQL Server Management Studio (SSMS) to Databricks, but right now, it seems to also be a pain to connect Microsoft Power Apps to Databricks. I'm not a fan of Microsoft Power Apps personally, but some organizations practically mandate use of Microsoft Power Apps.
Microsoft doesn't seem to be particularly willing to help with these incompatibility issues. I think they would rather push Fabric instead of promoting Azure Databricks.
If Databricks, Inc. isn't interested in improving compatibility with Microsoft tools, they may wind up losing customers.
05-23-2024 12:30 AM
I think MS wants to make a closed ecosystem for data. If Databricks wants to go all-in on that it would mean dropping AWS/GCP. Bad decision IMO.
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group