Visualize SQL query results with charts in Azure Data Studio

Azure Data Studio is Microsofts cross-platform (it works on MacOS and Linux unlike SSMS) database IDE. Despite it’s name you can connect to on-premise DBs too just like SSMS.

Microsofts What is Azure Data Studio page has a good overview of the different functionality available in ADS and also outlines why you might choose ADS over SSMS but here I’m just going to show some quick examples of the charting capabilities available. These give you a nice simple way to visualize data direct in the IDE.

The query I’m using returns two columns relating to the amount of sales by location in the AdventureWorksLT sample database.

Simple Query in Azure Data Studio

Clicking the chart icon on the RHS gives us a number of options for charting the results as seen below. The specific options available depend on what type of chart you select.

There are ten chart types supported, but not all will be relevant to all result sets. You get more power in excel or dedicated charting solutions but if your query is simple the charting in ADS can be very helpful. I find myself using it a lot in combination with group by statements.

A few examples of charts based on the above sales location data are below. In order, the charts are Bar, Doughnut, Line and Horizontal Bar.

Uploading files to Azure App Service directly from the Azure portal without FTP

Despite its lack of visual feedback you can upload files directly into your Azure App Service via the Azure portal. This can be done via the Kudo Console or in the new App Service Editor (preview).

To open the Kudo Console navigate to YOUR APP SERVICE -> Development Tools -> Advanced Tools or bookmark And then just drag and drop the files you want uploaded onto the relevant folder.

Upload files to Azure App Service

To open App Service Editor navigate to YOUR APP SERVICE -> Development Tools -> App Service Editor (Preview) or bookmark You can upload files by dragging them onto the Explore pane on the LHS.

How to get FTP username and password in Azure App Services

Two methods of getting FTP details for an Azure App Service are below.

Download FTP details via ‘Get publish profile’

Navigate to your App Service and click ‘Get publish profile’ along the top navigation bar. This will download a .PublishSettings file which will contain all your FTP details including host, username and password.

Get Publish Profile


View FTP details via Deployment Center

You can also view your details via Deployment Center which is under the Deployment link on the LHS. Select FTP and click Dashboard at the bottom and Azure will show a popup with your FTP details.

Azure Deployment Center

Azure FTP Details

Adding WebP support to Azure App Services

If your getting a 404 not found error when requesting .webp files when using Azure App Services and your sure the files exist you likely need to add the WebP mime type.

You can do this by adding a Web.Config file (if one doesn’t already exist) to your wwwroot folder which contains a mapping from the webp extension to the image/webp mime type. For example..

<?xml version="1.0" encoding="UTF-8"?>
      <mimeMap fileExtension="webp" mimeType="image/webp" />

Enabling Azure CDN to read Azure Storage account blobs to resolve ‘The specified resource does not exist’ error

If you’ve got an Azure CDN endpoint hooked into an Azure Storage account you may get an error stating ‘The specified resource does not exist‘ when you try to access a file through the CDN URL endpoint.

If your sure the file exists in your storage account container most likely you’ve not set the access permissions on your storage container to allow anonymous blob access. Blobs that are shared via Azure CDN must support anonymous access. Turning it on is easy.

1 – Navigate to your Azure Storage account and then ‘Containers’ and select the relevant container and click ‘Change access level’

Setting access on a container

2 – Select ‘Blob (anonymous read access for blobs only)’

Azure Storage account container access