Thank you very much for this amazing content, its very hard to find good content and most of them are priced too high to commercialize the content. You are helping many people by doing this. Please don't stop doing this work.
No doubt it is a very well structured and detailed video. May I kindly ask for a pdf or ppt for the whole playlist. Reading and taking screenshots diverts mind! Its better if we can get; if not then also no worries.. I'll manage by taking snaps. Thank you so much!
Bro your teaching method is awesome! you are real professor who really know how to convey 1000 lines in single line. Thanks a lot bro. I am working as a data engineer, thanks a lot for this video.
Thank you 🙏 for watching my video @Salman Sayyad 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Excellent content. I have recently started my learning Journey with Snowflake. After exploring various places, I found the content on this channel as most relevant for beginners. Thoroughly enjoyed this video and going to finish the complete series for sure. Thanks for all your efforts.
Welcome aboard! Feel free to share your feedback and any queries you have.. you can also send me DM to my instagram (instagram.com/learn_dataengineering/) if you have any queries...
You are 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
you are doing great job!!Hats off!! One observation -- scale up/down is for query performance and scale out /down for Query concurrency. I see it is mentioned in other way in this video. Please check.
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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Sir really helpful to me actually i learned snowflake in another institute compare to them ur explanation is very clear and interested too.I am very thankful to God,I hv such a grt sir lyk u.I am improving myself.Thank u very much sir fr ur grt efforts
Bro, I like all your tutorials so far and it is amazing and I recommended everyone to watch it but kindly, would it is possible to have a copy of these slides ? I am looking to make Snowflake certificates and I need a copy for these slides for your all Snowflake. Is this possible. Thanks.
Thanks Kiran. I am try to share them via my website (toppertips.com).. some of the chapter contents are available, however the content you see is not pdf and they are rich media.. so will see how I can share the content via my blogs.
Wow, such an amazing tutorial. Thank you so much for your effort and kindness. I am just in the 3rd and intend to go through the entire playlist. Could you please let me know if you have either already done or planning to do a) How to setup dev, test, prod environments for Snowflake? b) What are some of the best practices, naming conventions? c) What are the common pitfalls to avoid? d) Can you provide a comparison of Snowflake vs GCP BigQuery and Snowflake vs AWS Redshift/Athena? 🙏🙏
Thanks.. point (a), (b), & (c) are not covered.. and if I see more demand.. will make videos on them.. I will surely make on point (a) ----- You can download this summary sheet in PDF version that has detail for all the chapters in one single file. Snowflake End To End Guide Cheat Sheet - bit.ly/43t5IPB
@@DataEngineering I have the same doubts a) How to set up dev, test, and prod environments for Snowflake? b) What are some of the best practices, and naming conventions? c) What are the common pitfalls to avoid? d) Can you provide a comparison of Snowflake Big QueryigQuery and Snowflake vs AWS Redshift/Athena? Can you please explain it or can you make a video on it...
THANK U SO MUCH, ITS VERY EASY TO UNDERSTAND BY YOUR TEACHING. YOU ASKED TO REFER DESCRIPTION FOR ADDITIONAL DOCUMENTS, READING MATERIAL, COULD YOU PLEASE TELL, ME WHERE TO FIND THOSE, SLIDES, NOTES ANYTHING FOR QUICK REVISION.
Thanks a lot for the such quality of content. I have a question here can we change the Wearhouse size and max and max cluster while running running the query on same Wearhouse? will not be any impact on the query results?
You are most welcome. Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. Do let me if you find the entire series meaningful or only this video "Snowflake Tutorial bit.ly/3iNTVGI"
as of now.. Snowflake has no direct support for xl files. and yes snowflake support secure views...find it in my ch-21.3 (ua-cam.com/video/2soTybOZkXY/v-deo.html)
Thanks for the videos, I feel this is the one stop solution for learning snowflake.. I have a request for you to make a video on stored procedure which will be useful to make dynamic data loads using copy command.
Hi sir your all video are very informative and easy to learn and understand.I am amazed the quality of work and at the same time providing to free for all the students where others are charging at high cost.Again thanks for everything you are doing.Meanwhile i was interested in going through the notes as well.If there is premium account for that please let me know that.
Hi How are doing? I am happy with your videos. But my question is, how to prepare notes while you explain? Because while watching I am good with your content. But after some time, I am missing the technical words. If you don't mind, could you please prepare one video about how to learn snowflake in an easy way as I am new to Snowflake and getting confusion how to start? Thank you so much for your hard work.
great advice... will think and plan something.. Snowflake has lot of thing.. and it is growing very fast .. and lot of features are there to explain. but will see how best I can put a video like this.
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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Very detailed explanation on snowflake, I like the way it presented. Small correction, there is a room for optimization in snowflake for user unoptimized sql by DBA.
Can you please explain the following: If Snowflake is using underlying storage and compute engine, how is it different from any other cloud data warehouses like Redshift/Synapse ?
Snowflake is SaaS tool and Redshift/Synapse they are Paas tools.. so in snowflake, you don't have to know how data is stored and and what type of compute it is used.. and this need to be selected in Redshift/Synapase... you need to plan infra in them.. but in snowflake is true elastic... you just declare it.. and it will work... Redshift is a wrapper on the top of postgres and Synapse is using SQL server or Spark... so a developer need to know too much to make thing happens.. but in snowflake.. it is true service.. so you don't need to worry... I hope, at high level..this clarify... there are lot about them.. but can not write everything here..
Thank you 🙏 @ Harikrishnan Chandran for watching my video and your word of appreciation really means a lot to me. I generally share the content via my website (toppertips.com), and for this video, I have not yet done, will see how can I do it via my website.
Hello sir, I'm working in other domain and now I wanted to move on into snowflake and I'm good in SQL, will these training sessions were enough to get into snowflake domain. Could you please suggest..
Yes, you can learn Snowflake easily.. it is much simpler tool compare to other tool and if you know basic project execution methodology in data space + sql .. you can learn it.. if you have any specific query or doubt.. drop me a msg in my instagram.. ua-cam.com/users/DataEngineeringSimplified
I will not be able to share the slides as they are rich media .. will share the information via my website and see how well I can organize them.. Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
Hi Sir, I am beginner and want to go through more quiz so that I can crack my Snowpro Certification. Over all Thanks for your playlist which is helping me a lot
Thank you 🙏 for watching my video @Prasada Rao Baratam and your word of appreciation really means a lot to me. I don't provide any training and planning to share my knolwedge via different playlist, please have a look and suggest if you want on any specific topic. "Snowflake Tutorial bit.ly/3iNTVGI",
First and foremost Thank you. These videos are really very structured and presented. I wanted to understand your answers for Q#9. Why is Availability Zone Management not part of Cloud services layer? According to snowflake documentation "infrastructure Management" is one of the key services managed by "Cloud Service Layer", so don't you think "Availability Zone Management" falls under that
Hello thanks for the content. Just have one doubt regarding one of the quiz question Which one best describes the snowflake architecture ,in the quiz you mentioned 'shared data' but in the slide 30:55 you mentioned 'shared disk & share nothing' can you clarify this?
Hi @Akshay Dwivedi, thank you 🙏 for watching my video and sharing your query. If you look into Hadoop eco system, data is shared across all the compute (same here in snowflake) but compute is shared from same cluster, however in snowflake compute is not shared between two workload and that's why it is called shared disk and shared nothing (compute has a different isolated cluster and it is not a shared cluster unlike Hadoop). I hope this clarifies.
Thank you so much@@DataEngineering . Your videos are really amazing and I have learnt all Snowflake concepts just by watching your videos. THEY ARE JUST WOW !!! I will be writing Snowflake Certification exam soon and hopeful to clear in 1st attempt.
When you submit a query to snowflake, it first parse the query and check if all the objects (like tables or views or functions) exist or not and the user has issued the query having necessary privilege to run it.. and this process does not need virtual warehouse and this step is done by the cloud service layer. Once all looks good, the query is submited to VWH for execution. I hope, this clarifies. Do let me know if you need more input.
a cluster is collection of nodes... for example extra-small cluster has 1 node... and small-cluster has 2-nodes and medium-cluster is 4 node cluster...
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
@@bhavnatiwari3886 Feel free to post your query here.. what kind of doubt you have or help is needed.. you can also post your queries to my insta account (instagram.com/learn_dataengineering/) .. there are lot certification related video already posted
Good idea.. but I request if you can watch ch-19 (ua-cam.com/video/9FejjGVZrPg/v-deo.html) and let me know if you need more advance tutorial.. Suggest if you have any specific use case in mind.. which is very common and need a video.
Thanks @Vivek, will upload soon, I generally publish one video per week or in a two week duration. If you have subscribe to my channel, you will get the notification. ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡ 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 ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Never thought of it, but a good suggestion. Since snowflake is so broad, need to think what is generally asked and where candidate should focus. Can you share some direciton?
@Manoj Paruchuri, Glad you liked it! Thank you 🙏 for watching my video and sharing your feedback 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. And please share your constructive feedback so I can improvise my content and help the snowflake and data engineering community. 🚀 Complete Guide + Question Dump + Revised Syllabus 🚀 ------------------------------------------------------- 🌐 SnowPro Guide -> bit.ly/35S7Rcb 🌐 Revised Jan 2021 Syllabus -> bit.ly/3tqOkJb 🌐 SnowPro Practice Test Playlist of 300 questions -> bit.ly/2ZLQm9E 🚀 You can also follow Data Engineering Channel 🚀 -------------------------------------------------- 🌐 Twitter -> twitter.com/de_simplified 🌐 Facebook -> fb.me/dataengineeringsimplified 🌐 GitHub -> github.com/TopperTips 🌐 Website -> toppertips.com
It would be great if the data model was covered here, it almost seems like the tool is doing everything and not following some kind of structure that a data model will provide in creating the physical design. At leat I would like to see that.
Introduction and architecture are not explained for newbies to data engineering. There are many terms which are just written. Could not understand what it means.
Thanks for your note... they are rich content and hard to convert them into PPT or PDF but you can download the entire playlist summary via this cheat sheet. (Snowflake End To End Guide Cheat Sheet - bit.ly/43t5IPB)
sorry.. they are not power points.. my contents are available in my blog pages and my medium pages .. the content what you see is hard to share.. due to its big size and rich media type (not-ppt).. I recently started sharing my content via udemy as it allows me to share the resources/code/ppt etc..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
Answers to QUIZ question 9 are incomplete, should include point E also: "The cloud services layer If Snowflake detects that an availability zone has become unavailable, the cloud services layer can reprovision the impacted virtual warehouse in a different zone and restart queries that have been in process to ensure that they complete successfully."
There is no pdf dear, the are reach media and very heavy files, will share the sharable content via my website. Please wait, once publish, will let you know.
you may load data and delete them in same day.... so at the end of the month..when storage cost is calculated.. it is done based on avg cost of the store.. and all data is stored in compressed format.. watch my data loading playlist ua-cam.com/play/PLba2xJ7yxHB6NPEv8pp7j3zWibLZzwjvO.html
OLTP needs RDBMS and snowflake can not enforce relationships, referential integrity as well as many contraints... that's why it is called Cloud Data Warehouse and not cloud RDBMS... hope this clarifies..
Thank you very much for this amazing content, its very hard to find good content and most of them are priced too high to commercialize the content. You are helping many people by doing this. Please don't stop doing this work.
No doubt it is a very well structured and detailed video. May I kindly ask for a pdf or ppt for the whole playlist. Reading and taking screenshots diverts mind! Its better if we can get; if not then also no worries.. I'll manage by taking snaps. Thank you so much!
Tnx , i following ur snowflake videos........clear content explanation and at end crisp recap.... nice .....
One of the best explanations on snowflake architecture. Really appreciate on it.
Amazing content..Keep up the good work for the community and tech hungry folks
Thank you! Will do!
Bro your teaching method is awesome! you are real professor who really know how to convey 1000 lines in single line. Thanks a lot bro. I am working as a data engineer, thanks a lot for this video.
Thank you 🙏 for watching my video @Salman Sayyad 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
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Excellent content. I have recently started my learning Journey with Snowflake. After exploring various places, I found the content on this channel as most relevant for beginners. Thoroughly enjoyed this video and going to finish the complete series for sure. Thanks for all your efforts.
Welcome aboard!
Feel free to share your feedback and any queries you have.. you can also send me DM to my instagram (instagram.com/learn_dataengineering/) if you have any queries...
@@DataEngineering aajata hai to 4ttyyyyyttyyyttyytyyyttyttyytyttyyyyrtyytytyytyyyyyyyyytyufiuygdddfiiiddidfifididiidgfdfdd
Yes thanks for all the effort
all concepts are explained in details Thanks .
You are 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
you are doing great job!!Hats off!!
One observation -- scale up/down is for query performance and scale out /down for Query concurrency.
I see it is mentioned in other way in this video. Please check.
Yes, you are right, will check and put a note in the description section.
vERY DETAILED EXPLANATION tHANKS YOU sO MUCH.
Excellent pace and teaching techniques..
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
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Sir really helpful to me actually i learned snowflake in another institute compare to them ur explanation is very clear and interested too.I am very thankful to God,I hv such a grt sir lyk u.I am improving myself.Thank u very much sir fr ur grt efforts
Bro,
I like all your tutorials so far and it is amazing and I recommended everyone to watch it but kindly, would it is possible to have a copy of these slides ? I am looking to make Snowflake certificates and I need a copy for these slides for your all Snowflake. Is this possible.
Thanks.
Awesome tutorial
Glad you liked it
Hi Team,
I am very impressed for the wonderful explanation.
Where can I find the Slides document, Please help me on that.
Thanks Kiran. I am try to share them via my website (toppertips.com).. some of the chapter contents are available, however the content you see is not pdf and they are rich media.. so will see how I can share the content via my blogs.
Wow, such an amazing tutorial. Thank you so much for your effort and kindness. I am just in the 3rd and intend to go through the entire playlist. Could you please let me know if you have either already done or planning to do
a) How to setup dev, test, prod environments for Snowflake?
b) What are some of the best practices, naming conventions?
c) What are the common pitfalls to avoid?
d) Can you provide a comparison of Snowflake vs GCP BigQuery and Snowflake vs AWS Redshift/Athena?
🙏🙏
Thanks.. point (a), (b), & (c) are not covered.. and if I see more demand.. will make videos on them.. I will surely make on point (a)
-----
You can download this summary sheet in PDF version that has detail for all the chapters in one single file.
Snowflake End To End Guide Cheat Sheet - bit.ly/43t5IPB
@@DataEngineering , thanks much.
@@DataEngineering I have the same doubts
a) How to set up dev, test, and prod environments for Snowflake?
b) What are some of the best practices, and naming conventions?
c) What are the common pitfalls to avoid?
d) Can you provide a comparison of Snowflake Big QueryigQuery and Snowflake vs AWS Redshift/Athena?
Can you please explain it or can you make a video on it...
Great content - thank you!
Glad you enjoyed it!
Thank you so much for this amazing content. do u have notes of all the episodes? it will much more helpful.
THANK U SO MUCH, ITS VERY EASY TO UNDERSTAND BY YOUR TEACHING.
YOU ASKED TO REFER DESCRIPTION FOR ADDITIONAL DOCUMENTS, READING MATERIAL, COULD YOU PLEASE TELL, ME WHERE TO FIND THOSE, SLIDES, NOTES ANYTHING FOR QUICK REVISION.
Let me check and review the description part and come back to you.
U have done a great job 🎉🎉🎉🎉👏🏼
Thank you so much 😊
Hi This Vedios are really Good ..can i get pdf of this vedios .
Great Content. Thanks a lot.
Glad you liked it!
Thanks a lot for the such quality of content. I have a question here can we change the Wearhouse size and max and max cluster while running running the query on same Wearhouse? will not be any impact on the query results?
Thanks again.
Yes you can change the warehouse size any time and it does not impact the query result.
Very informative. Keep going. Thanks a lot.
You are most welcome.
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me. Do let me if you find the entire series meaningful or only this video "Snowflake Tutorial bit.ly/3iNTVGI"
Nice. Does Snowflake file reader support excel file. Also in the views. Do we have secure view as well?
as of now.. Snowflake has no direct support for xl files.
and yes snowflake support secure views...find it in my ch-21.3 (ua-cam.com/video/2soTybOZkXY/v-deo.html)
Thanks for the videos, I feel this is the one stop solution for learning snowflake.. I have a request for you to make a video on stored procedure which will be useful to make dynamic data loads using copy command.
Hi sir your all video are very informative and easy to learn and understand.I am amazed the quality of work and at the same time providing to free for all the students where others are charging at high cost.Again thanks for everything you are doing.Meanwhile i was interested in going through the notes as well.If there is premium account for that please let me know that.
Hi Can you provide the documentation or PPT for what ever explaining videos. Teaching is awesome.
it is not ppt.. and that's why hard to share... generally code base is shared via my blog..
you have done very good job
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
Hi How are doing? I am happy with your videos. But my question is, how to prepare notes while you explain? Because while watching I am good with your content. But after some time, I am missing the technical words.
If you don't mind, could you please prepare one video about how to learn snowflake in an easy way as I am new to Snowflake and getting confusion how to start? Thank you so much for your hard work.
great advice... will think and plan something.. Snowflake has lot of thing.. and it is growing very fast .. and lot of features are there to explain. but will see how best I can put a video like this.
Thank you for this great content could you please share the slides? they're very informative
It is hard to share as they are not slides.. they are rich media content.. you can find some of the useful link in the desc section.
Well Explained
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
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
Very detailed explanation on snowflake, I like the way it presented.
Small correction, there is a room for optimization in snowflake for user unoptimized sql by DBA.
Can you please explain the following:
If Snowflake is using underlying storage and compute engine, how is it different from any other cloud data warehouses like Redshift/Synapse ?
Snowflake is SaaS tool and Redshift/Synapse they are Paas tools.. so in snowflake, you don't have to know how data is stored and and what type of compute it is used.. and this need to be selected in Redshift/Synapase... you need to plan infra in them.. but in snowflake is true elastic... you just declare it.. and it will work...
Redshift is a wrapper on the top of postgres and Synapse is using SQL server or Spark... so a developer need to know too much to make thing happens.. but in snowflake.. it is true service.. so you don't need to worry...
I hope, at high level..this clarify... there are lot about them.. but can not write everything here..
@@DataEngineering Thanks for the answer...
Wonderful explanation!! Have the slide decks been shared anywhere?
Thank you 🙏 @ Harikrishnan Chandran for watching my video and your word of appreciation really means a lot to me.
I generally share the content via my website (toppertips.com), and for this video, I have not yet done, will see how can I do it via my website.
Excellent content...some of the best tutorials. Could you add a video on Data Exchange, besides the Data Share video you have added?
Great suggestion! will do it soon .
Superb video as always... could you pleaes improve the audio quality
I will try my best, but could you tell me it is volume or background noise or anything else? That would help me a lot.
At 24:06 you are mentioning full ACID compliance but recommended OLAP only, not OLTP. That is a very strong limitation. So where does it come from ?
Snowflake does not support constraints and single row update is very expensive and slow.. and that's why not suitable for OLTP workload.
very nice!
Thanks for the visit
Hello sir, I'm working in other domain and now I wanted to move on into snowflake and I'm good in SQL, will these training sessions were enough to get into snowflake domain.
Could you please suggest..
Yes, you can learn Snowflake easily.. it is much simpler tool compare to other tool and if you know basic project execution methodology in data space + sql .. you can learn it..
if you have any specific query or doubt.. drop me a msg in my instagram.. ua-cam.com/users/DataEngineeringSimplified
Hi, thanks for providing videos, I have a question for u?, have u used Snowflake DB to create ssrs reports?
Not fully sure but you can create ODBC connection and then you must be able to try it out.
Awesome.
Thank you! Cheers!
Very informative content, thanks alot. Please how can I get the slides?
I will not be able to share the slides as they are rich media .. will share the information via my website and see how well I can organize them..
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
Hi Sir, I am beginner and want to go through more quiz so that I can crack my Snowpro Certification. Over all Thanks for your playlist which is helping me a lot
All the best
Nice explanation , I am looking for training ,
Thank you 🙏 for watching my video @Prasada Rao Baratam and your word of appreciation really means a lot to me.
I don't provide any training and planning to share my knolwedge via different playlist, please have a look and suggest if you want on any specific topic.
"Snowflake Tutorial bit.ly/3iNTVGI",
First and foremost Thank you. These videos are really very structured and presented. I wanted to understand your answers for Q#9. Why is Availability Zone Management not part of Cloud services layer? According to snowflake documentation "infrastructure Management" is one of the key services managed by "Cloud Service Layer", so don't you think "Availability Zone Management" falls under that
Let me check that question, but you are right..
Good session
Thanks...
Much informative videos brother, keep it up
Thanks, will do!
Hi can i get a copy of the slides which is being presented
Hello thanks for the content.
Just have one doubt regarding one of the quiz question
Which one best describes the snowflake architecture ,in the quiz you mentioned 'shared data' but in the slide 30:55 you mentioned 'shared disk & share nothing' can you clarify this?
Hi @Akshay Dwivedi, thank you 🙏 for watching my video and sharing your query.
If you look into Hadoop eco system, data is shared across all the compute (same here in snowflake) but compute is shared from same cluster, however in snowflake compute is not shared between two workload and that's why it is called shared disk and shared nothing (compute has a different isolated cluster and it is not a shared cluster unlike Hadoop). I hope this clarifies.
Wonderful
Thank you 🙏 for watching my video and your word of appreciation really means a lot to me.
Can you please make a video on Caching in Snowflake ?
Thanks for your note, I will surely make a dedicated video on caching.
Thank you so much@@DataEngineering . Your videos are really amazing and I have learnt all Snowflake concepts just by watching your videos. THEY ARE JUST WOW !!! I will be writing Snowflake Certification exam soon and hopeful to clear in 1st attempt.
are there any pdf or ppt available for these chapters please?
Query execution in Compute layer and query compilation in cloud Service layer - can you please explain the difference in the two processes?
When you submit a query to snowflake, it first parse the query and check if all the objects (like tables or views or functions) exist or not and the user has issued the query having necessary privilege to run it.. and this process does not need virtual warehouse and this step is done by the cloud service layer. Once all looks good, the query is submited to VWH for execution.
I hope, this clarifies. Do let me know if you need more input.
@@DataEngineering yes thank you very much
can you explain more about node and cluster ?
a cluster is collection of nodes... for example extra-small cluster has 1 node... and small-cluster has 2-nodes and medium-cluster is 4 node cluster...
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, however some degree of SQL knowledge and cloud awareness will certainly help.
I passed the exam, your videos helped me a lot, thank you !
Great job! and congratulation...
Hi,
Actually i will appearing for the snowflake exam so, can you please give me some idea about it .
It will be helpful for me
Thank you
@@bhavnatiwari3886 Feel free to post your query here.. what kind of doubt you have or help is needed.. you can also post your queries to my insta account (instagram.com/learn_dataengineering/) .. there are lot certification related video already posted
What data modeling method do you use for this database: 3nf, dim, data vault,?
Since it is cloud data warehouse, I am not sure if anybody follows 3NF but dimensional modeling and data vault are common in snowflake.
can you please explain about Scale in and Scale out as I get confused for this
Please check my ch-12 which talks about virtual warehouse and scale-in and scale-out concept in detail.
ua-cam.com/video/NE07Jx6V4UA/v-deo.html
Can u post any project based scenario on Snowflake end to end testinf
Good idea.. but I request if you can watch ch-19 (ua-cam.com/video/9FejjGVZrPg/v-deo.html) and let me know if you need more advance tutorial..
Suggest if you have any specific use case in mind.. which is very common and need a video.
Nice Videos. Please share link to chapter 14 till 25 and more if any..Thanks again.
Thanks @Vivek, will upload soon, I generally publish one video per week or in a two week duration. If you have subscribe to my channel, you will get the notification.
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
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
⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡
where i can get above material
If possible please add videos regarding interview preparation
Never thought of it, but a good suggestion.
Since snowflake is so broad, need to think what is generally asked and where candidate should focus. Can you share some direciton?
Where do I find the source data files?
Nice explation 👍
@Manoj Paruchuri, Glad you liked it!
Thank you 🙏 for watching my video and sharing your feedback 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. And please share your constructive feedback so I can improvise my content and help the snowflake and data engineering community.
🚀 Complete Guide + Question Dump + Revised Syllabus 🚀
-------------------------------------------------------
🌐 SnowPro Guide -> bit.ly/35S7Rcb
🌐 Revised Jan 2021 Syllabus -> bit.ly/3tqOkJb
🌐 SnowPro Practice Test Playlist of 300 questions -> bit.ly/2ZLQm9E
🚀 You can also follow Data Engineering Channel 🚀
--------------------------------------------------
🌐 Twitter -> twitter.com/de_simplified
🌐 Facebook -> fb.me/dataengineeringsimplified
🌐 GitHub -> github.com/TopperTips
🌐 Website -> toppertips.com
@@DataEngineering sure , I do
It would be great if the data model was covered here, it almost seems like the tool is doing everything and not following some kind of structure that a data model will provide in creating the physical design. At leat I would like to see that.
Good suggestion, will do it in separate video.
Introduction and architecture are not explained for newbies to data engineering. There are many terms which are just written. Could not understand what it means.
Question 4 should be a and b right?
it is not shared disk..it is shared data and shared compute
@@DataEngineering thanks
is it possible to get these ppt in an email or could you share the link in the email ?
Thanks for your note... they are rich content and hard to convert them into PPT or PDF but you can download the entire playlist summary via this cheat sheet.
(Snowflake End To End Guide Cheat Sheet - bit.ly/43t5IPB)
From where I can access the power point notes
sorry.. they are not power points.. my contents are available in my blog pages and my medium pages .. the content what you see is hard to share.. due to its big size and rich media type (not-ppt)..
I recently started sharing my content via udemy as it allows me to share the resources/code/ppt etc..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
sir plz provide any pdf documentation to read
Answers to QUIZ question 9 are incomplete, should include point E also:
"The cloud services layer
If Snowflake detects that an availability zone has become unavailable, the cloud services layer can reprovision the impacted virtual warehouse in a different zone and restart queries that have been in process to ensure that they complete successfully."
Text is not visible as it is on a color background.
Thanks for the feedback..my other vides are taking care of that feedback...
👍👌Keep
Glad you liked it..
sir i want pdf for snowflake
There is no pdf dear, the are reach media and very heavy files, will share the sharable content via my website. Please wait, once publish, will let you know.
Can someone plz explain question 11
you may load data and delete them in same day.... so at the end of the month..when storage cost is calculated.. it is done based on avg cost of the store.. and all data is stored in compressed format..
watch my data loading playlist ua-cam.com/play/PLba2xJ7yxHB6NPEv8pp7j3zWibLZzwjvO.html
@@DataEngineering thanku
Y only olap y not oltp
OLTP needs RDBMS and snowflake can not enforce relationships, referential integrity as well as many contraints... that's why it is called Cloud Data Warehouse and not cloud RDBMS... hope this clarifies..
sir please send me
I will publish the content via my website... give me sometime.. website is having some issue
How do we get lecture materials - ppt files
it is not PPT... you can visit my website if you need SQLs or data files.. but for first few chapters.. they are missing.. will add sometime later
@@DataEngineering website content is no match for this presentations ,please share it for Data community growth !