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="CAKbGwjNnC"><a href="https://snowflake.pavlik.us/index.php/2020/04/11/overloading-javascript-udfs-in-snowflake/">Overloading JavaScript UDFs in Snowflake</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://snowflake.pavlik.us/index.php/2020/04/11/overloading-javascript-udfs-in-snowflake/embed/#?secret=CAKbGwjNnC" width="600" height="338" title="“Overloading JavaScript UDFs in Snowflake” — Snowflake in the Carolinas" data-secret="CAKbGwjNnC" 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 overloading user defined functions. It’s a great way to handle function calls with parameters of different data types or different numbers of parameters. Developers often overload functions to let users send only relevant parameters. Consider the common SUBSTRING function. You can call it using one of two overloads: In the first statement, the […]https://snowflake.pavlik.us/wp-content/uploads/2020/04/boxes-2624231_640.jpg623640