Azure Data Studio (ADS) is a free cross-platform database tool used to query, design, analyze, and manage databases and data warehouses. It has been designed to simplify data-related tasks. Built on Visual Studio Code, Azure Data Studio is a multi-database tool that supports both
Azure Data Studio is not just about Azure. With containerization, Kusto, Azure Arc, or even IOT, Azure Data Studio allows us to manage and maintain all our environments inside of a single tool, be it on-premises or in Cloud.
This data-centric tool is increasingly becoming the go-to tool for database developers, data analysts, and data engineers due to its plethora of query editor features and ability to simplify data wrangling tasks.
We can use Azure Data Studio to:
Azure Data Studio incorporates an SQL editor with several built-in features to simplify the SQL query editing tasks:
Moreover, the user interface is also configurable, offering customizable fonts, icons, color themes, and zoom levels.
ADS supports an integrated terminal to help you run most administrative tasks (using Powershell or sqlcmd).
ADS supports SQL, Python, Scala, R, PySpark, and PowerShell Notebooks, which can include live code elements with formatted text, query results, and images. We can save and share the code and results in the Notebooks with others as well.
In the past, when working with SQL Server, everyone would use Management Studio. The downside with Management Studio was that it only worked with a Windows platform. Azure Data Studio runs on Linux, macOS, and Windows.
We can chart or visualize our query results with the built-in charting query results feature.
ADS offers free extensions that can be installed to extend the available features and customize the tool based on our needs. For example, SandDance is an extension that helps with data visualization and gaining better insights into our data.
Since Azure Data Studio is an open-source tool, developers worldwide can contribute to the product and use the avenue for creative and productive expression.
View all Courses