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
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. ❤️❤️❤️
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 🙏
@@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📝
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!
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 ...
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
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
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?
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)
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!
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.
@@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.
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!
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
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.
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.
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
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. ❤️❤️❤️
if you are from germany atleast fund him don't expect everything from Free
There Is a ૐ गंगनपताए written on the top-right corner which caught my spiritual attention for a while
🙏🙏❤️😊
And what does that phrase mean?🧐
I will thankful if you explain to person which is not familiar to India culture so much
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 🙏
@@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📝
Its my pleasure thanks Liubov ❤️
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
What about postgres
Hi is snowflake is like an Oracle, or an etl tool like an informatica let me know thanks in advance Bro
Its more like oracle its Datawarehouse as a Service, DWH on cloud👍
and 2 minutes in Teradata.
2 hours in Oracle? Maybe you don't know to write optimized SQL that would complete in few minutes. Learn to write better SQL.
Nice overview on Snowflake Architecture
you are a master story teller. That conclusion in the end says it all!
Opening line .....
Dil jeet liye aap sir ji
🙏
Thank you,incredibly useful video,thanks!
liking the video because of the truth you told in beginning. otherwise most people are always expert in every field. thumbs up for you
Thanks dear 🙏🙏
How do snowflakes differ from Apache hive ?
Excellent job sir
Great thanks
Your each word is gem for DWH
Hi Anshul
You are Giving good information to the US Thank yous so much
best video . very helpful
Such a amazing presenations
Thanks Harsh
Very simple and understandable presentation
Very well explained 👏
this is a very good video and extremely helpful. Very wisely made short video and definitly adds value
good Job thanks so much !
Excellent video
nice !
Wonderfully explained !!! 👍🏽👍🏽
thanks
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!
Excellent
Great presentation in a simple to understand manner . Well done Sir . Thank you
Well done thanks mate
You've done noble. You took off the scare from its big name...😄 Thank you.
Great overview.
In short, you have described a lot friend. I liked the way you have explained about snowflake.
wonderful video about Snowflake. Could you also let us know when to use snowflake in azure adf or be it any azure service.
👌👌👌
Really Appreciated your time in learning and teaching..Great WORK.
thanks Charan
Hello Buddy can you tell us about how snowflake is integrated with Hadoop ecosystem
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 ...
Thanks 🙏☺️♥️
Anshul many thanks and I loved this video.
Awesome video !
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
Hello sir,Make a short videos on Data Engineer each and every tool
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
thank u for the valuable info of snowflake brother plz upload further vedios
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?
Thanks so much Anshul!
Thanks Alex
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)
Hi Kapil thanks that is correct
Snowflake Architecture
Key components
Snowflake user work flow
S3 storage and types
How to query S3 Data using AWS Athena
it's good bro..
good explanation thank you
Excellent 👍
Thanks Twinks ❤
Thanks for the beautiful explanation 👍🫡
thanks
If you teach aws solution architect certification course many would pass it easily. Please consider.
Honesty, Dedication, the way of explanation and the content forced me subscribe you.
Thank you very much for your time to teach and upload these videos!
Cheers from Brazil!
Thanks Rafael obrigado !!
Very good explanation sir! Thank you
well explained
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!
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.
@@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.
Where is data stored? Do we select which cloud service? Can we have 1 WH in GCP and 1 WH in AWS?
Is it worth learning Apache airflow in front of snowflake? Which is best Data engineering tool?
Airflow is what companies using to run procedures on snowflake
Thanks for explaining so well.
At 2:16 what do you mean by "node" or "compute node"?
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!
Could you please explain data vault 2.0 modelling structure in detail with some example.
Thank you
thanks
Love u man !!!
Thanks a lot ☺
Hi Sir Snowflake for SAP HANA?
How to enforce Primary Key constraints in Snowflake table?
Snowflake has its own database..or it connects to databases?
Snowflake has its own DB...
snowflake itself a database
I want to take online coaching on snowflake with handson can you please provide some inputs
HI EHAT IS FUTURE OF SNOWFLAKE
Cloud knowledge is must in snowflake????
It is not must but helpful in understanding how snowflake works internally.
8 concurrent users per virtual data warehouse is the maximum, unless you launch yet another system, correct?
Yes, it’s true for XS warehouse
Snowflake admin total classes sir
Snowflake Course : th-cam.com/video/btzNsHfB4c0/w-d-xo.html
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
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
Hi sir my name is prashant now i am learning this course please tell this is good time or not
What happened if there is no snowflake?
What about future of snowflake?
very good.. giving tough competion to spark framework
Can sql dba learn snowflake or it is added advantage for career
Defintely he or she can learn inffact it will help in career progression
Snowflake life span? Like the demand it has..
So, with Snowflake you do not need a DBA, correct?
DBA is required but not for the typical activities of space management, indexing, increasing of storage space. Snowflake does those automatically
how is this question relevant to this video?
Bada Bhai, white board pe Jo bhi likhe ho kuch bhi nahi dikh raha
Thanks Kalpesh bhai for your feedback, lagta h marker change karna padega 😊
Snowflake is same as MS fabric . is'nt it
It's not unique to Snowflake. Oracle RAC database already has similar setup.
DAW KUCHH AUR BEMARY KUCHH
no offense , but someone who says he has not worked hands on snowflake , speaks on architecture ?
thanks for your ffeedback , i think my previous exp in Data helped me
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.
Thanks Kazi for your feedback means a lot 🙏
@@KaziNayeem you work regularly on snowflake and looking for metadata videos :)
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.
Thank you sir.