in this video i'll show you how to create a reader account and then share some data with
it maybe you have a client or somebody else that you want to actually access your data
but they themselves don't have a snowflake account what snowflake offers is what's
called a reader account that will give them their own interface their own account number
everything that looks pretty similar to this and a place for them to log in the only difference is
all of their activity will be billed back to you but how would you set that up first you have to
be on an account admin role so you have to have permission for that go to account reader accounts
create this is the name of the account as it says here
this is not the name of this is not the account number this is more like
the alias that you want to call it so let's just call this test reader comments
a test reader account for the demo
admin login information this will be the default user that logs in as the account
admin on the reader account so whenever you make this you can hand this off give that to them and
they can go in and start creating other users and other resources so i will call this test
password
okay congratulations just like that we've created a reader account locator and it's going to give us
a url so once we have this url we can log into the account and see what it looks like it will look
very similar to what we have here and this is something that you can share and send to your
clients or whoever it is that you want this reader account to be made for so here it is here's the
locator here's their account number and here's the links so you may get an error the first few
times as it loads this up but once you click on this here it'll take you to a login screen
i'll put in the user and password that i just made for the reader account
and here we are we're logged in let's just dismiss this for now and as you can see here this is the
basic setup test it's an admin it has a account admin permissions no warehouses here there's no
databases because it's all from scratch it's as if it's a brand new account because it is it's
just rolling up under your account now let's say we want to share some data with them right
now there's nothing here let's say we want to share something with them so we can go to share
outbound let's create a new one so we're going to share
data from this account to this one let's create a new one
create give it a name give a name for the share demo share database this falls under demo db
and here it is here's that table again it says no secured views we had other views in there
but they're not secured that's why it doesn't show up so we'll do this team details apply
and create okay so it was created successfully and it's there okay now next add consumers
type full or reader in this case we're going to do reader because we want to give it to this
reader account that we just made here so drop down sees it's here add
okay as it says here log in as an account admin and create from share so you guys can see it
i'm going to go back here and as account admin here i'll go to shares and if i go to inbound
i can now see this here here it is this is shared by this account which is this one here
so if we're hopping back and forth this shows that it was shared by our other account and it
was just created this is my local time it was shared by our you know that other main account
so now if we click on this and say create database from share
we can give it a custom name so the the name of the share is this but let's say i want to
give it a different name locally i'll call it a local db you know give the just the name of
the database give access to um we'll just we'll do sysadmin and account admin create
okay now let's go to the worksheet refresh and here it is and we can see this here now now we
don't have a warehouse set up here so we can't preview we can't select from it but once we
have that set up we will be able to so now as you continue over in this account and you know maybe
you make some more tables or views you want to add them to the share you know you add them here
as you do that here i have another another one here let's just for the
sake of example add this guy edit okay if we go back here and refresh
now we see both of them it's very easy to share data
between users and even users who may just have a reader account i hope you found this helpful
please let me know if you have any other questions and i will see you at the next video