Uploaded November 2023 | Updated September 2026, 2 hours ago
It is important to understand if using stored procedure in Snowflake are Anti-Pattern or Core Design Pattern and that's what we are going to learn in this tutorial.
Unlock the world of stored procedures in data warehousing with our Snowflake Scripting tutorial! Discover common patterns, understand why some consider them bad practice, explore limitations, and dive into real-life Snowflake examples. Plus, get valuable tips for best practices in writing stored procedures with Snowflake scripting.
Once you complete this "stored procedures is anti-pattern" chapter of the Snowflake Scripting For Stored Procedures, you will be able to answer following questions:
1. What are usual ways to use stored procedures in data warehouses?
2. Why are stored procedures seen as a bad practice sometimes?
3. What are the general drawbacks of stored procedures?
4. Can you give real-life examples in Snowflake where scripted stored procedures are handy?
5. What are good tips for writing Snowflake scripting in stored procedures?
🚀🚀 How To Connect
✏ Instagram: instagram.com/learn_dataengineering
✏ Medium Blog: medium.com/@data-engineering-simplified
✏ Exclusive Snowflake Facebook Group: facebook.com/groups/627874916138090
🚀🚀 Chapters
➥ 00:00 Introduction
➥ 00:54 Welcome Note
➥ 02:14 Stored Procedure Vs Anti Pattern
➥ 04:48 Stored Procedure Common Usage
➥ 08:06 Stored Procedure Real Life Examples
➥ 09:24 Stored Procedure Best Practices
➥ 11:34 Special Section
➥ 12:00 Summary & Next Chapter
➥ 12:46 Thank you note & disclaimer
🚀🚀 Snowflake Stored Procedure Playlist
youtube.com/playlist?list=PLba2xJ7yxHB5NksIHMPirkHhOoEG3-K09
✏ Ch-01 Snowflake Scripting For Stored Procedure Introduction youtu.be/-BhYp0X00P0
✏ Ch-02 Stored Procedures Are Anti-Pattern youtu.be/rBwknyABYMU
✏ Ch-03 Snowflake Scripting Block Structure youtu.be/yBaUbCFSMjM
✏ Ch-04 How To Declare Variable youtu.be/CyJ9LPFMhwc
✏ Ch-05 Declare & Define Local Variables youtu.be/pBDeMog56AQ
✏ Ch-06 How To Use Variables youtu.be/U2gbypinWZs
✏ Ch-07 Multiple Variable Assignment youtu.be/HlrcLrbPpD0
✏ Ch-08 Variable Visibility in nested block youtu.be/TvzTr8HPdtM
✏ Ch-09 Return Value/Expression/Table From Stored Proc youtu.be/Gl0x4yxz_Ok
✏ Ch-10 IF ELSEIF ELSE IF-END youtu.be/dmybW_lQuGA
✏ Ch-11 CASE/WHEN Conditional Logic youtu.be/oRzIqDvhyWU
✏ Ch-12 FOR Loop youtu.be/UzKb_TGtqpg
✏ Ch-13 WHILE Loop youtu.be/Q5UU5h7jdNU
✏ Ch-14 REPEAT Loop youtu.be/eNovcmu4Qk4
✏ Ch-15 Work With CURSOR Object youtu.be/MIy3k5SzqYk
✏ Ch-16 Param Binding & CURSOR Object youtu.be/MIy3k5SzqYk
✏ Ch-17 Work With RESULTSET Object youtu.be/MIy3k5SzqYk
✏ Ch-18 Exception Handling In Stored Procedure youtu.be/mP-PqZsl4b8
#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.
It is important to understand if using stored procedure in Snowflake are Anti-Pattern or Core Design Pattern and that's what we are going to learn in this tutorial.
Unlock the world of stored procedures in data warehousing with our Snowflake Scripting tutorial! Discover common patterns, understand why some consider them bad practice, explore limitations, and dive into real-life Snowflake examples. Plus, get valuable tips for best practices in writing stored procedures with Snowflake scripting.
Once you complete this "stored procedures is anti-pattern" chapter of the Snowflake Scripting For Stored Procedures, you will be able to answer following questions:
1. What are usual ways to use stored procedures in data warehouses?
2. Why are stored procedures seen as a bad practice sometimes?
3. What are the general drawbacks of stored procedures?
4. Can you give real-life examples in Snowflake where scripted stored procedures are handy?
5. What are good tips for writing Snowflake scripting in stored procedures?
🚀🚀 How To Connect
✏ Instagram: instagram.com/learn_dataengineering
✏ Medium Blog: medium.com/@data-engineering-simplified
✏ Exclusive Snowflake Facebook Group: facebook.com/groups/627874916138090
🚀🚀 Chapters
➥ 00:00 Introduction
➥ 00:54 Welcome Note
➥ 02:14 Stored Procedure Vs Anti Pattern
➥ 04:48 Stored Procedure Common Usage
➥ 08:06 Stored Procedure Real Life Examples
➥ 09:24 Stored Procedure Best Practices
➥ 11:34 Special Section
➥ 12:00 Summary & Next Chapter
➥ 12:46 Thank you note & disclaimer
🚀🚀 Snowflake Stored Procedure Playlist
youtube.com/playlist?list=PLba2xJ7yxHB5NksIHMPirkHhOoEG3-K09
✏ Ch-01 Snowflake Scripting For Stored Procedure Introduction youtu.be/-BhYp0X00P0
✏ Ch-02 Stored Procedures Are Anti-Pattern youtu.be/rBwknyABYMU
✏ Ch-03 Snowflake Scripting Block Structure youtu.be/yBaUbCFSMjM
✏ Ch-04 How To Declare Variable youtu.be/CyJ9LPFMhwc
✏ Ch-05 Declare & Define Local Variables youtu.be/pBDeMog56AQ
✏ Ch-06 How To Use Variables youtu.be/U2gbypinWZs
✏ Ch-07 Multiple Variable Assignment youtu.be/HlrcLrbPpD0
✏ Ch-08 Variable Visibility in nested block youtu.be/TvzTr8HPdtM
✏ Ch-09 Return Value/Expression/Table From Stored Proc youtu.be/Gl0x4yxz_Ok
✏ Ch-10 IF ELSEIF ELSE IF-END youtu.be/dmybW_lQuGA
✏ Ch-11 CASE/WHEN Conditional Logic youtu.be/oRzIqDvhyWU
✏ Ch-12 FOR Loop youtu.be/UzKb_TGtqpg
✏ Ch-13 WHILE Loop youtu.be/Q5UU5h7jdNU
✏ Ch-14 REPEAT Loop youtu.be/eNovcmu4Qk4
✏ Ch-15 Work With CURSOR Object youtu.be/MIy3k5SzqYk
✏ Ch-16 Param Binding & CURSOR Object youtu.be/MIy3k5SzqYk
✏ Ch-17 Work With RESULTSET Object youtu.be/MIy3k5SzqYk
✏ Ch-18 Exception Handling In Stored Procedure youtu.be/mP-PqZsl4b8
#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.
