Recently, I found myself wrestling with a Streamlit app in Snowflake, tasked with presenting large datasets for user review. However, loading these hefty datasets into a data frame proved sluggish and error-prone, especially with over 400,000 records at play. I stumbled upon a Medium article by Carlos Serrano. He detailed the pagination of Streamlit data frames,Continue reading “Enhancing Snowflake Apps with Streamlit Pagination”
Author Archives: Eric Heilman
Exploring NOAA Weather Stations: Mapping Locations Within Snowflake Using Streamlit
Previously, I walked through loading NOAA Weather Station location data from NOAA’s public S3 bucket into Snowflake, but what now? We have a list of hundreds of weather stations with coordinates, but what can we do with them? What if we plotted them on a map, but only showed those stations within a certain distanceContinue reading “Exploring NOAA Weather Stations: Mapping Locations Within Snowflake Using Streamlit”
Snowflake: Loading a Fixed-Width File
Snowflake boasts powerful import capabilities from data files including CSV, JSON, and Parquet. What about a less frequently used file type – the fixed-width file? Yep! Snowflake can handle that with ease. A fixed-width text file is a type of data file where each line contains records of a predetermined length, with fields aligned inContinue reading “Snowflake: Loading a Fixed-Width File”
Eric Heilman 