Share via

Can you connect to an Azure Synapse Analytics Spark cluster through SSMS?

Courtney Haedke 151 Reputation points
2020-12-22T15:19:52.11+00:00

Hi All,

I'm new to Azure Synapse Analytics and would like to use the Spark Cluster feature.
My team are SSMS SQL users and would like to query the data on a Spark Cluster through SSMS.
I know the Serverless SQL endpoint link can be used was curious if there was a similar link with the spark feature.

Thanks,
Courtney

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,378 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,921 Reputation points Volunteer Moderator
    2020-12-22T15:45:48.66+00:00

    I don't think so. SSMS is more on running SQL language Queries

    You will have to use Notebooks in synapse studio and there Spark SQL, Scala, Python, .Net languages can be used

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.