Snowflake Data Sharing

[@raymondbyczko]

Your video was informative. Thank you!

[@rajachellappan926]

Well taught. Thanks Sanjay... Will data sharing create copy of data for the consumer? Or just the metadata is getting copied?

[@SanjayKattimani-tech]

Thanks Raja, It is only metadata so you are neither creating another stale copy for the consumer nor paying extra for it.

[@anjanaramanujamsrinivasan9225]

Hi Sanjay, an informative video, thanks for sharing. I am working on trial version for 30 days, so need to be wary of the credits I use. Can i add reader accounts, and if so, will that impact each one's credit as well?

[@SanjayKattimani-tech]

The reader account is created, owned, and managed by the provider account, which assumes all responsibility for credit charges incurred by users in the reader account (docs.snowflake.com/en/user-guide/data-sharing-reader-create.html). So yes you will be charged for their usage, If you do not want to pay for that, you can share the data with regular snowflake accounts.

[@nagarjunamadana3690]

Hi Sanjay, I am new to snowflake and completed Cloud Analytics academy certification. Looking for hands on experience. Your videos are really good. In this video, Did ethan and maria accounts create actual DB (with original data) or just a clone on provider db?

[@SanjayKattimani-tech]

Hi Nagarjuna, Thanks. Ethan and Maria's accounts are clone of the parent DB. Snowflake just uses metadata to refer to the parent account's data and does not in each of these accounts. These databases are not physical copies but just referenced. All changes in parent db data will be visible immediately.

[@inder19ify]

Hello Sanjay, I am new to snowflake,may i know how to implement stored procs in snowflake..or any video you could make on the same..it would be great!!

[@SanjayKattimani-tech]

@@inder19ifyHi, User-Defined Table Functions or python scripts can be created that let you kind of write stored procedure equivalent. I will create a video in future on this topic.

[@inder19ify]

@@SanjayKattimani-tech Thanks...would keenly wait for the video.

[@faid2n]

Hi Sanjay, May i know what is that user_access table. is it a snowflake defaut? without providing the secure view name or column name you just giving the Account id and the value then how it automatically filters that view data?. if we have shared more than one table or view then how this row level security will work?

[@pvijayabhaskar1520]

Sir snowflake learn enough SQL or python

[@adityasunny99]

I see that you have added to the user_acess table,is this necessary?

[@chetangowda2403]

i have a scenario where two accounts are in same region but diff provider .if we are sharing tables and in consumer account we want to do dml on tables after creating database on share would it be possible?

[@RonuRaj2]

Do we have any snowflake whatsapp group?

[@utkarshdixit3502]

Thank you for the video.

[@harshalpatel8940]

What is uses Access Table here ??