Recent Articles

  • Spicing Up Your Snowflake Data Apps with Custom Images

    Spicing Up Your Snowflake Data Apps with Custom Images

    Add images to your Streamlit in Snowflake app using an external URL or an internal stage. Upload the image to a stage and reference its path in your app. This feature allows you to give your app some character and branding. Read more

  • Embracing Change: Transitioning from Hands-On to Strategic Leadership

    Embracing Change: Transitioning from Hands-On to Strategic Leadership

    In a recent leader training, I grappled with the challenge of delegation. It’s tough knowing when to dive into details or trust the team. Reframing my role, listening actively to my team, and setting aside focused ‘tinker time’ have been vital adjustments. Leadership is about experimentation and growth. Read more

  • Simplifying AI and ML: Snowflake Cortex Makes it Easy

    Simplifying AI and ML: Snowflake Cortex Makes it Easy

    Summary: Snowflake Cortex, a managed AI and ML service, simplifies AI integration into the Snowflake Platform. With SQL and Python functions, it offers translation, summarization, and predictive analysis. By enabling developers to access large language models, it streamlines AI and machine learning tasks, making it easy to build a Streamlit app within the Snowflake ecosystem. Read more

  • Enhancing Snowflake Apps with Streamlit Pagination

    Enhancing Snowflake Apps with Streamlit Pagination

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

  • Exploring NOAA Weather Stations: Mapping Locations Within Snowflake Using Streamlit

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

  • Snowflake: Loading a Fixed-Width File

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