A few weeks ago, I wrote about polymorphism in Snowflake as a way to “get around” the issue with Snowflake procedures not allowing default parameter values. As the Snowflake platform evolves, more features are constantly being added – today I discovered that default parameter values are supported in procedures! Prior Example Review In the previous example, IContinue reading “Snowflake: Procedure Default Parameter Values”
Category Archives: Snowflake
Snowflake: Greatest and Least Functions
In a recent post, I discussed the GREATEST and LEAST functions in SQL Server 2022. Both of these functions exist in Snowflake, but after some testing, I found that they behave differently in Snowflake than in SQL Server when dealing with NULL values. While the functions behave differently, there are options to “get around” theContinue reading “Snowflake: Greatest and Least Functions”
Snowflake: Overloading Stored Procedures
In a previous post, I discussed some of the struggles I had with converting a stored procedure from SQL Server to Snowflake – namely, the ability to set input parameters to default values. One way to get around this issue is to “overload” the procedure in Snowflake. Snowflake supports polymorphism whereas SQL Server does not.Continue reading “Snowflake: Overloading Stored Procedures”
Eric Heilman 