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!
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.
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
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!
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.
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?
Is a stored procedure the only way to execute multiple SQL statements?
we can do overloading of procedure, exception handling like oracle in store procedure.
Can you explain what you mean by ‘overloading’ please?
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
Very Nice 👌
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
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