What is Snowflake ? snowflake - concept, architecture, user workflow explained (2022)

[@rakeshgopidi4066]

Hi Anshul, Greetings from Germany !! I have became a great a fan of you for the following points 1) You are a great presenter 2) You always breakdown the overall concept in a simple understandable way for all audiences 3) You always do a great research on any topic 4) I was inspired from your videos, i started learning cloud and working not just by directly doing some courses from any instructor but i realised Networking is one of the grey areas which is very important and boring/dull subject with out knowing the basics it's difficult to get into it, so i was impressed the way you prepared each and every topics in a simple and very understandable way 5) After working in IT world for more than a decade never realised the overall concepts , i just did coding, programming, but now learning from your videos a lot conceptually and usecases. Every day is a great learning as i stop over to watch your videos !! You are a Great Teacher/Instructor Thanks a lot Anshul for all the efforts and Interest in sharing knowledge Request - can you make some vids on 1) AWS and also compare some key services against AWS vs GCP vs Azure 2) Databricks - how it is different from snowflake and what is special about it ? or any other cloud providers Regards, Rakesh

[@ITkFunde]

Thanks a lot Rakesh, this is by far the most elborate and kindest feedback I have recivied on this channel. Thanks for taking out your valuable time. I will defintely take oir suggestions ahead. ❤️❤️❤️

[@teja2775]

if you are from germany atleast fund him don't expect everything from Free

[@vishalbarvaliya2849]

There Is a ૐ गंगनपताए written on the top-right corner which caught my spiritual attention for a while

[@ITkFunde]

🙏🙏❤️😊

[@Liubov_110]

And what does that phrase mean?🧐 I will thankful if you explain to person which is not familiar to India culture so much

[@ITkFunde]

Hi Liubov, the mantra means seeking blessings from Lord Ganesha, In hinduism lord Ganesha is the god of wisdom, this mantra is my prayer to seek his blessings before any new lecture 🙏

[@Liubov_110]

@@ITkFunde thank you for explaining. Hope, I will recognize that mantra if see somewhere else. Anyway, I remembered name Lord Ganesha, god of wisdom. Thank you also for all that video lectures related to data. It's a great way to recall known facts and find out new ones📝

[@ITkFunde]

Its my pleasure thanks Liubov ❤️

[@Funnisrock]

A complex query takes more than 6 hours in MySQL, 2 hours in oracle, and just 10 minutes in snowflake. So, just imagine how powerful it is

[@romonie7099]

What about postgres

[@bsr7473]

Hi is snowflake is like an Oracle, or an etl tool like an informatica let me know thanks in advance Bro

[@ITkFunde]

Its more like oracle its Datawarehouse as a Service, DWH on cloud👍

[@syedalihaider7278]

and 2 minutes in Teradata.

[@ALS-j4l]

2 hours in Oracle? Maybe you don't know to write optimized SQL that would complete in few minutes. Learn to write better SQL.

[@prasanthrambharadwaj3409]

Nice overview on Snowflake Architecture

[@vijayjayaram606]

Opening line ..... Dil jeet liye aap sir ji 🙏

[@DeltaJes-co8yu]

you are a master story teller. That conclusion in the end says it all!

[@Random_Guy_Bharatwale]

Great thanks Your each word is gem for DWH

[@sivashankarreddy9503]

Snowflake Architecture Key components Snowflake user work flow S3 storage and types How to query S3 Data using AWS Athena

[@e2ndcomingsoon655]

Thank you,incredibly useful video,thanks!

[@FightAndFunHub]

liking the video because of the truth you told in beginning. otherwise most people are always expert in every field. thumbs up for you

[@ITkFunde]

Thanks dear 🙏🙏

[@siva_garlapati]

How do snowflakes differ from Apache hive ?

[@pseshadri9364]

Hi Anshul You are Giving good information to the US Thank yous so much

[@madhurmukhi4379]

best video . very helpful

[@monkeytopski]

Hi, thank you for making such a nice content. It is very comprehensive and easy to understand. You strip down the components to their cores so everyone can understand the idea. Only one suggestion from my side, try to avoid parasitic phrases such as "You know". Other than that, great work! Please keep going!

[@pratikshagawhane9411]

Excellent job sir

[@samyukthas.r432]

Wonderfully explained !!! 👍🏽👍🏽

[@ITkFunde]

thanks

[@ENDALEKINFE-l1v]

good Job thanks so much !

[@HarshalMehta-d7d]

Such a amazing presenations

[@ITkFunde]

Thanks Harsh

[@stephenokon3227]

You've done noble. You took off the scare from its big name...😄 Thank you.

[@boseashish]

this is a very good video and extremely helpful. Very wisely made short video and definitly adds value

[@tanushreenagar3116]

Very well explained 👏

[@prasenreddy-u1e]

Very simple and understandable presentation

[@alexfaith5562]

Thanks so much Anshul!

[@ITkFunde]

Thanks Alex

[@talentzunlimited1398]

Awesome video !

[@praveenshetty7688]

Small correction - Avro, JSON and parquet are semi structured in snowflake… there is no unstructured format support in it such as videos,gmail,facebook..etc

[@basudip2010]

Excellent video

[@PaulS-nw1cv]

Well done thanks mate

[@akhileshsoni1171]

In short, you have described a lot friend. I liked the way you have explained about snowflake.

[@breadandcheese1880]

hi - what i dont understand is how other cloud providers come in play,.,, so in your simple example workflow, where would the cloud providers fit in? Is the data being stored into Snowflakes own storage or is it needing the user to store it with a cloud provider like AWS?

[@omkar-k3k]

Hello Buddy can you tell us about how snowflake is integrated with Hadoop ecosystem

[@shreyashanand8024]

nice !

[@anglaisaveclamerloque5525]

Anshul many thanks and I loved this video.

[@jlcotton19681]

Great overview.

[@jaja0374]

Excellent

[@1rv04ee065]

Great presentation in a simple to understand manner . Well done Sir . Thank you

[@seekluv]

At 2:16 what do you mean by "node" or "compute node"?

[@cmritpk311]

Hello sir,Make a short videos on Data Engineer each and every tool

[@charankumar4509]

Really Appreciated your time in learning and teaching..Great WORK.

[@ITkFunde]

thanks Charan

[@angelsfly6102]

Is it worth learning Apache airflow in front of snowflake? Which is best Data engineering tool?

[@jashanbansal2613]

Airflow is what companies using to run procedures on snowflake

[@kapilsrivastava7927]

Dear Anshul! Snowflake concepts made easy through your meaningful session. Is this a right assumption that different Data warehouses in Snowflake can connect to different could platform in One to one and Many to One mapping (e.g. DW1--> AWS, DW2-->Azure, DW3--> GCP, DW4-->>IBM Cloud and DW1--> AWS, Azure, GCP, IBM Cloud)

[@ITkFunde]

Hi Kapil thanks that is correct

[@shourovnath9377]

it's good bro..

[@jayanth1376]

👌👌👌

[@siddesh2104]

Where is data stored? Do we select which cloud service? Can we have 1 WH in GCP and 1 WH in AWS?

[@mahamahalakshmi7123]

Hi I understand very well ...I have one doubt please let me know that ......in the admin role in which concepts we have to cover and also the developer ..... Then put some more videos on the snowflake.. thank you so much for this ....this is useful for the begginers ...

[@ITkFunde]

Thanks 🙏☺️♥️

[@ranjitkumark9396]

wonderful video about Snowflake. Could you also let us know when to use snowflake in azure adf or be it any azure service.

[@rafaelmiralha5995]

Thank you very much for your time to teach and upload these videos! Cheers from Brazil!

[@ITkFunde]

Thanks Rafael obrigado !!

[@hrutvipawar550]

Honesty, Dedication, the way of explanation and the content forced me subscribe you.

[@yoginarasimha]

If you teach aws solution architect certification course many would pass it easily. Please consider.

[@deepakgowdakm7969]

Thanks for the beautiful explanation 👍🫡

[@ITkFunde]

thanks

[@raghavansn7127]

good explanation thank you

[@sshrouti]

Thanks Anshul, this is extremely helpful as always. Love your videos and the way you simplify and explain complex concepts. Requesting you to do 2 videos 1) databricks and 2) usecases around databricks and Snowflake, when to use what

[@devaranaresh6085]

thank u for the valuable info of snowflake brother plz upload further vedios

[@ashokkumarjangam4751]

Hi Sir Snowflake for SAP HANA?

[@twinkletiwari8820]

Excellent 👍

[@ITkFunde]

Thanks Twinks ❤

[@HM-ws9cd]

Snowflake has its own database..or it connects to databases?

[@ITkFunde]

Snowflake has its own DB...

[@anupam.kushwah]

snowflake itself a database

[@Be_Good_and_Do_Good]

Very good explanation sir! Thank you

[@neelimajoshi334]

Thanks for explaining so well.

[@abhijeetbhatiya6490]

Hello, As you mentioned there is one storage for all the different warehouses. So, All the warehouses will query the same storage? How flexible DMLs on snowflake? Is it possible that 1 warehouse is with GCP and another warehouse is with AWS for example!

[@anupam.kushwah]

Yes, all warehouse query the same storage. snowflake supports all types of DML and it is SQL compliant From an account perspective only one cloud provider can be there. but in the organization level you can have multiple cloud providers.

[@24306529]

@@anupam.kushwah question : so if all warehouses are going to query the same storage, what if two warehouses try to manipulate same storage at the same time? is one of them going to wait(I think so) or does snowflake has some unique method(or magic) of handling this? I am asking because in our project sometimes users end up firing huge time consuming queries at the same time and them they are queued up until the current one finishes.

[@soothingrelax7599]

Thank you

[@ITkFunde]

thanks

[@praveendeshmukh1952]

Could you please explain data vault 2.0 modelling structure in detail with some example.

[@maheshpokharkar278]

How to enforce Primary Key constraints in Snowflake table?

[@ArtherLi-t7w]

hello! thx for your video, but i still do not understand the difference between snowflake and the shared disk architecture, so could you please explain it for me? thank you!

[@chamodmaduranga4755]

Love u man !!!

[@ITkFunde]

Thanks a lot ☺

[@Ks-oj6tc]

well explained

[@Sathvik_Gajjela]

I want to take online coaching on snowflake with handson can you please provide some inputs

[@shwetakhandare1868]

Cloud knowledge is must in snowflake????

[@anupam.kushwah]

It is not must but helpful in understanding how snowflake works internally.

[@bhabanisahoo7447]

What happened if there is no snowflake?

[@PallaviVariganji]

Hi sir my name is prashant now i am learning this course please tell this is good time or not

[@andersdalgaard3408]

8 concurrent users per virtual data warehouse is the maximum, unless you launch yet another system, correct?

[@anupamkushwah87]

Yes, it’s true for XS warehouse

[@prasanthkancharana5206]

HI EHAT IS FUTURE OF SNOWFLAKE

[@rajyalakshmimukkapati2264]

Snowflake admin total classes sir

[@DurgaRao-yi6fo]

What about future of snowflake?

[@anupam.kushwah]

very good.. giving tough competion to spark framework

[@abhijitsalvi6021]

Can a non tech individual learn Snowflake, if he/she is AWS Cloud Practitioner certified and preparing for AWS Solution Architect certification , also what are career prospects of Snowflake? Thanks in advance

[@ITkFunde]

Yes you can learn but pls focus on one niche and build you core expertise in that before jumping to next. Snowflake is a good career option

[@andersdalgaard3408]

So, with Snowflake you do not need a DBA, correct?

[@anupamkushwah87]

DBA is required but not for the typical activities of space management, indexing, increasing of storage space. Snowflake does those automatically

[@DeltaJes-co8yu]

how is this question relevant to this video?

[@skyp6051]

Can sql dba learn snowflake or it is added advantage for career

[@ITkFunde]

Defintely he or she can learn inffact it will help in career progression

[@nadeem7570]

Snowflake life span? Like the demand it has..

[@karthikrajag6796]

Snowflake is same as MS fabric . is'nt it

[@kalpeshjadhav6254]

Bada Bhai, white board pe Jo bhi likhe ho kuch bhi nahi dikh raha

[@ITkFunde]

Thanks Kalpesh bhai for your feedback, lagta h marker change karna padega 😊

[@ALS-j4l]

It's not unique to Snowflake. Oracle RAC database already has similar setup.

[@manojshrivastava7642]

DAW KUCHH AUR BEMARY KUCHH

[@interviewforu]

Snowflake Course : kzbin.info/www/bejne/mKXdf6Z-m6dnmZI

[@smrutiranjannayak305]

no offense , but someone who says he has not worked hands on snowflake , speaks on architecture ?

[@ITkFunde]

thanks for your ffeedback , i think my previous exp in Data helped me

[@KaziNayeem]

I'm someone who works with Snowflake regularly. The presenter is not only spot on but managed to explain it sophisticatedly in simple terms. Good job. He even mentioned the Metadata aspect of the Services (aka the brain on Snowflake) - looking forward to you making a tutorial on that pls.

[@ITkFunde]

Thanks Kazi for your feedback means a lot 🙏

[@smrutiranjannayak305]

@@KaziNayeem you work regularly on snowflake and looking for metadata videos :)

[@basavannaolekar5031]

Correction on what you said on 2.10 time in this video an Instance is nothing but a Memory + background process and database is different i.e., set of files. you are showing a cluster architecture and telling multiple node have a database instance which is totally wrong in your case its a multiple node/instance with a single storage shared nothing is called as distributed architecture Also when you were talking about connectors , your presentation was missing categorization, I mean you mentioned odbc , jdbc and you say GUI lol GUI connects based on drivers or connectors like odbc or jdbc just for making money every tom, dick and harry wants to put videos , its so cheap prepare your content and review before you put.

[@JKsharma-li3gs]

Thank you sir.