Stored procedures working session | Creating SQL stored procedures hands on practice #snowflake

Stored procedures working session | Creating SQL stored procedures hands on practice #snowflake Topics covered in this video : Creating stored procedures Hello world procedures Calling stored procedures calling stored procedures with stored procedures #snowflake #database #cloud #cloudservices We'll be doing a complete series of Snowflake from scratch. So watch the full series with practicals. Complete snowflake tutorial series : EP: 1 to 5 - https://www.youtube.com/playlist?list=PLyIbExU0mZYN6IBs8KfF0P5gWmirD2cEp 6th episode : Create a file format link : https://youtu.be/IIM6c2gjef4 7th episode : Configuring snowsql with snowflake link : https://youtu.be/TlMnmfU_j7c 8.(i) episode : Internal stages concept video link : https://youtu.be/5fIvNEs0Y1o 8.(ii) episode : Practical session of data loading link : https://youtu.be/iEWUay0dPEQ 8.(iii) episode : Loading CSV, PSV & TSV Files link : https://youtu.be/KF5oTHM51GU 8.(iv) episode : Loading big data files link : https://youtu.be/2VUSNPHGEFE 8.(v) episode : Loading files with special char link : https://youtu.be/hwTkaqeZ4Q8 9. Create free trial AWS Account link : https://youtu.be/RiAyYIxsfgQ 10. AWS S3 configuration with Snowflake link : https://youtu.be/btRMAhQjgJc 11. Data loading from aws s3 external stages link : https://youtu.be/IHssUT1EoY8 12. Zero copy cloning in snowflake. link : https://youtu.be/s_DAUOy0yrk 13. What is Time travel ? Retention period? link : https://youtu.be/LZ_MRIGPz7Q 13.1. Time Travel complete practical link : https://youtu.be/VwFLDP1JH28 14.1. What is Caching ? Results cache & local disk cache link : https://youtu.be/lQS33vDUOlw 14.2 Caching full practical link : https://youtu.be/9WW5ZY6HoLE 15.1 Unloading to External stages link : https://youtu.be/Y441SW85AYQ 15.2 Unloading to Internal stages link : https://youtu.be/NX6Ug0Q1D28 16.1 Data Sharing full concept link : https://youtu.be/2ZqcDj-AS1Q 16.2 Data Sharing to snowflake users link : https://youtu.be/sSggA-SoSPQ 16.3 Data sharing to non-snowflake users link : https://youtu.be/3BjEwxfaIdU 17.1 Types of tables | Permanent, Transient & Temporary table link : https://youtu.be/C383wf0MdVs 17.2 Types of tables practical session link : https://youtu.be/_4h9X-gnqAg 18.1 External tables on ext/int stages concept link : https://youtu.be/uufPaB8S_bU 18.2 External tables on ext/int stages practical link : https://youtu.be/qb4idm-zv2Y 19.1 Streams in snowflake | Types of streams link : https://youtu.be/0INNeaD0xHc 19.2 Streams Practical session link : https://youtu.be/t6FTMnTBFLk 20.1 Tasks in snowflake full concept link : https://youtu.be/BOCaJH6LFWQ 20.2 Tasks in snowflake full practical session link : https://youtu.be/RvgNBdPmJ5g 21 Streams + Tasks together Hands-on link : https://youtu.be/JGuk1pVtjhg 22.1 What is snowpipe? link : https://youtu.be/H0RPAGcrEY4 22.2 Snowpipe working session link : https://youtu.be/O0sUEeXokCA 23.1 JSON processing from Internal stages link : https://youtu.be/1LtnbfrfLBk 23.2 JSON Processing from External stages link : https://youtu.be/iRFlFm-CUgE 23.3 JSON Adv session on object construct, array agg & parse json link : https://youtu.be/KiK1dbw3v6w 23.4 JSON Adv session of Flattening link : https://youtu.be/cAKAE2_2irI 24.1 Data Sampling concept link : https://youtu.be/eOv5uCcZ2RA 24.2 Data Sampling Practical link : https://youtu.be/eUlyrd8Gx0o 25 Dynamic data masking link : https://youtu.be/c3UgJIn3b8o Complete snowflake tutorial playlist : https://www.youtube.com/playlist?list=PLyIbExU0mZYN6IBs8KfF0P5gWmirD2cEp If you guys face any problem then you can comment down or DM on instagram with the following link. Instagram :- https://www.instagram.com/ishivam._yadav For Scripts and files used in the video, checkout my github account : https://github.com/shivam-sky/Snowflake_Full_Course_tutorial I hope you like the video if u do then hit the like button and if you are new to this channel then please subscribe to my channel and also hit the bell icon so that you can never miss any updates from Asky Coding. THANKS FOR WATCHING & PLEASE SUBSCRIBE 🙏🙏🙏🙏🙏🙏🙏 types of functions in snowflake full hands on user defined functions in snowflake snowflake functions and types of functions UDF in snowflake scalar and tabular udf in snowflake snowflake complete session on functions user defined functions in snowflake snowflake user defined functions functions in snowflake user defined functions in snowflake examples examples of user defined functions in snowflake how to create a stored procedures stored procedures in snowflake how to work with stored procedures stored procedures examples using sql language stored procedures examples using sql and javascript stored procedures in snowflake full concept stored procedures in snowflake how to create a stored procedures in snowflake stored procedures difference between stored procedures and udf in snowflake stored procedures full practical stored procedures full practical session