Search⌘ K
Home
Courses
Azure Data Studio Masterclass

Running Queries and the Results Pane

Let's write some queries to generate some visuals for our dataset.

We'll cover the following...

Anatomy of the results pane

With our newly installed car_crash database, we are now set to write SQL queries and create interesting tabular and visual results. First, let’s open a new query from the server dashboard using the car_crash database, as shown below:

Next, enter the query:

MySQL
select distinct BOROUGH
from edw.D_LOCATION

Then click on “Run”. You should now see the query results, as shown below:

The above results pane provides the query results, which in this case lists all the boroughs contained in the D_LOCATION table (which in Kimball terminology would be referred to as the Location Dimension). Of the ...