Good morning.
I'm Saveen Reddy, a group product manager in Azure Engineering.
And today I'm going to show you how to get the most out of the Synapse Studio
SQL Query editor
specifically, I'll focus on how you can get the most
out of the results that show up when you run a query.
So let's start with some sample data.
Now what I have is a table with four columns.
And let me select all the rows there.
Now it contains it contains the state name,
the total area. This is KM2 means kilometer squared.
The area just by land and the areas by water.
So those are the four columns and of course first
since I gotta do some charting later, I'm just going to get the top 10.
rows so let me run that and then I'm going to
again for charting purposes later, I'm going to need this data to be sorted,
so I'll order by.
The KM2 column, which of course is kilometers squared,
and that's the total size of the state,
including land and water.
And I'll sort that descending.
There we go and let's run that.
OK, so you see, have we see we have our results?
And we have 10 of them and it's sorted
correctly now by the KM2 column.
Now the first thing to understand is.
You know you may have a lot of columns.
This UI actually lets you filter the columns a little bit.
You can actually search for data, so let's just show you that in action.
So I'm going to pick a number first, I'll
just type in one in the search bar
here and you can see all the ones are
highlighted so I can search for the data for sure.
Also you can search for text, of
course, so let's just try this interactively.
I'll type in T and it's case
insensitive, by the way, so T shows up Texas and Montana,
and then of course I just want TE and I get Texas.
This and so now you can see how it's filtering the results or
searching for the results.
And one thing to keep in mind here is that it's not re issuing the query.
of course. It is simply filtering on the data that already has back in the UI.
OK, I clear the filter.
The next thing we want to explore is how do you get this data
out. So conveniently we have this export results button here.
and as you can see, we have several formats that want
CSV, JSON and XML and if you click on
CSV, this bar will pop up at the bottom in
edge and show you you can open the file or open the
folder where the file is. OK,
so I'll remove that.
Now this is of course just your standard results field.
Let's take a look at what we can do with charting.
So by clicking on chart you can see it's going to
render the data we have and it's doing a guess about how you want it to rendered.
In this case it started off with a line
chart and let's try to fix this up to make it more useful for us.
The first is at the bottom, it doesn't know which column to use for
the X axis. OK, so.
We're going to fix that. We want of course, the state
name, so we go to the category
column and we'll pick state.
Now the state names are there and the
next thing is, you know, we're really probably interested in
only some of the columns and not all three
In this case, I really want to compare the
total size versus the water size,
so I'm going to click this
checkbox and now land area is gone.
And now I see for just two series of
data, the blue is the total and the
black line is the water area.
And as you can see, Alaska has not only the most total
size of any state.
It also has the most area by water as well.
OK, now let's focus on labeling these things a little better.
1st is we're going to want to see, you know
the state and the area as labels,
so we'll fix up the series,
which is of course area.
I'll type in Area and this Legend series label.
Now you see the area is
right here.
Now of course we want to see the word state
down here, so we'll type in state under the category label.
And there we go.
Now we have a really nice chart and we can
even explore the chart in other
ways so we can have different chart types. I'll pick
bar, for example. It
maintains the same configuration, just renders it differently or
column. But you know, I sort of liked it better as area.
Or maybe bar?
OK, so now we have. We've
shown you how to use the different options for the charts.
One final thing we can do. Again, we
can export the chart so instead of just exporting as a text,
we can save as image by click.
Here you'll see a couple of options
JPEG, PNG and SVG, and the SVG is
really useful if you want to embed this art in a way that.
That it's it will scale independent of resolution,
so you're not locked into a specific bit set of bitmap formats.
OK, so.
having done all that, I hope you understand now.
some of the things you can do just inside Synapse Studio.
You could search for rows. You can export the results as not only
text formats but also images, and you can do some basic
formatting and charting.
So you can do some exploration here without having to go into Power BI
or Excel or anything.
Just keep it all inside Synapse Studio.
Again, I'm Saveen Reddy, a group product manager to Azure Engineering
and I hope you found this video useful.
Check out more of our videos in our Azure Synapse Analytics Spotlight series.