We're now in Synapse Studio.
Now at this moment,
we have a fully functional workspace
that I can do all the activities in.
I can use SQL, I can use Spark,
I can use both dedicated SQL pools,
as well as serverless SQL pools,
I can use notebooks,
I can use T-SQL scripts,
I can look at the dots,
I can use the samples, I can create pipelines
and schedule them to run, I can monitor the system.
All of these things are possible
for me now as I create this workspace.
First of all, you can see it says Synapse Analytics
here and the name of the workspace is up here.
Now, you can switch
workspaces by clicking up here under "Switch Workspace",
and I can go to other workspaces from
other subscriptions that's there.
I won't do that for right now. It's useful to
know you don't have to
go back into the Azure portal to do this,
you can just go here and do it,
and of course you've seen me.
Now at the top,
there's some other things you should be aware of.
Number one is there are release notes and
updates that come here in this little icon.
Right now let's close that.
Of course, if you want to give feedback,
you can click on
this "Feedback" icon and
you can send this general feedback,
or if you have a feature suggestion,
go here and this will take you to our user voice,
and you can actually tell us what your
interested in and that's great because
then people can vote on your future suggestion.
That's really all that's important right now.
There's going to be a bell icon.
Occasionally if I'm doing things in
the studio and the system needs to tell me something,
you'll see this light up.
That's what's at the top. Now let's
look at what's on the left.
You see these icons,
and I'm going to expand this out.
These icons we call hubs.
Let's look at the first one.
We call this the home hub
or actually its formal name is the homepage,
and it's this area right here.
There's a data hub,
where you can see
the data that's in the workspace or data you've linked,
like a storage account.
There's a develop hub where you'll write code.
Integrate is where you do data integration,
and that means doing pipelines and it's authoring them,
and writing pipeline activities like dataflows, etc.
Monitors, we'll see what's going on in
the system and then manages how you configure the system.
We'll visit some of those as we start using this.
Now we want to drill in to
something that's a great resource
that will really accelerate your ability to use Synapse,
especially when you're new to it,
but it will also help you,
even if you're a more advanced user
and that's something called the knowledge center.
The knowledge center contains sample code and
sample data and templates
that are really going to help you.
The knowledge center can be
found in studio a couple of ways.
If you are in the homepage,
you can always just click "Learn" and get there.
I'll go ahead and do that now, and there we go.
I'm now at the knowledge center.
I can go back to home or navigate elsewhere.
Now, if I'm not at home,
let's say I'm in integrate,
I don't see that learn card.
This card here, learn,
I don't see it, so I can't get to knowledge center.
But you can always get there by
going to the question mark up here, and in fact,
it's the first link underneath the question mark,
knowledge center, that'll take you there.
Now that we're here, let's try
to understand what's inside.
Now, we're going to start with browse gallery.
Now, the gallery is opened, and by the way,
in case you're having trouble figuring
how you get out of the gallery,
there's a close button at the bottom right.
The gallery contains four kinds of things,
and in the future it will contain more.
But here's what we have now.
We have Datasets.
If your primary interest is,
I want to see what datasets there are,
then you'll go here and we can explore that in a bit.
But let me just show you how you can find one.
Let's suppose I'm concerned about taxis.
I'll type in the word taxi and you
can see we have several kinds of taxi data,
we have this kind of data,
which is for higher vehicles,
we have green taxi, we have yellow taxi.
These are very popular datasets we use in Spark.
We made it convenient to get to these datasets and
the datasets are stored actually in
the Azure Open Datasets,
but when you click, you'll get them inside
the workspace. We'll cover that later.
I just want to show you how you can find datasets.
Then there are Notebooks.
The Notebooks here will
demonstrate key features of Notebook.
For example, we have the charting one here,
which is just how to use a Notebook
to make interesting visuals.
However, a lot of them are more technical, for example,
how do you create a table,
and we have several variations of this.
We're going to create a table,
what we call an unmanaged table,
because the data is going to be
in the Azure Data Lake Storage Gen2 account.
We have the sample available, you can see,
they have the same name, but
the simplest version of it is PySpark, this is Scala,
this is Spark.NET, and this is SparkSQL,
and there's a ton of samples.
This is when your focus is not the data,
but you think more about
what code you want to do with the task you want to do.
You go to Notebooks or you go to SQL scripts,
and there's a bunch of SQL script
here and some of these will teach you
some really advanced techniques like how to
use dynamic data masking, for example.
Again, you can search for
all these things here and over time,
we add to this list of gallery items.
Check back here often and please let
us know if you have things you'd like to add.
Then finally, pipeline templates.
This is yet again, another way of getting started quick.
Many kinds of templates here.
For example, if we want to get data from
BigQuery into Synapse type in big,
and you can see the second one says BigQuery.
You can now click on
here and you'll get a pipeline template.
I'm going to close the gallery
and we'll get back to the knowledge center.
That's how we got there.
We got there through browse gallery.
Now, let's take a look at the use samples immediately.
Browse gallery, it has
a lot of depth and a lot of breadth,
but sometimes you just want to
get started really, really fast, and that's
what use samples immediately is about.
This is a highly curated list of special scenarios.
You can see, there are only three of them.
Let's talk through what they are.
If you want to get started with synapse,
these are the easiest way of doing so
because everything's is taken care for you.
The three are explore sample data with Spark,
which of course will use Spark.
Query data with SQL.
Now, this is going to use a serverless SQL pool.
The one that was called built-in.
You saw that when I originally created the workspace.
You always have this serverless SQL pool available.
Then another one, which is very common task in our world;
which is creating an external table with SQL.
Now this one, you
can use either a serverless SQL pool or a built-in pool.
It'll even create the pool if you need, which is great.
Now that we know what our three options are,
the one I'd recommend everyone to try is
the middle one called query data with SQL,
because it uses the serverless SQL pool,
which right now is the only pool that
exists in my workspace.
It's the fastest one to get you
started because you'd have to do nothing,
you don't have to create anything in the workspace.
Let's click it.
At the bottom click "Use Sample."
Now, all this does.
Remember the pools already available to every workspace,
the one called built-in, the serverless SQL pool.
All this sample does is create a SQL script.
Let me create some more space
by minimizing some of these windows.
Let's take a look at the script.
Well actually before the script, let's just take
a look at what is around the script.
It says this is the name of script,
query data with SQL and you can of
course click "Run" it will run it.
By the way, if I select some text and I click "Run",
just that section of this script will run.
Of course publish will save this.
You need to pay attention to
this one which is called connect to.
This tells you which pool is being used.
I only have one pool.
If I expand this, you can only see the built-in pool.
This is the serverless SQL pool.
If I want to add or remove pools,
I can click here and get to the management UI to do that,
but I won't bother doing that right now.
Then of course, there
is a default database it's going to be using.
You can set that here now default it's master,
and that's the only one that exists.
In the workspace, we can create
other databases that are usable by serverless SQL.