Stored Procedure In Snowflake | Chapter-21.1 | Snowflake Hands-on Tutorial

Опубликовано: 12 Ноябрь 2024
на канале: Data Engineering Simplified

55,896

645

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://toppertips.com/stored-procedu...

🚀 🚀 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 🌐    • Snowsight - Snowflake Modern Web UI |...
➥ Chapter-6 Snowflake Unique Features 🌐    • Snowflake Unique Features | Chapter-6...
➥ Chapter-7 Snowflake DB/Schema/Table & Data Loading 🌐    • Snowflake Database/Schema/Table & Con...
➥ Chapter-8 Snowflake Must Know Database Objects 🌐    • Snowflake Must Know New Objects  | Ch...
➥ Chapter-9 Snowflake Fast Data Loading/Ingestion 🌐    • Fast Data Loading & Bulk Ingestion in...
➥ Chapter-10 Snowflake Continuous Data Loading 🌐    • Continuous Data Loading & Data Ingest...
➥ Chapter-11 Snowflake External Table 🌐    • How to work with external table in Sn...
➥ Chapter-12 Snowflake Virtual Warehouse 🌐    • How To Work With Snowflake Virtual Wa...
➥ Chapter-13 Snowflake Micro Partition 🌐    • #13 | Micro Partitions & Data Cluster...
➥ Chapter-14 Snowflake Time Travel 🌐    • What is Snowflake Time Travel | Chapt...
➥ Chapter-15 Snowflake Clone Feature 🌐    • Snowflake Zero Copy Clone | Chapter-1...
➥ Chapter-16 Snowflake Secure Data Sharing 🌐    • Snowflake Data Sharing | Chapter-16 |...
➥ Chapter-17 Snowflake Streams & Change Data Capture 🌐    • Snowflake Stream & Change Data Captur...
➥ Chapter-18 Snowflake Task & Task Tree 🌐    • Snowflake Tasks & Task Tree | Chapter...
➥ Chapter-19 ETL (Data Pipeline) in Snowflake 🌐    • ETL Workflow In Snowflake | Chapter-1...
➥ Chapter-20 Role, Grants & Role Hierarchy in Snowflake 🌐    • Role, Grants & Role Hierarchy In Snow...
➥ Chapter-21 (Part-1) Stored Procedure in Snowflake 🌐    • Stored Procedure In Snowflake | Chapt...
➥ Chapter-21 (Part-2) User Defined Function in Snowflake 🌐   • User Defined Functions In Snowflake |...
➥ Chapter-21 (Part-3) Snowflake Views (Standard, Secure & Materialized) 🌐    • What are views in Snowflake  | Chapte...
➥ Chapter-22 Snowflake Information Schema 🌐    • What Is Information Schema In Snowfla...
➥ Chapter-23 Snowflake Resource Monitor 🌐    • What Is Resource Monitor In Snowflake...
➥ Chapter-24 (Part-1) Snowflake JDBC Driver 🌐    • How to Use Snowflake Java JDBC Driver...
➥ Chapter-24 (Part-2) Snowflake ODBC Driver 🌐    • Microsoft Excel & Snowflake ODBC Driv...
➥ Chapter-24 (Part-3) Snowflake Python Connector 🌐    • Snowflake Python Connector | Snowflak...
➥ 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.