Snowflake Data Sharing | Chapter-16 | Snowflake Hands-on Tutorial

[@virupangouda9341]

Best content on KZbin for Snowflake beginners. Hats off to you sir for such amazing videos for free👍

[@DataEngineering]

Thanks for your note... happy to that these free contents are helping... If you want to manage snowflake more programatically.. you can watch my paid contents .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge.. These contents are available in discounted price for limited time.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command... 1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/?couponCode=SPECIAL50 2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/?couponCode=SPECIAL35

[@VenkatBadaofficial]

Thank you for your videos. I have followed all your videos and Successful cleared my SnowPro Core exam !

[@DataEngineering]

Excellent! & Congratulation on completing your certification @Venkat B.

[@kaushikbhattacharyya9458]

Best content i got for data share in snowflake. Expecting a similar video on data share from synapse

[@DataEngineering]

Noted, but Azure/Synapse is not my immediate focus... and yes, I know many of us are not fully aware of snowpark Python API, if you want to manage snowflake more programatically.. you can watch my paid contents (data + code available) .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge.. These contents are available in discounted price for limited time.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command... 1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/?couponCode=DIWALI50 2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/?couponCode=DIPAWALI35

[@pd4kvlogs]

Loved the content. Absolute gold for beginners in snowflake. Thank you.

[@DataEngineering]

Glad you enjoyed it! --- and yes, I know many of us are not fully aware of snowpark Python API, if you want to manage snowflake more programatically.. you can watch my paid contents (data + code available) .. many folks don't know the power of snowpark... these 2 videos... will help you to broaden your knowledge.. These contents are available in udemy.. (one for JSON and one for CSV).. it can automatically create DDL and DML and also run copy command... 1. www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/ 2. www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/

[@antrabhardwaj4127]

6:26 YES!!! and thank you for such an amazing explaination.

[@DataEngineering]

Thank you 🙏 @Antra Bhardwaj for watching my video and your word of appreciation really means a lot to me.

[@parashuramn4348]

Really amazing content, I have gone through all the 16 chapters - waiting for upcoming chapters. Thank you soo much

[@DataEngineering]

You are most welcome. Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. I release one or two videos every week, so you can follow me and get the notifications.

[@Buzzingfact]

Thanks for your amazing videos.., Passed my Snowpro core certification.

[@DataEngineering]

Fantastic!

[@indraprakashtiwari8452]

The video looks amazing, clear information about snowflake sharing

[@DataEngineering]

Glad you liked it! Lot more coming...

[@ujjwaltanwar2800]

Thanks for such simple explanation. One que on Data Provider - how many databases can be added to a single share. Tried looking for it but not able to find anything in documentation.

[@amitjaiswal781]

Thank you sir your way of explaining each topic is very easy .Keep it up

[@DataEngineering]

Thanks Amit

[@kirankumar1290]

Thanks, worthful feature in kind explanation.

[@DataEngineering]

Glad it was helpful! You can check my other playlist as well as my udemy courses www.udemy.com/course/automatic-data-ingestion-using-snowflake-snowpark-python-api/?couponCode=NEW-YEAR-2024 www.udemy.com/course/snowpark-python-ingest-json-data-automatically-in-snowflake/?couponCode=NEW-YEAR-2024 www.udemy.com/course/snowflake-dynamic-table-masterclass-e2e-data-pipeline/?couponCode=AC7896594913CDFA6155

[@nishavkrishnan4271]

Thank you for posting this video. Waiting for the next set of videos. Appreciate it!!

[@DataEngineering]

Thanks for watching!

[@iampalaniappanarun]

Loved your content !!! 1 Question . What will happen to a table in the consumer that was imported and had some schema changes like (removing a column) in the producer side ?

[@Ai_uniquevibes]

Thank you so much for posting these videos i really love the way you explained it is really help me understand the subject in correct way.

[@DataEngineering]

You're very welcome!

[@fahadmahmood7150]

Thanks for the most awaited video..!

[@DataEngineering]

Most welcome 😊

[@nirmallahiri]

Amazing contents and presentation as well.

[@DataEngineering]

Glad you like them!

[@Letucenick]

Thanks a million!

[@madhukolli1]

Amazing job and thanks for your efforts. Why can’t we access your website? It’s saying not available

[@DataEngineering]

Let me check

[@RGAL-oe5mo]

make a video on to share data with different regions

[@chandangupta1989]

Kindly make a Playlist series for Snowflake advance Data Engineer or Architect

[@DataEngineering]

will make it.. there are very a few folks who are requesting now.. so will plan to make it..

[@matthieumichot9157]

Thanks for the videos. What is happening if I only share a view and not the associated table (in the case I want to share only some selected columns)?

[@DataEngineering]

you need to have reference grant to those table to the view object. ( I personally have not tried this, but this is what the doc says.. do let me know if that does not work)

[@kiranjit4u]

Just saw from Snowflake documentation :- There is no hard limit on number of share that a provider account can. It might have got updated recently.

[@DataEngineering]

let me check that once again.. there was a limit of 20 and then you need to contact snowflake support.. and there is no hard limit.. but kind of dependency on snowflake..

[@karthikr464]

Thanks for explaining so well. Was able to grasp on the moment. But would you also make a video on DB replication on cross region and cross cloud.

[@DataEngineering]

Noted, will do it soon.

[@vamsireddy5051]

Same request from my side also, please consider

[@ajayprajapati3097]

@@DataEngineering Same request

[@ramaprabha1285]

Hi, Thanks for the amazing content. can we clone a shared object?

[@DataEngineering]

No.. shared object can not be cloned... you can try and you will see following error "SQL compilation error: Cannot clone from a table that was imported from a share."

[@brunoillipronti8641]

lol so how do we do Cross-Cloud then? I watched the whole thing thinking you would implement the scenario in 5:02

[@sindhurapatibandla3540]

Really amazing

[@DataEngineering]

Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ I have already published other knowledge series and snowflake certification videos and if you are interested, you can refer them. 🌐 Snowflake Complete Guide Playlist ➥ bit.ly/3iNTVGI 🌐 SnowPro Guide ➥ bit.ly/35S7Rcb 🌐 Snowflake SQL Series Playlist ➥ bit.ly/3AH6kCq 🌐 SnowPro Question Dump (300 questions) ➥ bit.ly/2ZLQm9E ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@vijayparakala-wv9uv]

If we want to share data for other users is we need to download it or directly share for others...?

[@neelamnishad4587]

Is data sharing possible outside Snowflake? Like from some other ingestion tool to snowflake?

[@DataEngineering]

you can share data outside of snowflake using external stage (S3 or ADLS Gen2 or Gooble Bucket), but there is no other way to do so.. may be in future, snowflake may add a feature

[@jimitmehta5985]

In the reader's account, if that account owner creates another objects like tables or views, it will cost the provider's account right?

[@ParthWork]

is it possible to see what does the consumer do with the shared data, for example what queries do they run on that shared data

[@DataEngineering]

No, as far as I know it is not possible to see what consumes are doing when they are using their own computes...

[@hahahehehoho8191]

So how can we share data across different cloud provider/region (the last scenario)? Is it not possible at all?

[@DataEngineering]

It is possible via DB replication to other cloud provider or cross-region. Data exchange does it automatically and if it has to be done without data exchange (which needs support from Snowflake), then it has to be done using data-replication feature.

[@nvkishorekumar]

Can i share dynamic objects to either Reader Account/Full Account?? Lets say a temp table will be created for every run and that should be visible to Reader/Full account dynamically

[@DataEngineering]

Temp tables can not span multiple session.. I have never tried this but very unlikely but permanent and transitent table must be available if you have shared the entire data base and add them to the shared object dynamically via SQL. But why would you like to do that? Interesting use case and I would like to understand that.

[@nvkishorekumar]

@@DataEngineering Thank you and appreciate on a quick response. Well it was a hypothetical question which i got while i attended 1 interview and was curious to know how will it happen if in case :) ? also i would like to know, is there any other mechanism of compressing a table which by default all the tables in snowflake are compressed? In short compressing already compressed table? Just like multi-value compression or column value compression in Teradata

[@amanvarma7759]

how does share access work with 1000 of data consumer? do we have to do it manually or their is a concept of user group?

[@DataEngineering]

I don't think there is any user group concept.... for such a large consumer based.. you probably have to use data exchange or private data exchange.. where consume (if internal) can subscribe it... or you have to write some automation scripts.

[@maaaaaass]

Can we do DML on shared objects in full snowflake account?

[@DataEngineering]

No, update, insert, delete and truncate is not possible.. only select is possible on shared objects.

[@maaaaaass]

@@DataEngineering Thanks alot

[@maaaaaass]

plz helps on replication and sharing data between cross cloud/region

[@DataEngineering]

will do that.. it is in my list..

[@aks541]

Can we create a share from a share?

[@DataEngineering]

No, you can not do that.

[@maaaaaass]

1.I have a snowflake account AWS123 on US east(ohio) cloud is AWS . 2. I have a snowflake account AZ123 on US east(ohio) cloud is Azure. Is it possible direct share between AWS123 and AZ123? Kindly suggest me on this.

[@DataEngineering]

No, it is not possible to have direct share between cloud providers... to enable it, you have to create a data replication in the target cloud and region and then you can share objects from secondary account.

[@maaaaaass]

@@DataEngineering Thanks for the confirmation,but that 2 accounts are in same region right, in one region only one copy of data should be there right? If we replicate , a duplicate copy will come in same region right?

[@maaaaaass]

Plz give the clarity on this

[@ParthaMukherjee-x8k]

Unable to get the SQL source code. Please share the proper link. Thank you Sir.

[@DataEngineering]

let me check and update it here.. not sure if I published the code in my medium blog or my topperitps.com blog page.

[@santhoshbiradara9801]

Brother Unable to access the code, it says "You don't have permission to access the resource" please make it public

[@DataEngineering]

Working on them and will soon will make it part of video description.

[@kusumamathi9812]

True or False: Snowflake charges additional fees to Data Providers for each Share they create. Can you pls help me in letting know the correct answer, As per me data providers need to pay for the storage of data that belongs to share, and as per many online sites I found different answers. so found hard to interpret the correct answer kindly help me out , I have exam on 16th April.

[@DataEngineering]

Answer : False. I really appologise for the delayed response. Hope this helps.

[@kusumamathi9812]

@@DataEngineering Thanks for responding

[@DataEngineering]

​welcome @@kusumamathi9812