Snowflake continues to impress with additional features being added at a rapid pace. The recent Large Language Model (LLM) announcement at Snowday with Snowflake Cortex is one of the many new features headed our way from Snowflake! One recently added feature is the ability to add a Streamlit app directly to your Snowflake instance. Note that asContinue reading “Snowflake: Native Streamlit App”
Category Archives: Tech Stuff
Snowflake: Procedure Default Parameter Values
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”
SQL Server: “New” String Functions
String manipulation in T-SQL code is not a new concept. I intentionally used “new” to indicate that some of the string functions discussed in this article were added after SQL Server 2016, which was the version I was using until a recent upgrade. Microsoft is constantly adding new features to SQL Server, many times itContinue reading “SQL Server: “New” String Functions”
Eric Heilman 