Using LangGraph Agents to Orchestrate Data Workflows

By Deiby Gómez

If you want your data workflows to make decisions on the fly, this post shows how to do it with LangGraph Agents. You’ll see how they compare to traditional tools and how to set them up in your projects. In data engineering and intelligent systems, complex pipelines have traditionally relied on tools [..]

How to Build your First Streamlit App in Snowflake

By Deiby Gómez Photo by Mark Basarab on Unsplash As Data Engineers, we focus on building robust data pipelines, optimizing queries, and ensuring data reliability at scale. With Streamlit now available in Snowflake, you can build and deploy interactive data apps directly inside your Snowflake environment. There’s no need to leave the platform or set

How to Create Multi-Page Applications with Streamlit

By Deiby Gómez Photo by Andrea De Santis on Unsplash As Data Engineers, there’s a growing need to present data pipelines, monitoring tools, and insights through lightweight, user-friendly web applications. Streamlit has become a go-to framework for building these tools due to its speed, simplicity, and native integration with the Python data ecosystem. Streamlit allows

How to Update your Lambdas to Authenticate with SSH Keys in Snowflake

By Deiby Gómez Snowflake is deprecating user/password authentication in favor of key pair authentication. This impacts AWS Lambda-based data pipelines that currently rely on legacy authentication. This article explains how to update your Lambda functions to use SSH key-based authentication when connecting to Snowflake. You’ll learn how to securely store your private key in AWS

Why Analytics Leaders Are Embracing Modern Data Platforms: A Look at dbt & Snowflake

By Kristi Smith Are you an analytics leader thinking about moving to a more modern data platform, but not sure where to start? Makes sense; there are a lot of options out there. Red Pill Analytics understands that analytics leaders are facing a tough challenge: how to transform raw data into insights while managing complex

Generative AI’s Unexpected Romance with Scrum

By Kristi Smith Hey there! If you’re a Scrum team member in the software development world, you’ve probably found yourself knee-deep in Scrum meetings, wondering if there’s a better way to handle all those sticky notes and ceremonies. Even rock-star Scrum teams hit roadblocks — those marathon meetings, communication snafus, and admin work that steals precious time.

How to Create Dynamic Time-Based Tables in Snowflake

By Deiby Gómez In data analysis and reporting, handling time-based data is crucial. Many workflows require the ability to generate and work with time sequences—such as creating calendar tables, tracking events at specific intervals, or managing detailed schedules. Snowflake, a cloud-based data warehousing platform, offers tools to handle these needs through its SQL capabilities.

How to Combine Advanced and Custom Filters in Looker Studio

By Kristi Smith Note: Looker, now part of Google Cloud’s Looker Studio, remains a powerful BI tool for creating dashboards. While this guide focuses on combining filters in Looker, the steps also apply to Looker Studio environments. Matches Advanced Filters I’m constantly impressed with the advanced filter functionality in Looker. It’s so convenient…and fairly intuitive.