Uploaded December 2023 | Updated September 2026, 1 hour ago
When dealing with stored procedures and anonymous blocks in Snowflake, it's crucial to grasp the methods for defining and declaring variables. Within the DECLARE section, various approaches exist for declaring variables in Snowflake, encompassing options such as specifying default values using expressions, built-in functions, and select statements.
This comprehensive video explores all these possibilities and elucidates each concept by demonstrating executions using the Snowsight WebUI.
Upon completion of the "Snowflake Scripting - How To Declare Variable" chapter, you'll gain the knowledge to address the following questions:
1. In Snowflake scripting within a Stored Procedure, what is the process for declaring a variable?
2. How can a default value be set for a variable in Snowflake scripting within a Stored Procedure?
3. In a Stored Procedure using Snowflake scripting, what steps are involved in utilizing a built-in function as the default value for a variable?
4. What are the various SQL data types that can be assigned to a variable in Snowflake scripting within a Stored Procedure?
🚀🚀 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:49 Scope of the video
➥ 01:34 Welcome Note
➥ 02:54 3-Approaches To Declare Variable
➥ 06:14 Declare Variable
➥ 08:46 Case Sensitivity
➥ 11:13 Default Value
➥ 15:36 Function As Expression
➥ 19:17 Multiple Function As Expression
➥ 20:48 Select Query As Expression
➥ 25:48 Assign Variable to Variable
➥ 27:58 Data Type Inference
➥ 30:48 Different Data Type Declaration
➥ 35:34 Infer Data Type - Select Query
➥ 38:09 Multiple Value Assignment
➥ 39:49 Summary & What Next
➥ 41:01 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.
When dealing with stored procedures and anonymous blocks in Snowflake, it's crucial to grasp the methods for defining and declaring variables. Within the DECLARE section, various approaches exist for declaring variables in Snowflake, encompassing options such as specifying default values using expressions, built-in functions, and select statements.
This comprehensive video explores all these possibilities and elucidates each concept by demonstrating executions using the Snowsight WebUI.
Upon completion of the "Snowflake Scripting - How To Declare Variable" chapter, you'll gain the knowledge to address the following questions:
1. In Snowflake scripting within a Stored Procedure, what is the process for declaring a variable?
2. How can a default value be set for a variable in Snowflake scripting within a Stored Procedure?
3. In a Stored Procedure using Snowflake scripting, what steps are involved in utilizing a built-in function as the default value for a variable?
4. What are the various SQL data types that can be assigned to a variable in Snowflake scripting within a Stored Procedure?
🚀🚀 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:49 Scope of the video
➥ 01:34 Welcome Note
➥ 02:54 3-Approaches To Declare Variable
➥ 06:14 Declare Variable
➥ 08:46 Case Sensitivity
➥ 11:13 Default Value
➥ 15:36 Function As Expression
➥ 19:17 Multiple Function As Expression
➥ 20:48 Select Query As Expression
➥ 25:48 Assign Variable to Variable
➥ 27:58 Data Type Inference
➥ 30:48 Different Data Type Declaration
➥ 35:34 Infer Data Type - Select Query
➥ 38:09 Multiple Value Assignment
➥ 39:49 Summary & What Next
➥ 41:01 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.
