SQL Stored Procedures | Snowflake Scripting

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?

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!

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

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

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

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.

Very Nice 👌

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