...

/

Running Queries and the Results Pane

Running Queries and the Results Pane

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

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:

Press + to interact
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 ...