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”
Category Archives: Python
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”
Python Byte: Loading Data to Snowflake from SQL Server
For a recent proof of concept, I needed to transfer data from five or six relatively small tables from SQL Server to Snowflake. Normally, I would go through all the steps to set up an ingestion pipeline in Snowflake; however, for a POC, that all seemed like overkill. I simply needed to copy the dataContinue reading “Python Byte: Loading Data to Snowflake from SQL Server”
Eric Heilman 