Complete Snowflake SQL Scripting For Stored Procedure | Ch-01
Welcome to our snowflake tutorial series, "Snowflake Scripting for Stored Procedure!" Dive into the world of Snowflake Scripting, where data developers can effortlessly write anonymous blocks or Stored Procedures to tackle a spectrum of use cases, from the straightforward to the very complicated ones.
This comprehensive playlist serves as your go-to guide, offering a deep dive into the intricacies of creating and optimizing Stored Procedures using Snowflake Scripting. Whether you're a beginner seeking foundational knowledge or an experienced developer aiming to refine your skills, this tutorial is your key to unlocking the full potential of Snowflake Scripting for Stored Procedures.
Once you complete this introduction chapter of the Snowflake Scripting For Stored Procedures, you will be able to answer following questions:
1. When was Snowflake scripting introduced to the Snowflake feature set?
2. What led to the addition of Snowflake SQL Scripting in Snowflake?
3. How does Snowflake Scripting behave in relation to Snowflake Cloud instances and Snowflake editions?
4. How can one identify various scenarios or use cases that Snowflake Scripting stored procedures can address?
5. What are the different programming constructs that can be utilized to write stored procedures in Snowflake?
🚀🚀 Data Engineering Simplified - Social Links
/ learn_dataengineering - Connect Via Instagram
/ data-engineering-simplified - Read Medium Blog Pages For Articles
/ 627874916138090 - Join Exclusive Snowflake Facebook Group
🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
/ f3a1bd5659e0 (Medium Blog Page For SQL Script)
🚀🚀 Chapters
➥ 00:00 Introduction
➥ 01:36 Welcome Note
➥ 02:56 Complete Snowflake Scripting Syllabus
➥ 06:49 Snowflake Scripting History
➥ 08:43 Scenarios For Using Stored Procedures
➥ 10:26 Scenario-01 - General Automation Case
➥ 11:43 Scenario-02 - Owner's Rights Case
➥ 12:51 Scenario-03 - Task & Single SQL Stmt Case
➥ 13:34 Scenario-04 - Stale Stream Object State Case
➥ 15:04 Snowflake Scripts Vs JS/Python/Java/Scala
➥ 15:38 Summary & What Next
➥ 16:25 Thank You Note
🚀🚀 Snowflake Stored Procedure Playlist
• Snowflake SQL Scripting For Stored Procedu...
✏ Ch-01 Snowflake Scripting For Stored Procedure Introduction • Complete Snowflake SQL Scripting For Store...
✏ Ch-02 Stored Procedures Are Anti-Pattern • Snowflake Stored Procedures Are Anti-Patte...
✏ Ch-03 Snowflake Scripting Block Structure • Snowflake Scripting Block Structure For St...
✏ Ch-04 How To Declare Variable • Snowflake Scripting - How To Declare Varia...
✏ Ch-05 Declare & Define Local Variables • Snowflake SQL Scripting - Work With Local ...
✏ Ch-06 How To Use Variables • Snowflake SQL Scripting - How To Use Varia...
✏ Ch-07 Multiple Variable Assignment • Snowflake Scripting - Assign Multiple Valu...
✏ Ch-08 Variable Visibility in nested block • Stored Procedure - Variable Scope & Visibi...
✏ Ch-09 Return Value/Expression/Table From Stored Proc • Stored Procedure - How To RETURN A Value/E...
✏ Ch-10 IF ELSEIF ELSE IF-END • Exploring IF-ELSE Conditional Logic in Dep...
✏ Ch-11 CASE/WHEN Conditional Logic • How To Use CASE/WHEN Conditional Logic - S...
✏ Ch-12 FOR Loop • Working With FOR Loops | Snowflake Scripti...
✏ Ch-13 WHILE Loop • Working With WHILE Loop | Snowflake Script...
✏ Ch-14 REPEAT Loop • Working With REPEAT Loop | Snowflake Scrip...
✏ Ch-15 Work With CURSOR Object • Working With CURSOR Object | Snowflake Scr...
✏ Ch-16 Param Binding & CURSOR Object • Working With CURSOR Object | Snowflake Scr...
✏ Ch-17 Work With RESULTSET Object • Working With CURSOR Object | Snowflake Scr...
✏ Ch-18 Exception Handling In Stored Procedure • Complete Exception Handling Guide | Snowfl...
#storedprocedure
#snowflakecomputing
#snowflakedatawrehouse
#snowflake
#dataengineeringsimplifed
#DESimplified
#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.