Snowflake Tasks & Task Tree | Chapter-18 | Snowflake Hands-on Tutorial

Video Description

Snowflake Tasks & Task Tree are two important components in snowflake to automate your SQL script as well as automate your workflow. Using task and task tree, you can achive lot of automation and data movement from ingestion to consumption layer. These two features are snowflake native components and works very well if designed correctly. This episode is a quick 30min introduction as well as feature elaboration to the task objects and it will help you to answer the following questions 1. How snowflake task works? 2. How snowflake task tree works? 3. What are the limitations of snowflake task objects? 4. Snowflake Task Example to understand how task DDL works? 5. Task & Task Tree Limitations? So enjoy this video series and provide your valuable feedback. 🌐 Site: https://toppertips.com 🌐 SQL Scripts https://www.toppertips.com/snowflake-task-example 🚀 🚀 Chapters 🚀 🚀 ----------------------------------------- ➥ 00:00 What you don't know about snowflake task? ➥ 01:41 Episode introduction ➥ 02:14 What is snowflake task and how does it work? ➥ 04:41 Why to subscribe this channel ➥ 06:42 Hands-on: Task DDL and SQL Construct ➥ 14:26 Hands-on: Task Scheduling (Non-Cron) ➥ 16:05 Hands-on: Task Scheduling Using Cron Keyword ➥ 19:23 Hands-on: Serverless Task ➥ 20:56 Hands-on: Snowflake Task Tree (Workflow & Orchestration) ➥ 25:07 Hands-on: Snowflake Task & Stored Procedure ➥ 28:06 Thank you note 🚀 🚀 Snowflake Tutotorials (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 ➥ SnowPro Practice Test (60 Questions): https://bit.ly/2Ubernv #SnowflakeTask #TaskTreeSnowflake #snowflakeclone #snowflakecomputing #securedatasharing 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.