Synapse, want to see my Spark Delta database in SSMS and query it

Question

I loaded some data from SQL server into a Spark Delta database. I have one database and one table.

My end goal is to be able to see, and for my colleagues to see, my database and table in SSMS.

I know some of the pieces, but not sure how to put it all together. Here's what I know.

I can query my delta lake table with a serverless pool and see data.

SELECT
    TOP 100 *
FROM
    OPENROWSET(
        BULK 'https://synap______s/',
        FORMAT = 'DELTA'
    ) AS [result]

I thought I saw a video on how to connect via SSMS but can't find.

Any help appreciated.

Answer 1

Hi @Computer Mike ,
Thankyou for using Microsoft Q&A platform and posting your query.
My understanding is that you have loaded the data using spark pool in lake database table. You want to see the table content using SSMS.

You can query Lake database as well as Serverless SQL database using Serverless SQL endpoints via SSMS.

To find the fully qualified server name:

• Go to the Azure portal.
• Select on Synapse workspaces.
• Select on the workspace you want to connect to.
• Go to overview.
• Locate the full server name under the section: SQL on-demand endpoint.

The server name for the serverless SQL pool in the following example is: showdemoweu-ondemand.sql.azuresynapse.net

Kindly refer to the supporting documents links provided below:
Connect to Synapse SQL using Serverless SQL pool
Connect to Synapse SQL with SQL Server Management Studio

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

I was never able to see my Delta Lake tables, but I didn't give it any effort. I created a database with sql serverless and defined logical tables over parquet files. I could see tables but not data. I gave my sql serverless login permissions in the Data Lake. Then I could see data.