Azure Synapse data warehouse Connection string

Question

question

ShawnMathew-8116 asked Apr 6, '21 PRADEEPCHEEKATLA-MSFT commented Apr 8, '21

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-analytics azure-databricks

5 |1600 characters needed characters left characters exceeded

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

Answer 1 · 2021-04-06T09:24:27.08Z

PRADEEPCHEEKATLA-MSFT answered Apr 6, '21 PRADEEPCHEEKATLA-MSFT commented Apr 8, '21

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

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:***********

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

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:***********

.

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)

synapse-dedicatedpool-sssms.gif (597.9 KiB)

image.png (102.0 KiB)

synapse-ssms.gif (605.2 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

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

PRADEEPCHEEKATLA-MSFT · Apr 08, 2021 at 03:59 AM

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 ·

question