How to Connect to Azure SQL Database in the Azure Data Studio?

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.

Pre-requisite:

Download and Install Azure Data Studio on Windows Machine

Step 1. Launch Azure Data Studio.

Step 2. Click on the New Connection under New dropdown.

Or

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.

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.

The results can be seen 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.