Running Queries and the Results Pane

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:

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 ...