Running Queries and the Results Pane
Explore how to run SQL queries using the car_crash database in Azure Data Studio. Learn to use the results pane to view output, export data in various formats, and create interactive visualizations with built-in charts and the SandDance extension. Understand how to enhance query results with measures and generate actionable visuals directly within the platform.
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:
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 ...