SQL Stored Procedures | Snowflake Scripting

[@thedopeshowh]

great tutorial! my company is migrating out of Oracle to Snowflake and this just gave me some great insight as to where i need to start learning. Thanks for posting!

[@babisg6955]

Why use anything other than SQL for stored procedures?

[@tejasnaik4604]

we can do overloading of procedure, exception handling like oracle in store procedure.

[@mastering_snowflake]

Can you explain what you mean by ‘overloading’ please?

[@EricaBerry232]

Is a stored procedure the only way to execute multiple SQL statements?

[@shaxxie5237]

the main thing i came here for was to see how to pass in a parameter into a SP by calling it. IT would be great if you could show this.

[@hasanmougharbel8030]

Hey there, i feel blessed to keep in touch with you, through asking questions. As a newbie sql learner i have a general enquiry. I learned that a module can contain routines, procedures, or SQL commands. What is the distinct difference between those three components. Thanks for taking care of this.

[@mastering_snowflake]

Hey, can you explain what you mean when you refer to a 'module' please?

[@shashankm2859]

how do we print successful message after each step ran successfully in SQL proc in order to debug it?

[@mastering_snowflake]

stackoverflow.com/questions/59145016/print-snowflake-query-in-stored-procedure

[@shashankm2859]

@@mastering_snowflake Thanks for replying. That is for Java Script, how about in SQL procedure?

[@mukunthans3441]

Hi Adam, when I used strored procedure to access query_history view using sysadmin role..I am getting following error "Requested information on the current user is not accessible in stored procedure" kindly do the needful

[@mastering_snowflake]

Please check the role you’re using in snowflake has the correct privileges

[@nagajyothivanapalli5147]

Thanks for your video Can we use cursor loop (same as plsql)

[@mastering_snowflake]

Generally you are probably best to use JavaScript stored procs for looping and SQL for set based workloads.

[@nagajyothivanapalli5147]

@@mastering_snowflake could you please help me Any videos available .please share me i will try to understand

[@AR-Exp]

I want to "create or replace table as 'select * from view' " using stored procedure, and execute the procedure at 6 AM Daily, Do I have to make a task that executes the procedure?

[@mastering_snowflake]

Using a task is certainly a valid option, yes

[@aravindt7723]

Very Nice 👌