Summary
Keywords
Full Transcript
Stored Procedure In Snowflake allows data developer to wrap their complex logic and automate their repeatable manual process. This episode is a comprehensive & practical guide with hands-on excercise on stored procedure. It covers basics of stored procedure including different specification options (input params, language i.e. javascript/sql/java/scala, return type, volatile/immutable, caller/owners rights, strict etc) along side exception handling and transaction. This guide will help you to answer the following questions 🚀 What is caller's right and owner's right? 🚀 Can I write snowflake stored procedure in Javascript? 🚀 Can I write it in Java or Scala too? If so, how can I use it via SQL? 🚀 Java or Scala code gets converted into SQLs? 🚀 How does transaction management work in Snowflake stored procedure? 🚀 What is the limitation of stored procedure in snowflake. So enjoy this video series and provide your valuable feedback. 🌐 Site: https://toppertips.com 🌐 SQL Scripts https://resplendent-cassata-312ecd.netlify.app/stored-procedure-in-snowflake-ch21-part-1 🚀 🚀 Chapters 🚀 🚀 ----------------------------------------- ➥ 00:00 Stored Procedure in Snowflake? ➥ 02:20 Episode-21 (part-1) Introduction ➥ 02:45 Why to subscribe to this channel ➥ 03:45 Lets write our 1st stored procedure ➥ 12:01 Stroed Procedure Construct in Snowflake ➥ 17:14 Called on null input or strict ➥ 20:51 Stroed Procedure Comments in Snowflake ➥ 22:21 Volatile vs Immutable Specificiation ➥ 25:45 Input Param case sensivity ➥ 28:25 Stored Procedure Body in Snowflake ➥ 37:50 Javascript API for Snowflake Stored Procedure ➥ 36:58 Multiline Continuation in snowflake stored procedure ➥ 43:31 Owner's & Caller's rights in Snowflake SP ➥ 48:57 Exception Handling in stored procedure ➥ 55:36 Transaction Management in stored procedure ➥ 60:53 SQL Scripting, Java & Scala in stored procedure ➥ 61:25 Stored procedure - Tips & Limitations ➥ 62:44 Stored procedure vs UDFs in Snowflake ➥ 63:59 Thank you note & Disclaimer 🚀 🚀 Snowflake Tutotorials (Beginners) All Episodes 🚀🚀 --------------------------------------------------------------------------------------------------- ➥ Chapter 1-to-25 "Complete Playlist" 🌐 https://bit.ly/3iNTVGI ➥ Chapter-1 Snowflake Introduction & History 🌐 https://bit.ly/3xKHrna ➥ Chapter-2 Snowflake Free Trial Registration 🌐 https://bit.ly/3m6uiCL ➥ Chapter-3 Snowflake Architecture 🌐 https://bit.ly/3sk2fB2 ➥ Chapter-4 Snowflake Classic or Legacy WebUI 🌐 https://bit.ly/3stSyzS ➥ Chapter-5 Snowflake SnowSight Modern WebUI 🌐 https://youtu.be/T-l_LN_505Q ➥ Chapter-6 Snowflake Unique Features 🌐 https://youtu.be/-MZrCpoAUs0 ➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐 https://youtu.be/Pi3z1NyBd-Y ➥ Chapter-8 Snowflake Must Know Database Objects 🌐 https://youtu.be/S5NwU2o2Exg ➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐 https://youtu.be/lI5OQPjuj-8 ➥ Chapter-10 Snowflake Continuous Data Loading 🌐 https://youtu.be/PNK49SJvXjE ➥ Chapter-11 Snowflake External Table 🌐 https://youtu.be/w9BQsOlJc5s ➥ Chapter-12 Snowflake Virtual Warehouse 🌐 https://youtu.be/NE07Jx6V4UA ➥ Chapter-13 Snowflake Micro Partition 🌐 https://youtu.be/UNBysn1M9Vg ➥ Chapter-14 Snowflake Time Travel 🌐 https://youtu.be/9k8ADXunhIk ➥ Chapter-15 Snowflake Clone Feature 🌐 https://youtu.be/cAyM-Nj9WOc ➥ Chapter-16 Snowflake Secure Data Sharing 🌐 https://youtu.be/2d6d-zZMXtA ➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐 https://youtu.be/DXI0GDSwE_E ➥ Chapter-18 Snowflake Task & Task Tree 🌐 https://youtu.be/165hXZ_o4Vk ➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐 https://youtu.be/9FejjGVZrPg ➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐 https://youtu.be/pZQXK7qO0iY ➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐 https://youtu.be/CsH2sB6gwlw ➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐https://youtu.be/xnjCbgu0Qj4 ➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐 https://youtu.be/2soTybOZkXY ➥ Chapter-22 Snowflake Information Schema 🌐 https://youtu.be/kqZRXoFcKo0 ➥ Chapter-23 Snowflake Resource Monitor 🌐 https://youtu.be/2msEUDzp-uU ➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐 https://youtu.be/tzbqj2y_cbw ➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐 https://youtu.be/X4uXkGS0dUQ ➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐 https://youtu.be/ZrhTYKuGFbo ➥ Chapter-25 (Part-1) Snowflake & PowerBI Reporting 🌐 coming-soon ➥ Chapter-25 (Part-2) Snowflake & Tableau Reporting 🌐 coming-soon #StoredProcedureSnowflake #JavaScriptStoredProcedure #StoreProcedureVsUDFs #securedatasharing #deltaloadsnowflake 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.
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
