Recent Articles

  • Snowflake Demo Repo

    Snowflake Demo Repo

    In the last few months, I’ve posted quite a few articles showing demos in Snowflake. My personal goal was to post one article per week covering a single topic in Snowflake, SQL Server or technical leadership. I accomplished that goal by spending the early morning hours before my family woke up by reading, testing and Read more

  • Snowflake: Stacked Bar Chart in Native Streamlit

    Snowflake: Stacked Bar Chart in Native Streamlit

    In my last article, I showed how to create a simple bar chart in a Native Streamlit app in Snowflake. It works great for simple bar charts. What if I wanted to see the breakdown of parts sales by manufacturer by country/region from the previous example? A stacked bar chart with each manufacturer having a Read more

  • Snowflake: Bar Chart in Native Streamlit

    Snowflake: Bar Chart in Native Streamlit

    So far in this series showing the capabilities of native Streamlit apps in Snowflake, I’ve created an app to display “Hello, world!”, connected to Snowflake to show session info and return query results in a data frame. Now I’ll add some additional functionality to format my app layout in columns and add two selection boxes Read more

  • Snowflake: Display Query Results in Streamlit

    Snowflake: Display Query Results in Streamlit

    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 screen Read more

  • Snowflake: Connecting Native Streamlit Apps

    Snowflake: Connecting Native Streamlit Apps

    In the first article in this series, I covered how to add a simple “Hello, World!” sample Streamlit application to Snowflake. The power of this newer feature comes into play when using data from Snowflake in the Streamlit. With the app running natively on Snowflake the data never leaves the Snowflake ecosystem; therefore, saving on Read more

  • Snowflake: Native Streamlit App

    Snowflake: Native Streamlit App

    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 as Read more