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!
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?
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.
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
Why use anything other than SQL for stored procedures?
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!
we can do overloading of procedure, exception handling like oracle in store procedure.
Can you explain what you mean by ‘overloading’ please?
how do we print successful message after each step ran successfully in SQL proc in order to debug it?
stackoverflow.com/questions/59145016/print-snowflake-query-in-stored-procedure
@@mastering_snowflake Thanks for replying. That is for Java Script, how about in SQL procedure?
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?
Using a task is certainly a valid option, yes
Is a stored procedure the only way to execute multiple SQL statements?
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
Please check the role you’re using in snowflake has the correct privileges
Thanks for your video Can we use cursor loop (same as plsql)
Generally you are probably best to use JavaScript stored procs for looping and SQL for set based workloads.
@@mastering_snowflake could you please help me Any videos available .please share me i will try to understand
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.
Hey, can you explain what you mean when you refer to a 'module' please?
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.
Very Nice 👌