Azure synapse data warehouse connection string

Question

I have a connection string for Azure Synapse data warehouse provided by another party, what are the next set of steps I am supposed to follow to get access to their data warehouse?

Answer 1

Hello @Shawn Mathew ,

You can use multiple tools to access the data table.

Here are the steps to connect Azure Synapse Analytic using Azure Data Studio:

For Dedicated SQL pool (formerly SQL DWH):

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

Step2: Open Azure Data Studio => Create a connection => 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 Azure Data Studio => Create a connection => 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.

Answer 2

Hi @Shawn Mathew
Thank You for posting in Q & A.

To get access to Azure Synapse follow the URL Azure Data Studio is fully supported starting from version 1.18.0. SSMS is partially supported starting from version 18.5, you can use it to connect and query only.
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/connect-overview

Download and install Azure Data Studio
Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.

You can use SQL Server Management Studio (SSMS) to connect to and query Synapse SQL in Azure Synapse Analytics through either serverless SQL pool or dedicated SQL pool resources.
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-ssms

If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.