Hi, I'm Saveen Reddy, a group product manager in Azure engineering.
In this video, I'm going to explore the Synapse Knowledge Center.
The Knowledge Center is part of Synapse Studio and
it's meant to accelerate the lives of all kinds of developers in Synapse.
If you're new to Synapse, it'll be great for you
because it let you easily kick the tires.
If you are more experienced Synapse user,
then it lets you see some of the more advanced feature
sets we have available inside the service.
So let's get started.
Now I'm looking at Synapse Studio
and I'm looking at the homepage
and there are four cards at the top of the
homepage. On the far right is 1 called learn.
This learning card will take us directly to the Knowledge Center.
As I click on the Knowledge center,
the thing to focus on is on the three cards at the bottom
one says use samples. Immediately
one says Browse Gallery and
one says Torsin App Studio.
Use samples immediately are the more kick the tires samples.
There are three of them and they'll help you get started super fast.
Browse Gallery is where you see the full list of
sample code and sample data sets and templates
and tours in App Studio is a very quick click by click examination of key points of interest.
Insights in app Studio.
We're going to start with you samples immediately.
Once this loads, you'll see there are exactly 3 samples available.
The first one lets you explore some sample data with Spark. The second one lets you explore some
sample data with SQL, and the third one is all about doing a very common task in
Synapse, which is creating an external table with SQL.
We're going to focus on the middle one, which is querying data with SQL.
I'll click on that card and then click you sample.
And what happens is a SQL script is created immediately
and the script itself has several queries.
I'll just run the first one which does a select top 100 on a parquet file in blob storage.
And as I click it.
As we spin up the serverless SQL resources that are in the built in Pool, as you can see at the top,
here is the results of the query,
and that's great. It just immediately worked,
and then you can Scroll down through the rest of this
code and highlight other queries and run them as well,
so that was one of the fast samples to kick the tires.
Let's close this, and now let's learn. Also how do we get back to the Knowledge center
now? I could go to the home page, of course, but also you might find it more convenient
to go to the question mark and then click knowledge center here.
And then you're back at the Knowledge Center.
Now we're looking at U samples immediately.
This time we're going to go to browse Gallery.
Again, browse galleries, will see the datasets.
And the sample code in the form of notebook and SQL scripts and then templates for pipelines.
So if we're thinking about looking at sample data.
And maybe I'm looking at the Bing COVID-19 data.
That's what I want. I'll click on that and click continue.
You'll see it shows me a preview of the data set
with some explanation that will help you understand what's in the data set
and how it's been updated.
I'll click add data set.
Now, this doesn't create a script.
What this does is under the datahub under linked under sample datasets
you'll see we have now the Bing COVID-19 data,
and from here I can of course click on the three
dots and create a new SQL script,
or I can start a new notebook.
So this is the knowledge center helping you. If you're thinking about data first,
what do you think about code first? Like you know you want to use a SQL script or you know you want to use a notebook?
Well, let's get back to the knowledge center.
Now I'll go back to browse Gallery
and now I'm in student code. In this case, maybe I'm interested in notebooks.
So I'll click here. Now this gives me a list of samples that explore different notebook features.
Maybe I'm interested in doing charting, so I'll click on the first one, which is called charting and Synapse notebook and you can see this
is a pyspark example. I'll click here continue.
And here's another preview or where the notebook will look like with some basic information about the notebook,
and you can see some of the libraries that are used in this sample.
Then I click open notebook.
And now the notebook is in my Synapse Studio and I can attach it to a spark pool and start running it.
So I hope you can see the Knowledge Center is a really easy way for you to see what you can do with Synapse.