Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. It’s engineered with the data platform user in mind, with the built-in charting of query result sets and customizable dashboards.
Follow the below steps to connect to Azure SQL Database in the Azure Data Studio.
Step 1: Launch Azure Data Studio.
Step 2: Click on the New Connection under New drop down.
Click on Create a connection.
Step 3: Choose the Connection String option, Provide the Connection string [ADO.NET (SQL authentication)] text and give some meaningful Name to the Connection Details.
Click on Connect.
Note: For reference, follow my earlier article’s Step 17 to get the Azure SQL ADO.NET (SQL authentication) Connection string in the Azure portal.
Once it is connected successfully, you can see the below message Connected…
Below Query window will be opened automatically in a few seconds, where you can see the list of Tables, Views, Stored Procedures etc.
Step 4: Click on New Query.
Step 5: Enter the below command and click on Run.
Results can be seen like the below.
Hope you have successfully followed all the steps and Connected to Azure SQL Database from the Azure Data Studio.
Like and share your valuable feedback on this article.
My earlier articles related to Azure that you might like,