So far in this series I’ve discussed how to create a simple native Streamlit app in Snowflake and connecting an app to Snowflake. In this article I’ll show some additional Streamlit navigation features as well as how to populate form elements from Snowflake data. st.set_page_config In order for the application to use all possible screenContinue reading “Snowflake: Display Query Results in Streamlit”
Tag Archives: sql
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 