Uploaded December 2023 | Updated September 2026, 3 hours ago
The Snowflake Stored Procedure allows you to include nested or anonymous blocks within the body of your stored procedure. In certain situations, you may declare a variable with a different or identical name. It's crucial to grasp how variable scope and visibility operate when dealing with nested or deeply nested blocks. This tutorial and hands-on guide will help you comprehend the workings of nested blocks and variable visibility in Snowflake.
Upon completing the "Variable Scope & Visibility In Nested Block" chapter, you'll be ready to answer the following questions:
1. How can nested blocks or deep nested blocks be defined in a Snowflake stored procedure?
2. What is the mechanism behind variable scoping and visibility in a nested block within a Snowflake stored procedure?
3. Is it permissible to define a variable with the same name as the stored procedure parameter?
4. Can a variable be defined with the same name as a global variable within a stored procedure?
5. If a variable is not visible to the outer block, does the stored procedure throw an error during compilation or execution?
🚀🚀 How To Connect
✏ Instagram: instagram.com/learn_dataengineering
✏ Medium Blog: medium.com/@data-engineering-simplified
✏ Exclusive Snowflake Facebook Group: facebook.com/groups/627874916138090
🚀🚀 Stored Procedure SQL Scripts
medium.com/@data-engineering-simplified/f3a1bd5659e0
🚀🚀 Chapters
--------------------------
➥ 00:00 Introduction
➥ 01:20 Scope of the video
➥ 01:53 Welcome Note
➥ 03:11 Outer & Inner Block Definition
➥ 07:28 Scenario-01 Duplicate Variable Names
➥ 08:17 Scenario-01 Duplicate Variable With Parameters
➥ 12:22 Thank You Note
🚀🚀 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.
The Snowflake Stored Procedure allows you to include nested or anonymous blocks within the body of your stored procedure. In certain situations, you may declare a variable with a different or identical name. It's crucial to grasp how variable scope and visibility operate when dealing with nested or deeply nested blocks. This tutorial and hands-on guide will help you comprehend the workings of nested blocks and variable visibility in Snowflake.
Upon completing the "Variable Scope & Visibility In Nested Block" chapter, you'll be ready to answer the following questions:
1. How can nested blocks or deep nested blocks be defined in a Snowflake stored procedure?
2. What is the mechanism behind variable scoping and visibility in a nested block within a Snowflake stored procedure?
3. Is it permissible to define a variable with the same name as the stored procedure parameter?
4. Can a variable be defined with the same name as a global variable within a stored procedure?
5. If a variable is not visible to the outer block, does the stored procedure throw an error during compilation or execution?
🚀🚀 How To Connect
✏ Instagram: instagram.com/learn_dataengineering
✏ Medium Blog: medium.com/@data-engineering-simplified
✏ Exclusive Snowflake Facebook Group: facebook.com/groups/627874916138090
🚀🚀 Stored Procedure SQL Scripts
medium.com/@data-engineering-simplified/f3a1bd5659e0
🚀🚀 Chapters
--------------------------
➥ 00:00 Introduction
➥ 01:20 Scope of the video
➥ 01:53 Welcome Note
➥ 03:11 Outer & Inner Block Definition
➥ 07:28 Scenario-01 Duplicate Variable Names
➥ 08:17 Scenario-01 Duplicate Variable With Parameters
➥ 12:22 Thank You Note
🚀🚀 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.
