in this video i'm going to give you a quick walkthrough of snowflake
the ui and really what you can expect to see as an account admin it is a little bit of a difference
compared to the traditional layout of something like sql server or mysql postgres stuff like that
so when you get on here first thing obviously this is a cloud-based provider so you're actually going
to a url you're going to a website not opening up an application on your desktop having said that
a lot of the things are similar for example the worksheets button here you're going to see
databases within the databases you'll see schemas and then tables and views and whatnot within there
all that should be pretty straightforward to anybody who's worked with a relational database
before you know it's it's it's fairly intuitive there down here you'll get the the results over
here uh right here you can see you you make some selections in terms of what you're using on this
particular worksheet so the worksheet again is where you're actually going to write the
code so you would write your select statements here select one depending on your privileges
you'll get different options and that will be explored in a different videos more specifically
but as an example you can switch which user which role you're doing so depending on that what you
see over here may change you know switching back now if you're already on snowflake i'm assuming
you're aware that the computation and storage is separate so this is where you would select that
under the warehouse here you can select a particular warehouse which is your compute power
and then database is whichever database you want this particular worksheet to be
tied to same with schema so you can either specifically write that out in your query and
you know select the database and schema or you can have it here and just have it defaulted for you
but the most important thing in here that's required is the role and the warehouse because
depending on that role will dictate which warehouses you have access to which databases
etc and you have to have a warehouse selected in order to run anything so as long as you have one
of these selected another thing you can do here is actually preview some of your data so let's say
i have this sample model here under my staging schema if i click preview data it says requires
a running warehouse so i have that here if i click this it will give me a preview which is kind of
nice you know if you don't want if you just want to get a feel for what it looks like you can see
it here it will also break down over here on the side the columns and the data types so let's look
at this one it's a little bigger you can see all of this here so now if we look up here starting
on the left we have databases this is another view of your specific databases in addition to this so
if you click this here we can see the breakdown of the databases when it was created who the owner is
you can create a new one here so we could say you know test a testdb and create that here and then
grant privileges as well and snowflake you have to specifically indicate which roles have permission
to certain objects all objects whether it's a warehouse or a database or a schema whatever
you need to grant those privileges but if we go back here and
refresh we now see this is this is here and it comes with some default schemas
next is shares shares are pretty cool it's something in snowflake that allows you to
share data amongst different people and different organizations different accounts and a data share
is essentially providing read access to a data set whether that be specific views or whatnot so in
this case it comes with some default ones inbound meaning what you have your account has access to
and then outbound are ones that you're providing with somebody else so let's say you have some
data models that you've built that you want to share with the client or with some other
users or just to the marketplace in general you know you could create that share here and then
you know share it with other people so you would create the share name which databases you have
to select specific views or tables and then you would grant permissions to other accounts
the data marketplace we'll touch on that in a second that's where you can find basically
other shares people are providing data that you can tap into and either pay for or use for free
warehouses again snowflake separates compute from storage so this is where your actual
warehouses your compute are listed worksheets is where we started this is where you're actually
writing your queries and seeing the different objects here on the side
history will give you a history of all the queries you can see the specific query ids
in here and who ran them what warehouse i use a session etc so you can do some digging in there
account this will only be visible if you're on the account admin role this is where you can
see your usage your breakdown down by credits i only have one warehouse right now but let's say
you had different warehouses assigned to different things you could see the breakdown of costs here
billing obviously what you have on file for that users roles specific policies breakdown by
obsession you can create some reports for resource monitoring reader accounts reader accounts reader
accounts enable providers to share data with consumers who are not already snowflake customers
let's say you have a client who you want to share your data with that you've built on snowflake but
they're not a snowflake customer you can create a reader account for them and it will give them a an
interface to log into just like you know just like this for them to go into and then you could share
data with that reader account so they would get their own account number and login information
and they would have their own users and roles and all that but anything that people would do
on that reader account is going to get billed back to you but nonetheless i still think
it's a pretty cool feature that they offer one other thing i should have mentioned earlier is
this right here you can also switch your role so we mentioned before that you change your role here
for the worksheet this is based on the specific worksheet and the query and the table and the
databases you'll see here this role will dictate what you can see up here so if we switch to
analyst here things should have almost no privileges so you don't
have the account permission here if i go to shares it's not going to
let me see it you have to be the administrator to see this data sharing but let's switch back
to admin notifications like most other things you can determine what you want to be notified of
help just provide some extra help and documentation partner connect this is
pretty cool you can automatically connect your snowflake account with other applications for a
free trial so let's say you have you want to try 5 train or you want to try stitch and you know
you want it to be connected to this that would make setting up the trial a little bit easier
preview app so this is going to take us to a slightly different interface it's a little more
modern looking create new worksheets here and you could save this query as uh you know test
and then you know you go back and now you can see it's here and you can just hop right back into
it and pick up where you left off you could you could share this query with other users
so you can you know you can collaborate with different people on on a query put them in folders
stuff like that so that's kind of cool dashboards will allow you to create
basic visuals on top of some of your underlying data sets
and this is the marketplace here that i mentioned from up here if you were to click this it's going
to take you to this app and this is where you can look at the marketplace of data that
people are sharing and that you can connect to through your account here you can add some more
some of your settings and then hop back into the classic view which is where we were before
the last thing i'll mention kind of like how we could do it with the
shared worksheets here because this is a cloud-based tool what's kind of neat
is you could write a whole query on here you can have multiple tabs of different queries
even though you may completely close down your browser the next time you log
into snowflake onto your account it will pick these back up so you don't lose your query just
because you close down uh close down the tool that's i think to me that's that's kind of nice
down here on the right you can you can get some more history as well so
so i could say select one and now you can see the uh history here they found that one run it again
query id so you can dig into that there there's still a lot more that you can uncover with
snowflake and of how it's actually operating but i felt like this was a good way to just
give you a high-level view of what the application looks like if you're new to it where to find
things and hopefully get you started thanks for watching and i'll see you at a future video