Uploaded September 2021 | Updated September 2026, 16 minutes ago
This tutorial & chapter 8, "Snowflake Must Know New Objects" guides on all those snowflake account level and database level objects that a data developer and lead must know. These objects are not very common across other data warehouse system and snowflake has introduced them with a specific purpose.
Many of us use snowflake as if it is another data warehouse system and only focus on writing SQL statements, stored procedures, or functions (or UDFs). Snowflake has many new objects and knowing their purpose and their power will help you to save a lot of time and also optimize your cost and solution. These new objects not only help to build faster data solutions but also help to build easier and simple ETL or ELT data pipelines.
This hands on visual guide covers following, most important and very frequently used snowflake objects with live examples
1. Sequence Objects,
2. File Formats,
3. Stage Objects
4. Integration Objects
5. Pipe Objects
6. Stream & task Objects
7. Resource monitor
So enjoy this video series and provide your valuable feedback.
🌐 Site: toppertips.com
🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
➥ 00:00 What so special about snowflake new objects
➥ 01:08 Welcome Note
➥ 01:43 Covered in this Chapter 08
➥ 02:06 Sub topics & tree map
➥ 03:05 Why to subscribe this channel
➥ 04:16 Live Demo - Sequence Objects
➥ 09:16 Live Demo - File Format Objects
➥ 15:18 Live Demo - Stage Objects
➥ 21:08 Live Demo - Integration Objects
➥ 23:14 Live Demo - Pipe Objects
➥ 27:14 Live Demo - Stream Objects
➥ 31:37 Live Demo - Task Objects
➥ 34:42 Live Demo - Resource monitor
➥ 40:03 Quick Recap of tree map
➥ 40:03 Thank you note & next chapter
🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter 1-to-25 "Complete Playlist" 🌐 bit.ly/3iNTVGI
➥ Chapter-1 Snowflake Introduction & History 🌐 bit.ly/3xKHrna
➥ Chapter-2 Snowflake Free Trial Registration 🌐 bit.ly/3m6uiCL
➥ Chapter-3 Snowflake Architecture 🌐 bit.ly/3sk2fB2
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 bit.ly/3stSyzS
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 youtu.be/T-l_LN_505Q
➥ Chapter-6 Snowflake Unique Features 🌐 youtu.be/-MZrCpoAUs0
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 youtu.be/Pi3z1NyBd-Y
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 youtu.be/S5NwU2o2Exg
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 youtu.be/lI5OQPjuj-8
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 youtu.be/PNK49SJvXjE
➥ Chapter-11 Snowflake External Table 🌐 youtu.be/w9BQsOlJc5s
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 youtu.be/NE07Jx6V4UA
➥ Chapter-13 Snowflake Micro Partition 🌐 youtu.be/UNBysn1M9Vg
➥ Chapter-14 Snowflake Time Travel 🌐 youtu.be/9k8ADXunhIk
➥ Chapter-15 Snowflake Clone Feature 🌐 youtu.be/cAyM-Nj9WOc
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 youtu.be/2d6d-zZMXtA
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 youtu.be/DXI0GDSwE_E
➥ Chapter-18 Snowflake Task & Task Tree 🌐 youtu.be/165hXZ_o4Vk
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 youtu.be/9FejjGVZrPg
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 youtu.be/pZQXK7qO0iY
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 youtu.be/CsH2sB6gwlw
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐youtu.be/xnjCbgu0Qj4
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 youtu.be/2soTybOZkXY
➥ Chapter-22 Snowflake Information Schema 🌐 youtu.be/kqZRXoFcKo0
➥ Chapter-23 Snowflake Resource Monitor 🌐 youtu.be/2msEUDzp-uU
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 youtu.be/tzbqj2y_cbw
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 youtu.be/X4uXkGS0dUQ
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 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: youtu.be/jhNoKeB0CVY
➥ SnowPro Guide: bit.ly/35S7Rcb
➥ SnowPro Practice Test (60 Questions): bit.ly/2Ubernv
#snowflaketutorial #snowflakeobjects #snowflakecomputing #snowflakedatawrehouse #snowflake #dataengineeringsimplifed #DESimplified#toppertips #snowflakefeatures
This tutorial & chapter 8, "Snowflake Must Know New Objects" guides on all those snowflake account level and database level objects that a data developer and lead must know. These objects are not very common across other data warehouse system and snowflake has introduced them with a specific purpose.
Many of us use snowflake as if it is another data warehouse system and only focus on writing SQL statements, stored procedures, or functions (or UDFs). Snowflake has many new objects and knowing their purpose and their power will help you to save a lot of time and also optimize your cost and solution. These new objects not only help to build faster data solutions but also help to build easier and simple ETL or ELT data pipelines.
This hands on visual guide covers following, most important and very frequently used snowflake objects with live examples
1. Sequence Objects,
2. File Formats,
3. Stage Objects
4. Integration Objects
5. Pipe Objects
6. Stream & task Objects
7. Resource monitor
So enjoy this video series and provide your valuable feedback.
🌐 Site: toppertips.com
🚀 🚀 Chapters 🚀 🚀
-----------------------------------------
➥ 00:00 What so special about snowflake new objects
➥ 01:08 Welcome Note
➥ 01:43 Covered in this Chapter 08
➥ 02:06 Sub topics & tree map
➥ 03:05 Why to subscribe this channel
➥ 04:16 Live Demo - Sequence Objects
➥ 09:16 Live Demo - File Format Objects
➥ 15:18 Live Demo - Stage Objects
➥ 21:08 Live Demo - Integration Objects
➥ 23:14 Live Demo - Pipe Objects
➥ 27:14 Live Demo - Stream Objects
➥ 31:37 Live Demo - Task Objects
➥ 34:42 Live Demo - Resource monitor
➥ 40:03 Quick Recap of tree map
➥ 40:03 Thank you note & next chapter
🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀
---------------------------------------------------------------------------------------------------
➥ Chapter 1-to-25 "Complete Playlist" 🌐 bit.ly/3iNTVGI
➥ Chapter-1 Snowflake Introduction & History 🌐 bit.ly/3xKHrna
➥ Chapter-2 Snowflake Free Trial Registration 🌐 bit.ly/3m6uiCL
➥ Chapter-3 Snowflake Architecture 🌐 bit.ly/3sk2fB2
➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 bit.ly/3stSyzS
➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 youtu.be/T-l_LN_505Q
➥ Chapter-6 Snowflake Unique Features 🌐 youtu.be/-MZrCpoAUs0
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 youtu.be/Pi3z1NyBd-Y
➥ Chapter-8 Snowflake Must Know Database Objects 🌐 youtu.be/S5NwU2o2Exg
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 youtu.be/lI5OQPjuj-8
➥ Chapter-10 Snowflake Continuous Data Loading 🌐 youtu.be/PNK49SJvXjE
➥ Chapter-11 Snowflake External Table 🌐 youtu.be/w9BQsOlJc5s
➥ Chapter-12 Snowflake Virtual Warehouse 🌐 youtu.be/NE07Jx6V4UA
➥ Chapter-13 Snowflake Micro Partition 🌐 youtu.be/UNBysn1M9Vg
➥ Chapter-14 Snowflake Time Travel 🌐 youtu.be/9k8ADXunhIk
➥ Chapter-15 Snowflake Clone Feature 🌐 youtu.be/cAyM-Nj9WOc
➥ Chapter-16 Snowflake Secure Data Sharing 🌐 youtu.be/2d6d-zZMXtA
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 youtu.be/DXI0GDSwE_E
➥ Chapter-18 Snowflake Task & Task Tree 🌐 youtu.be/165hXZ_o4Vk
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 youtu.be/9FejjGVZrPg
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 youtu.be/pZQXK7qO0iY
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 youtu.be/CsH2sB6gwlw
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐youtu.be/xnjCbgu0Qj4
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 youtu.be/2soTybOZkXY
➥ Chapter-22 Snowflake Information Schema 🌐 youtu.be/kqZRXoFcKo0
➥ Chapter-23 Snowflake Resource Monitor 🌐 youtu.be/2msEUDzp-uU
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 youtu.be/tzbqj2y_cbw
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 youtu.be/X4uXkGS0dUQ
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 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: youtu.be/jhNoKeB0CVY
➥ SnowPro Guide: bit.ly/35S7Rcb
➥ SnowPro Practice Test (60 Questions): bit.ly/2Ubernv
#snowflaketutorial #snowflakeobjects #snowflakecomputing #snowflakedatawrehouse #snowflake #dataengineeringsimplifed #DESimplified#toppertips #snowflakefeatures
