#AZURE DATA STUDIO LOGO INSTALL#
#AZURE DATA STUDIO LOGO CODE#

You can build this Jupiter notebook into a nice presentation for clients or customers to explain what youвЂ™re doing as you go.

If itвЂ™s an analytical type query, you can also create a chart of the data.

Once that query is displayed, I can export that as a CSV, Excel, JSON or XML file.

#AZURE DATA STUDIO LOGO CODE#

In the code cell I can write a select statement (Select * from dimension.City for instance) and once I have a connection selected (in my case I want to connect to my Wide World Importers dataset), I can run the cell and it will display the query right there for me.

This notebook feature can run PySpark, Python 3, Spark R and Scala, as well as PowerShell, so youвЂ™re not limited in any way.

In my example, IвЂ™m using the SQL Kernel so any code that I write must be SQL.

To add an additional cell, you scroll your mouse down by the created cell and it will give you an option of adding a code cell or text cell.

I can write a text cell saying IвЂ™m going to query the dimension City from Wide World importers and that text will be created in an actual cell.

Jupiter notebooks are great as you can essentially explain what youвЂ™re doing as youвЂ™re doing it.

Another nice tool is Jupiter notebooks.

All you need to do is point to a source code repository and Data Studio will recognize it as a repository and start treating it like a source control folder. This is fully compatible with any source control system/provider such as Bitbucket, GitHub and Azure DevOps.

The file explorer shows you all the editors you currently have open as well as any repositories you may have open.

With this you can select a command and then click the Help or вЂ?вЂ™ icon and it will display the help info for that command in the terminal window.

One example is a PowerShell command extension which is a simple explorer of all the PowerShell commands that you can run (this is part of the Azure Command Pack).

#AZURE DATA STUDIO LOGO INSTALL#

When you install these extensions, it gives the application more power to do more things.

You can install extensions and the tool gives recommendations of extensions for us.

You can run PowerShell in the terminal window like Visual Studio code.

You can install it on Mac OS, Linux and Windows.

There are many differences in Azure Data Studio vs.

This gives you a way to organize all your databases, again, very similar to SQL Server Management Studio.

I have a local instance of a database set up here and IвЂ™ve created a server group called вЂLocalвЂ™ which is where IвЂ™ll put all my local connections for databases.

When youвЂ™re in Azure Data Studio, youвЂ™ll see an object explorer on the left side of the application very similar to Management Studio where you can go in and look at your tables and views, etc.

Azure data studio logo