Snowflake makes creating stored procedures easy. Make sure that you have the database in context where you want to create the stored procedure.
--Create a hello world Snowflake Stored Procedure.
create or replace procedure MyProcedure()
--Optionally return a value, only one.
returns VARCHAR
language JavaScript
as
-- The "$$" indicates the beginning and end of the JavaScript code
-- in the stored procedure
$$
// Since we're in Javascript now, use Javascript comment markers.
return "Hello world."
$$;
Now, let’s run the stored procedure.
--Call the stored procedure.
call MyProcedure();
The output will look like this:
