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”
Tag Archives: data engineering
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”
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 andContinue reading “Snowflake Demo Repo”
Eric Heilman 