question

CourtneyHaedke-0265 avatar image
0 Votes"
CourtneyHaedke-0265 asked PRADEEPCHEEKATLA-MSFT commented

Can't Access Synapse Spark Pool Databases on SSMS

Since I've starting using Azure Synapse Analytics, I created a Spark Pool Cluster, then on the Spark Pool cluster I created databases and tables using Pyspark on top of parquet files in Azure Data Lake Store Gen2.
I use to be able to access my spark Database/ parquet tables through SSMS using the Serverless SQL endpoint but now I can no longer see my spark Databases through the Severless SQL Endpoint in SSMS. My spark databases are still accessible through Azure Data Studio but not through SSMS. Nothing has been deployed or alter on my side. Can you help resolve the issue? I would like to be able to access my spark databases through SSMS.
98290-sparkpoolissue.jpg


98349-azuresynapsesql.jpg


Then all of a sud

azure-synapse-analyticsazure-data-lake-storage
sparkpoolissue.jpg (19.8 KiB)
azuresynapsesql.jpg (21.5 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @CourtneyHaedke-0265,

Thanks for the question and using MS Q&A platform.

What do you mean by Can't Access Synapse Spark Pool Databases on SSMS? Do you mean you are not able to see the databases on SSMS or unable to access the databases on SSMS.

When you say Can't Access Synapse Spark Pool Databases on SSMS are you experiencing any error message while accessing the database?

0 Votes 0 ·

On Sql Server Management Server there are databases. I was able to access the databases I created on a my spark pool cluster in Synapse analytics using Sql Server Management Studio. Now I no longer have that ability. I do not get an error the database just don't appear.

0 Votes 0 ·

Hello @CourtneyHaedke-0265,

Could you please share the both screenshots of SSMS and Azure Data Studio?

0 Votes 0 ·
Show more comments

0 Answers