Snowflake Unique Features | Chapter-6 | Snowflake Hands-on Tutorial

[@NARRI4U]

Excellent series on snowflake, thank you very much.

[@DataEngineering]

Glad you like them!

[@kirankumar2650]

Everytime when I'm watching your videos that you are making me wounder with your stuff, God Bless You

[@DS-vj2xo]

Best than most of my classes

[@boseashish]

this is a great and very important video int he series

[@pratikparbhane8677]

Thanks For Valuable Content-❤

[@DataEngineering]

So nice of you

[@ShobhitMalik24]

Good detailed informed video..keep it up

[@DataEngineering]

Thanks a ton

[@umamaheshch2167]

This videos very helpful to me to explore snowflake

[@DataEngineering]

glad to hear ...

[@apostleisaacopokuagyeman5676]

Thanks for your awesome job !!

[@DataEngineering]

Glad you liked it!

[@tasfiqueahmed6381]

Very nice presentation of the the concept. Just waiting to complete all of the chapters.

[@DataEngineering]

All the best

[@sanachunarkar6606]

thank you...very helpful

[@DataEngineering]

You're welcome! And if you would like to know about entire playlist, you can download the summary sheet ➥ Complete Snowflake Tutorial rebrand.ly/maj4l6x ➥ Complete Snowflake JSON Guide rebrand.ly/d52cef

[@AliciaMarkoe]

Thank you 🦋

[@DataEngineering]

You are so welcome

[@dharmeswaranparamasivam5498]

Thanks for your awesome job. All these videos are great and quick enough to learn. Quiz time is really good.👌👍

[@DataEngineering]

Glad you like them!

[@TechLearner-r4z]

Excellent! How can we get the queries to used this video? Please guide me.

[@anithaveeramani8909]

Great Effort!!! However, for a newbee like me, it feels like you are reading the content that makes me difficult to understand the concept. This is my experience so far with this series. But who knows, I may like them going forward..

[@ArushiThakur-w5k]

Thank you for this amazing content, can I get access to the slides you use?

[@ketanrehpade9150]

Thank u , the content and the way of teaching is excellent, but the whole chapter 6 is an overview, there is so much in-depth of every feature, it would be nice if you can make short videos on each feature... Thanks

[@DataEngineering]

Sorry about that, will take a note on your feedback. However each of the feature is explained in later chapter and they are explained in detail. Do have a look into ch-7 to ch-25 and let me know if you have concern.

[@ketanrehpade9150]

@@DataEngineering just finished chapter 7, there is the explanation in detail, no issues at all. will continue to explore till ch-25 . Thanks.

[@gururajdesai4634]

Great effort, very informative and precise content

[@DataEngineering]

Glad you liked it!

[@nagnayak]

wow... nice content

[@DataEngineering]

Thanks for visiting

[@sajanmahat4764]

Can you share the mind map or something you have used to mark the chapterS?

[@DataEngineering]

let me see how can I share it via my blogging platform.

[@suvarchalakota429]

Wowwww You have put everything at a single place, this is the best series that I have seen. The effort you have put is awesome, thanks a lot.

[@DataEngineering]

Thank you so much 😀 Feel free to share you feedback or area of improvement if you have noticed.. you can also drop your feedback via instagram (instagram.com/learn_dataengineering/)

[@sukumarreddy4150]

Thanks a lot for your valuable content. many people will get benefited. priceless job. I would like to request could you please a video on different custom roles(Developer, QA, Business Lead, Test Lead, Manager, DB Admin et...) hierarchy how to apply the restrictions on object level. If you have already related to that kindly share here.

[@DataEngineering]

@Sukumar Reddy, thank you 🙏 for watching my video and your word of appreciation really means a lot to me. I will try to make a content around custome role and let you know when it is ready. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

[@_pseudo_intellectual9255]

Thankyou for lectures. Where can i get all your the Presentaion and gharp you are sharing ?

[@DataEngineering]

What you see is not slides and rich content and it is not easy to share them.. if you need more accessible.. you can look into my udemy course (though limited at this stage but will publish more content that will have complete reference material) 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

[@tanayamandal111]

Your videos helped me a lot to learn Snowflake and to clear snowflake snowpro. I have a doubt here please correct me if i am wrong. As per my understanding Periodic rekeying/key rotation is available in enterprise and above editions. Also please let me know how to enable this feature.

[@DataEngineering]

Very interesting question @Tanaya Mandal and yes rekeying is possible only with enterprise and above editions. Refer to the feature link here. docs.snowflake.com/en/user-guide/intro-editions.html#security-governance-data-protection On your 2nd question, I personally have never done any rekeying. Most of the enterprise-grade application I have worked, it is already done by Snowflake team + clients. However, just to guide you, if you are using your specific encryption for a staging area, when you create a stage, you can give the key with an SQL statement. Other keys appear at root level followed by account level followed by table level followed by file-level and it can also be done using SQL statement. ALTER ACCOUNT SET PERIODIC_DATA_REKEYING = true; Thanks again and this looks like an interesting area for me to explore and maybe create video content around it.

[@tanayamandal111]

@@DataEngineering Thank you so much. Yes a video on this topic would be really helpful. Please make videos on stored procedures if possible.

[@DataEngineering]

@@tanayamandal111 the stored procedure is on my radar and will make a playlist. Thanks for your feedback and really helps me to focus on where to put my energy when creating videos.

[@saraneegupta7426]

Biz critical to support key rotation... What is meant by this

[@hariyaparesh7965]

what are the limitations of replication in BQ or Redshift or synapse compared to Snowflake?

[@DataEngineering]

I am not expert on those BQ/Redshift.. but I feel they are not as smooth as it is there with snowflake..

[@kushalmishra5090]

Update - A snowflake 6 x large warehouse can have 512 Nodes

[@DataEngineering]

Yes.... noted.. and thanks

[@dt0229]

Thank you! Love the content. Can you please share the tree graph at the end of the video?

[@DataEngineering]

@Tong Dai, here is the blog which will help you with the treemap used in this video. www.toppertips.com/snowflake-unique-features/

[@gkmail-zf6jb]

@@DataEngineering would you please make the treemap/blog accessible. Getting an error when go to the link.

[@gaganrajkaushal]

Thanks for sharing your knowledge with us. It was as wonderful session. If possible, could you please share the diagram that you are using for conclusion.

[@DataEngineering]

As soon as possible

[@mohammadamir796]

Great video ! You have put in lots of effort in creating it. Appreciate your effort , thanks ! Keep up the good job. :)

[@DataEngineering]

Thanks a lot..

[@butterflymantis]

Thank you! quick question about data replication, is it possible to just replicate specific db schema in our secondary snowflake account? We have a global snowflake infra, hosting all regions data, since we provision another account in selected regions, we would like to just replicate database schema specific for each region.

[@DataEngineering]

Yes it is possible.

[@dhanshreehedau145]

Hi @Data engineering simplified, thanks you for this wonderful series of snowflake. I want to ask you one question. Currently I am working as Oracle DBA and I want to switch to snowflake. So what path should I follow, on what exactly should I do? Is it possible to switch to snowflake technology? It would be great if you help me out

[@DataEngineering]

Very much... if you have basic cloud technology knowledge ( very basic with storage and integration) and snowflake together.. as DBA.. you can become Cloud Snowflake DataOps expert.

[@dhanshreehedau145]

@@DataEngineering thank you so much.

[@gangye8356]

which tool do you to draw the last feature map diagram?

[@DataEngineering]

mind map

[@gundasaigopinath3566]

The lecture by your words are awesome sir,, could you please share PDF as study material.. it may help a lot to new learners. .

[@DataEngineering]

they are rich content and very big files.. will see how I can convert them into PDF files --- You can download this cheat sheet, that has detail for all the chapters. Snowflake End To End Guide Cheat Sheet - bit.ly/43t5IPB

[@paknadeemful]

well done bro

[@DataEngineering]

Thanks..

[@muvvalabhaskar3948]

Hi where can I get the worksheets for all the lectures ?

[@DataEngineering]

Most of the SQL are published in my website (toppertips.com/)

[@SandipanSarkar-c8v]

Finished watching

[@DataEngineering]

thanks

[@suyognagaokar1427]

In the diagram, you have shown Azure Blob to Snowflake with Copy Command. But in the architecture video #2, copy command is shown with GCP. I think, this one is correct.

[@DataEngineering]

copy command works on external stage. The external stage can be created on any cloud object storage, be it S3 or Azure Blob or GCP. The picture is a just a representation how this integration can be done.

[@hrushikeshmandekar707]

kya aap ye ppt provide kr denge kya? notes banane me bahut dikat ho rahi he

[@DataEngineering]

it is not ppt.. and it is rich media and hard to share as files are too big and you would not able to open it without those software.. will see if I can share the necessary content via my blog pages. 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

[@ayushmandloi1580]

How to connect snowflake to Google cloud storage ?

[@gauravhaiaaj1]

Thank God we have playing speed adjustment option

[@DataEngineering]

thanks.

[@ramyap1264]

Hi, your video helped me to understand snowflake concepts and able to clear snowpro certification. could you please make a video about snowpark? 🙏

[@DataEngineering]

Superb and congratulation @Ramya P.

[@leoabhi0608]

Please mindmap used in these videos.

[@HaGh-nk1kp]

I am new to Snowflakes and your lectures have been really helpful, it would be great if you could share the PPT/PDF that you are using here?

[@DataEngineering]

What you see is not PPT or PDF.. they are media files.. and not one file which I can share... I will share the SQLs soon for missing chapters..

[@abdullahsiddique7787]

How’s snowflake as a career and expected salary packages in the industry bro

[@DataEngineering]

Hi @ Abdullah Siddique, the demand for snowflake practitioners is growing and will continue to grow as there is no close competitor of snowflakes as of today. As far as salary is concerned, it falls under big data and cloud data warehouse technology space, and people are making a good amount of money, however, just knowing snowflakes is not sufficient. Folks should learn the data warehouse as a domain alongside snowflake.

[@bemanojkumar722]

@@DataEngineering can you please elaborate more on data warehouse as a domain

[@DataEngineering]

@@bemanojkumar722 Sure, I hope I have understood your question correctly and there are lot more videos available in youtube and if you can given me some additional pointer, that would help me to focus and when I create content.

[@bemanojkumar722]

@@DataEngineering like case studies of how snowflake and azure is implemented in some companies especially in finance sector...the whole work flow if you can explain with what services they use

[@MyPavi123]

Can you please include snowflake interview questions and scenario based interview questions also. That would be helpful

[@DileepKumar-un6sp]

can you plz share notes also

[@DataEngineering]

will see if I can publish it

[@babuganesh2000]

Can you share the mindmap please ?

[@DataEngineering]

let me see how it can be made available in my website.

[@babuganesh2000]

@@DataEngineering Thank you

[@dianadai4616]

He was read materials in an extremely rushed fashion.