From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Join today to access over 24,800 courses taught by industry experts.
Stored procedures: Part 1 - Snowflake Tutorial
From the course: Intro to Snowflake for Devs, Data Scientists, Data Engineers
Stored procedures: Part 1
- Now we get to learn about stored procedures. Stored procedures are similar to UDFs in many ways, but there are big differences, and I think they're great to study in succession because learning about the one illuminates the other. So I'm excited to dig in. We'll first spend some time discussing what stored procedures do and how they differ from UDFs, but we'll quickly move into the mechanics of creating and running them, and we'll spend the bulk of our time there. The reason for this is that, as you'll see, stored procedures are so flexible that trying to enumerate their use cases is like trying to describe everything you can do with a pair of scissors. Here we'll focus more on the tactical question of how do you operate the scissors, than in all the things scissors can or cannot do. But we'll cover a few common use cases. So what are stored procedures and how do they differ from UDFs? Let's start by slowing down. I heard the phrase "stored procedure" many, many times before I…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.