Snowflake Database/Schema/Table & Container Hierarchy | Chapter-7 | Snowflake Hands-on Tutorial

This snowflake tutorial, chapter 7, primarily focuses Database, Schema, Table & Container Hierarchy concept and focuses on hands on exercise with table creation, be it standard or external or transient or temporary. It also help with real example of data loading into a table via insert statement, or create as select or insert as select or copy command. Alongside standard DDL Creation, this chapter also focuses on 1. Different Data Type while creating tables. 2. Not Null constraints with field 3. Case sensitivity with table names. 4. Describe tables with desc and get_ddl function. 5. Primary Key & Unique Key constraints in Snowflake tables. 6. Query External Stage in Snowflake 🚀🚀 Cheat Sheets 🚀🚀 ➥ Complete Snowflake Tutorial https://rebrand.ly/maj4l6x ➥ Complete Snowflake JSON Guide https://rebrand.ly/d52cef ➥ SQL Script https://data-engineering-simplified.medium.com/snowflake-container-hierarchy-db0ce81efebf 🚀 🚀 Chapters 🚀 🚀 ----------------------------------------- ➥ 00:00 What so special about snowflake tables ➥ 01:05 Welcome Note ➥ 01:37 Covered in this chapter 07 ➥ 01:55 Why to subscribe this channel ➥ 02:56 Sub topic tree map ➥ 04:02 Container - Database - Schema - Table ➥ 05:39 Live Demo - Database, Schema, Table Creation & Describe ➥ 09:21 Live Demo - Snowflake Table DDL & Datatypes ➥ 11:09 Live Demo - Desc Table & get_ddl() ➥ 12:45 Live Demo - Fully Qualified name for table ➥ 13:29 Live Demo - Snowflake Table DDL & string/Varchar datatype ➥ 25:41 Live Demo - Load data via SnowSQL & Put Command ➥ 37:02 Quick Re-cape of tree map ➥ 37:59 Learning in this episode ➥ 38:35 Thank you note & next chapter ➥ 38:54 Disclaimer 🚀 🚀 Snowflake Tutorials (Beginners) All Episodes 🚀🚀 --------------------------------------------------------------------------------------------------- ➥ Chapter 1-to-25 "Complete Playlist" 🌐 https://bit.ly/3iNTVGI ➥ Chapter-1 Snowflake Introduction & History 🌐 https://bit.ly/3xKHrna ➥ Chapter-2 Snowflake Free Trial Registration 🌐 https://bit.ly/3m6uiCL ➥ Chapter-3 Snowflake Architecture 🌐 https://bit.ly/3sk2fB2 ➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 https://bit.ly/3stSyzS ➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 https://youtu.be/T-l_LN_505Q ➥ Chapter-6 Snowflake Unique Features 🌐 https://youtu.be/-MZrCpoAUs0 ➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 https://youtu.be/Pi3z1NyBd-Y ➥ Chapter-8 Snowflake Must Know Database Objects 🌐 https://youtu.be/S5NwU2o2Exg ➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 https://youtu.be/lI5OQPjuj-8 ➥ Chapter-10 Snowflake Continuous Data Loading 🌐 https://youtu.be/PNK49SJvXjE ➥ Chapter-11 Snowflake External Table 🌐 https://youtu.be/w9BQsOlJc5s ➥ Chapter-12 Snowflake Virtual Warehouse 🌐 https://youtu.be/NE07Jx6V4UA ➥ Chapter-13 Snowflake Micro Partition 🌐 https://youtu.be/UNBysn1M9Vg ➥ Chapter-14 Snowflake Time Travel 🌐 https://youtu.be/9k8ADXunhIk ➥ Chapter-15 Snowflake Clone Feature 🌐 https://youtu.be/cAyM-Nj9WOc ➥ Chapter-16 Snowflake Secure Data Sharing 🌐 https://youtu.be/2d6d-zZMXtA ➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 https://youtu.be/DXI0GDSwE_E ➥ Chapter-18 Snowflake Task & Task Tree 🌐 https://youtu.be/165hXZ_o4Vk ➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 https://youtu.be/9FejjGVZrPg ➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 https://youtu.be/pZQXK7qO0iY ➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 https://youtu.be/CsH2sB6gwlw ➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐https://youtu.be/xnjCbgu0Qj4 ➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 https://youtu.be/2soTybOZkXY ➥ Chapter-22 Snowflake Information Schema 🌐 https://youtu.be/kqZRXoFcKo0 ➥ Chapter-23 Snowflake Resource Monitor 🌐 https://youtu.be/2msEUDzp-uU ➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 https://youtu.be/tzbqj2y_cbw ➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 https://youtu.be/X4uXkGS0dUQ ➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 https://youtu.be/ZrhTYKuGFbo ➥ Chapter-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon ➥ Chapter-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 #snowflaketutorial #snowflakeddl #snowflaketable #dataloading #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.