From the course: Snowflake SnowPro Core Cert Prep

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Stored procedures

Stored procedures - Snowflake Tutorial

From the course: Snowflake SnowPro Core Cert Prep

Start my 1-month free trial Buy for my team

Stored procedures

“

So let's just talk about stored procedures in Snowflake, how Snowflake originally provided support for stored procedures with just JavaScript and the JavaScript stored procedures used the JavaScript API, which allowed you to execute SQL statements, retrieve a result set, and obtain metadata about that result set, such as the number and name of columns and data types. That approach, however, came with a very steep learning curve. As you can imagine, for developers who came to Snowflake with a SQL background, there was no alternative at the time to use SQL code directly to create a stored procedure. More recently, however, Snowflake introduced scripting and it's called SQL scripting, which is a SQL extension that supports procedural logic. Now, Snowflake scripting reduces the complexity involved in migrating from relational database systems such as Oracle or SQL Server to Snowflake. Now, just generally, some some of the benefits. And let's just cover off the languages first of all that…

Contents