question

ShawnMathew-8116 avatar image
0 Votes"
ShawnMathew-8116 asked PRADEEPCHEEKATLA-MSFT commented

Azure Synapse data warehouse Connection string

I have a connection string for azure data warehouse synapse provided by a client. Im a total beginner and it would be a great help if someone could please explain the steps I have to take next to use this connection string to get access to the data table. I posted a question earlier regarding this but I'm still not clear.

Thanks

azure-synapse-analyticsazure-databricks
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.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @ShawnMathew-8116,

You can use multiple tools to access the data table.

For Dedicated SQL pool (formerly SQL DWH):

Step1: Go to Azure Portal => Select Dedicated SQL pool => Overview copy server name

84863-image.png

Step2: Open SSMS => Connect to database engine => Give the below details as shown below.

 Server name: servername.database.windows.net
 Authentication: SQL Server Authentication
 Login:admin
 Password:***********

84785-synapse-dedicatedpool-sssms.gif

For more details, refer Quickstart: Connect and query a dedicated SQL pool in Azure Synapse Analytics with SQL Server Management Studio (SSMS).


For Azure Synapse SQL pool:

Step1: Go to Azure Portal => Synapse Workspace => Overview => Copy any SQL endpoint

 Dedicated SQL endpoint :synapseworkspacename.sql.azuresynapse.net 
 Serverless SQL endpoint: cheprasynapse-ondemand.sql.azuresynapse.net

84864-image.png

Step2: Open SSMS => Connect to database engine => Give the below details as shown below.

 Server name: synapseworkspacename.sql.azuresynapse.net
 Authentication: SQL Server Authentication
 Login:admin
 Password:***********

84871-synapse-ssms.gif.

For more details, refer Connect to Synapse SQL.

Hope this helps. Do let us know if you any further queries.


Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.



image.png (90.1 KiB)
image.png (102.0 KiB)
synapse-ssms.gif (605.2 KiB)
· 1
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 @ShawnMathew-8116,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·