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 […]
Using LangGraph Agents to Orchestrate Data Workflows Read More »
AI, Data Engineering, Machine Learning
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 Build your First Streamlit App in Snowflake Read More »
Snowflake, Snowflake Computing, Streamlit, Technical Tutorials
Photo by Andrea De Santis on Unsplash By Deiby Gómez 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 Create Multi-Page Applications with Streamlit Read More »
Streamlit, Uncategorized
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
How to Update your Lambdas to Authenticate with SSH Keys in Snowflake Read More »
AWS, AWS Lambda, Data Engineering, Security, Snowflake
By Deiby Gómez One of the biggest challenges in working with data is giving non-technical users direct access without relying on Data Engineers or Analysts. While SQL remains the backbone of data querying, business users still need to extract insights quickly without writing code. This is where Snowflake Cortex Analyst comes into play. It’s a
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
Why Analytics Leaders Are Embracing Modern Data Platforms: A Look at dbt & Snowflake Read More »
dbt, Modern Data Platform, Snowflake Computing, Strategy
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.
Generative AI’s Unexpected Romance with Scrum Read More »
Agile, AI, project management
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. This
How to Create Dynamic Time-Based Tables in Snowflake Read More »
Cloud Computing, Data Warehousing, Snowflake, Snowflake Computing, SQL, Uncategorized
Photo by Cristina Gottardi on Unsplash The Data Challenge Have you ever wanted to assess or explore a new BI, analytics, data visualization, data science, etc. technology, but struggled to find a data set to use for your assessment and exploration activities? Have you grown tired of analyzing the “typical” free data sources–think census, stock
Got Technology, Need Data? Here’s the Best Free Data Sources for Analytics & AI Read More »
Big Data, Business Intelligence, Data Integration, Data Visualization, Free Data Sources, General, Open Data, Public Data Sets, Tips
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,
How to Combine Advanced and Custom Filters in Looker Studio Read More »
Business Intelligence, Data Analytics, Data Visualization, Looker, Uncategorized