1.0Snowflake in the Carolinashttps://snowflake.pavlik.usGreg Pavlikhttps://snowflake.pavlik.us/index.php/author/greg_nozz9ly9/rich600338<blockquote class="wp-embedded-content" data-secret="q7RUqm8KHl"><a href="https://snowflake.pavlik.us/index.php/2020/03/16/helper-functions-in-snowflake-stored-procedures/">Helper Functions in Snowflake Stored Procedures</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://snowflake.pavlik.us/index.php/2020/03/16/helper-functions-in-snowflake-stored-procedures/embed/#?secret=q7RUqm8KHl" width="600" height="338" title="“Helper Functions in Snowflake Stored Procedures” — Snowflake in the Carolinas" data-secret="q7RUqm8KHl" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript"> /* <![CDATA[ */ /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://snowflake.pavlik.us/wp-includes/js/wp-embed.min.js /* ]]> */ </script> Snowflake supports JavaScript stored procedures. You may choose to start by copying and modifying a sample Snowflake stored procedure from the documentation, often this one. As you add more SQL statements, exception handling and increase code complexity, having all code in the main JavaScript function risks becoming spaghetti code. Fortunately, Snowflake stored procedures allow more […]https://snowflake.pavlik.us/wp-content/uploads/2020/03/Clippy_StoredProcedure.jpg555450