#3 | Snowflake Architecture | Snowflake Tutorial for Beginners

Video Description

This third and most important chapter covers the snowflake architecture including the life cycle and 3 unique layers of snowflake design. Chapter-3 of the snowflake beginner's tutorial covers the Snowflake architecture & design approach in detail. In general, the snowflake is known as a cloud-native platform that supports storage & computes decoupling but how does it achieve this is now known to us and this video chapter helps you understand this concept in detail.  This chapter also compares some of the tools like Spark (Spark Vs Snowflake), Hadoop Map Reduce (Hadoop Vs Snowflake), BigQuery (BigQuery vs Snowflake), Redshift (Redshift vs Snowflake), Cassandra (Cassandra vs Snowflake), etc.  🚀🚀 Data Engineering Simplified Snowflake Cheat Sheets 🚀🚀 ------------------------------------------------------------------------------------------------------ ➥ Complete Snowflake Tutorial Cheat Sheet - https://rebrand.ly/maj4l6x ➥ Complete Snowflake JSON Guide Cheat Sheet - https://rebrand.ly/d52cef 🚀🚀 Data Engineering Simplified Blog Pages 🚀🚀 ------------------------------------------------------------------------------------------------------ ➥ https://medium.com/@data-engineering-simplified ➥ https://toppertips.com 🚀 🚀 Episode-03 Chapters 🚀 🚀 ----------------------------------------------------- ➥ 00:00 Introduction ➥ 00:54 What is covered in them ➥ 02:18 Why you should subscribe to Data Engineering Simplified Channel ➥ 02:58 Traditional Data Warehouse Architecture ➥ 06:35 Snowflake 3 Layer Unique Architecture ➥ 10:53 Decode Snowflake Storage Layer ➥ 13:22 Decode Snowflake Compute Layer ➥ 15:40 Decode Snowflake Cloud Service Layer ➥ 17:41 Lifecycle of a query in Snowflake World ➥ 20:52 Developer's day - Snowflake At a Glance ➥ 23:11 Quick Recap ➥ 26:54 Quiz Time (12 Questions) ➥ 30:52 What we have learned in this chapter ➥ 31:25 What is next chapter (Snowflake Legacy WebUI) ➥ 31:59 Disclaimer 🚀 🚀 All Episodes 🚀🚀 --------------------------------------------------------------------------------------------------- ➥Ch-1-to-25 "Complete Playlist" 🌐 https://bit.ly/3iNTVGI ➥Ch-1 Snowflake Introduction & History 🌐 https://bit.ly/3xKHrna ➥Ch-2 Snowflake Free Trial Registration 🌐 https://bit.ly/3m6uiCL ➥Ch-3 Snowflake Architecture 🌐 https://bit.ly/3sk2fB2 ➥Ch-4 Snowflake Classic or Legacy WebUI 🌐 https://bit.ly/3stSyzS ➥Ch-5 Snowflake SnowSight Modern WebUI 🌐 https://youtu.be/T-l_LN_505Q ➥Ch-6 Snowflake Unique Features 🌐 https://youtu.be/-MZrCpoAUs0 ➥Ch-7 Snowflake DB/Schema/Table & Data Loading 🌐 https://youtu.be/Pi3z1NyBd-Y ➥Ch-8 Snowflake Must Know Database Objects 🌐 https://youtu.be/S5NwU2o2Exg ➥Ch-9 Snowflake Fast Data Loading/Ingestion 🌐 https://youtu.be/lI5OQPjuj-8 ➥Ch-10 Snowflake Continuous Data Loading 🌐 https://youtu.be/PNK49SJvXjE ➥Ch-11 Snowflake External Table 🌐 https://youtu.be/w9BQsOlJc5s ➥Ch-12 Snowflake Virtual Warehouse 🌐 https://youtu.be/NE07Jx6V4UA ➥Ch-13 Snowflake Micro Partition 🌐 https://youtu.be/UNBysn1M9Vg ➥Ch-14 Snowflake Time Travel 🌐 https://youtu.be/9k8ADXunhIk ➥Ch-15 Snowflake Clone Feature 🌐 https://youtu.be/cAyM-Nj9WOc ➥Ch-16 Snowflake Secure Data Sharing 🌐 https://youtu.be/2d6d-zZMXtA ➥Ch-17 Snowflake Streams & Change Data Capture 🌐 https://youtu.be/DXI0GDSwE_E ➥Ch-18 Snowflake Task & Task Tree 🌐 https://youtu.be/165hXZ_o4Vk ➥Ch-19 ETL (Data Pipeline) in Snowflake 🌐 https://youtu.be/9FejjGVZrPg ➥Ch-20 Role, Grants & Role Hierarchy in Snowflake 🌐 https://youtu.be/pZQXK7qO0iY ➥Ch-21 (Part-1) Stored Procedure in Snowflake 🌐 https://youtu.be/CsH2sB6gwlw ➥Ch-21 (Part-2) User Defined Function in Snowflake 🌐https://youtu.be/xnjCbgu0Qj4 ➥Ch-21 (Part-3) Snowflake Views (Std, Secure & Materialized) 🌐 https://youtu.be/2soTybOZkXY ➥Ch-22 Snowflake Information Schema 🌐 https://youtu.be/kqZRXoFcKo0 ➥Ch-23 Snowflake Resource Monitor 🌐 https://youtu.be/2msEUDzp-uU ➥Ch-24 (Part-1) Snowflake JDBC Driver 🌐 https://youtu.be/tzbqj2y_cbw ➥Ch-24 (Part-2) Snowflake ODBC Driver 🌐 https://youtu.be/X4uXkGS0dUQ ➥Ch-24 (Part-3) Snowflake Python Connector 🌐 https://youtu.be/ZrhTYKuGFbo ➥Ch-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon ➥Ch-25 (Part-2) Snowflake & Tableau Reporting 🌐 coming-soon 🚀 🚀 Snowflake Certification Complete Guide & Question Dump 🚀 🚀 ----------------------------------------------------------------------------------------------------------------- ➥ Revised Sep 2020 Syllabus: https://youtu.be/jhNoKeB0CVY ➥ SnowPro Guide: https://bit.ly/35S7Rcb ➥ SnowPro Practice Test (60 Questions): https://bit.ly/2Ubernv #snowflakearchitecture #snowflaketutorial #snowflakecomputing #snowflakedatawrehouse #snowflake #dataengineeringsimplifed #DESimplified #toppertips #dataengineering #clouddatawarehouse Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.