SQL Stored Procedures | Snowflake Scripting

  Рет қаралды 26,225

Mastering Snowflake

Mastering Snowflake

Күн бұрын

Пікірлер: 19
@thedopeshowh
@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!
@tejasnaik4604
@tejasnaik4604 2 жыл бұрын
we can do overloading of procedure, exception handling like oracle in store procedure.
@mastering_snowflake
@mastering_snowflake 2 жыл бұрын
Can you explain what you mean by ‘overloading’ please?
@hasanmougharbel8030
@hasanmougharbel8030 2 жыл бұрын
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
@mastering_snowflake 2 жыл бұрын
Hey, can you explain what you mean when you refer to a 'module' please?
@babisg6955
@babisg6955 2 ай бұрын
Why use anything other than SQL for stored procedures?
@nagajyothivanapalli5147
@nagajyothivanapalli5147 2 жыл бұрын
Thanks for your video Can we use cursor loop (same as plsql)
@mastering_snowflake
@mastering_snowflake 2 жыл бұрын
Generally you are probably best to use JavaScript stored procs for looping and SQL for set based workloads.
@nagajyothivanapalli5147
@nagajyothivanapalli5147 2 жыл бұрын
@@mastering_snowflake could you please help me Any videos available .please share me i will try to understand
@shaxxie5237
@shaxxie5237 9 ай бұрын
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.
@EricaBerry232
@EricaBerry232 9 ай бұрын
Is a stored procedure the only way to execute multiple SQL statements?
@shashankm2859
@shashankm2859 2 жыл бұрын
how do we print successful message after each step ran successfully in SQL proc in order to debug it?
@mastering_snowflake
@mastering_snowflake 2 жыл бұрын
stackoverflow.com/questions/59145016/print-snowflake-query-in-stored-procedure
@shashankm2859
@shashankm2859 2 жыл бұрын
@@mastering_snowflake Thanks for replying. That is for Java Script, how about in SQL procedure?
@AR-Exp
@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
@mastering_snowflake Жыл бұрын
Using a task is certainly a valid option, yes
@mukunthans3441
@mukunthans3441 2 жыл бұрын
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
@mastering_snowflake 2 жыл бұрын
Please check the role you’re using in snowflake has the correct privileges
@aravindt7723
@aravindt7723 2 жыл бұрын
Very Nice 👌
Stored Procedure In Snowflake | Chapter-21.1 | Snowflake Hands-on Tutorial
1:04:30
Data Engineering Simplified
Рет қаралды 58 М.
Snowflake Scripting - 1 - What is a Stored Procedure? How to write a Procedure?
19:07
How To Use EXECUTE IMMEDIATE  | Snowflake SQL Scripting | Stored Procedure Tutorial | Ch-19
17:19
MySQL: STORED PROCEDURES
8:02
Bro Code
Рет қаралды 109 М.
Snowflake SnowPro Architect Certification | Tips & areas to focus on
16:12
Mastering Snowflake
Рет қаралды 8 М.
Complete Snowflake SQL Scripting For Stored Procedure | Ch-01
16:56
Data Engineering Simplified
Рет қаралды 20 М.
Advanced SQL Tutorial | Stored Procedures + Use Cases
6:15
Alex The Analyst
Рет қаралды 463 М.
Snowflake Architecture - Learn How Snowflake Stores Table data
17:06
Learning Journal
Рет қаралды 284 М.