Uploaded January 2024 | Updated September 2026, 2 hours ago
This tutorial video explains using the RETURN keyword in Snowflake scripting to send back a value, expression, or result set from a stored procedure. It begins by discussing the necessity of the return statement in a stored procedure, then covers topics like specifying return properties, using multiple return statements, and how data types are handled during implicit casting.
Upon completing the " How To RETURN A Value/Expression/Table" chapter, you'll be ready to answer the following questions:
1. How to write a stored procedure that returns nothing?
2. How to write a stored procedure that returns a result set?
3. How to write a stored procedure that returns a table?
4. It is possible to write a stored procedure that returns a non-null value?
5. Is it possible to have multiple return statement from a stored procedure?
🚀🚀 Data Engineering Simplified - Social Links
instagram.com/learn_dataengineering - Connect Via Instagram
medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
facebook.com/groups/627874916138090 - Join Exclusive Snowflake Facebook Group
🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
medium.com/@data-engineering-simplified/f3a1bd5659e0 (Medium Blog Page For SQL Script)
🚀🚀 Chapters
--------------------------
➥ 00:00 Introduction
➥ 01:26 Scope of the video
➥ 01:41 Welcome Note
➥ 03:04 Use Of RETURN keyword & its usage
➥ 06:48 Part-01 Stored Procs without Return statement
➥ 09:24 Part-02 RETURN fixed value, expression or select stmt
➥ 12:29 Part-03 Multiple Return Statements
➥ 14:11 Part-04 Return Data Type & Implicit Casting
➥ 17:10 Part-05 Not Null Specification
➥ 18:22 Part-06 Return RESULTSET as Table
➥ 22:30 Summary
➥ 23:11 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.
This tutorial video explains using the RETURN keyword in Snowflake scripting to send back a value, expression, or result set from a stored procedure. It begins by discussing the necessity of the return statement in a stored procedure, then covers topics like specifying return properties, using multiple return statements, and how data types are handled during implicit casting.
Upon completing the " How To RETURN A Value/Expression/Table" chapter, you'll be ready to answer the following questions:
1. How to write a stored procedure that returns nothing?
2. How to write a stored procedure that returns a result set?
3. How to write a stored procedure that returns a table?
4. It is possible to write a stored procedure that returns a non-null value?
5. Is it possible to have multiple return statement from a stored procedure?
🚀🚀 Data Engineering Simplified - Social Links
instagram.com/learn_dataengineering - Connect Via Instagram
medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles
facebook.com/groups/627874916138090 - Join Exclusive Snowflake Facebook Group
🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page
medium.com/@data-engineering-simplified/f3a1bd5659e0 (Medium Blog Page For SQL Script)
🚀🚀 Chapters
--------------------------
➥ 00:00 Introduction
➥ 01:26 Scope of the video
➥ 01:41 Welcome Note
➥ 03:04 Use Of RETURN keyword & its usage
➥ 06:48 Part-01 Stored Procs without Return statement
➥ 09:24 Part-02 RETURN fixed value, expression or select stmt
➥ 12:29 Part-03 Multiple Return Statements
➥ 14:11 Part-04 Return Data Type & Implicit Casting
➥ 17:10 Part-05 Not Null Specification
➥ 18:22 Part-06 Return RESULTSET as Table
➥ 22:30 Summary
➥ 23:11 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.
