Uploaded December 2023 | Updated September 2026, 3 hours ago
Once variables are defined, it's important to use them effectively. In this video, we'll explore how to utilize variables in Snowflake SQL Scripting statements and standard SQL statements. We'll cover using variables in standard expressions, including understanding data types. Additionally, we'll delve into using the colon notation to access variables within SQL statements and explore the role of the identifier function. This tutorial aims to assist you in writing complex, dynamic, and efficient stored procedures using Snowflake scripting.
This comprehensive video explores all possibilities and explain each concept by demonstrating SQL examples executions using the Snowsight WebUI.
After finishing the "How To Use Variables" chapter, you'll be equipped to answer the following questions:
1. How do you use variables within the BEGIN/END section in a stored procedure?
2. How do you employ COLON notation when working with Snowflake scripting?
3. How do you utilize the identifier function in Snowflake scripting?
4. How can you determine when to use colon notation and when it's unnecessary?
5. How do you distinguish whether a statement belongs to Snowflake scripting or a standard SQL statement?
🚀🚀 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
➥ 00:19 Scope of the video
➥ 01:31 Welcome Note
➥ 02:53 How To Use Variable Within begin and end section
➥ 02:51 How To Use Variable Within BEGIN-END
➥ 09:00 Variable in Snowflake Script Expression
➥ 11:51 Text Variable & Double Pipe Notation
➥ 15:23 How To Use Colon Notation
➥ 18:38 How To Use Identifier For Variable
➥ 23:49 When To Use Colon Notation
➥ 24:44 Summary & What Next
➥ 25:50 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.
Once variables are defined, it's important to use them effectively. In this video, we'll explore how to utilize variables in Snowflake SQL Scripting statements and standard SQL statements. We'll cover using variables in standard expressions, including understanding data types. Additionally, we'll delve into using the colon notation to access variables within SQL statements and explore the role of the identifier function. This tutorial aims to assist you in writing complex, dynamic, and efficient stored procedures using Snowflake scripting.
This comprehensive video explores all possibilities and explain each concept by demonstrating SQL examples executions using the Snowsight WebUI.
After finishing the "How To Use Variables" chapter, you'll be equipped to answer the following questions:
1. How do you use variables within the BEGIN/END section in a stored procedure?
2. How do you employ COLON notation when working with Snowflake scripting?
3. How do you utilize the identifier function in Snowflake scripting?
4. How can you determine when to use colon notation and when it's unnecessary?
5. How do you distinguish whether a statement belongs to Snowflake scripting or a standard SQL statement?
🚀🚀 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
➥ 00:19 Scope of the video
➥ 01:31 Welcome Note
➥ 02:53 How To Use Variable Within begin and end section
➥ 02:51 How To Use Variable Within BEGIN-END
➥ 09:00 Variable in Snowflake Script Expression
➥ 11:51 Text Variable & Double Pipe Notation
➥ 15:23 How To Use Colon Notation
➥ 18:38 How To Use Identifier For Variable
➥ 23:49 When To Use Colon Notation
➥ 24:44 Summary & What Next
➥ 25:50 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.
