## 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 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.

## Behind the Error Message: Solving row_count package bug in dbt

By Tatum Brannan  
Photo by Ashley Batz on Unsplash  
Exploring dbt Test Features  
Struggling with the dbt row_count package bug? Follow our step-by-step guide to quickly resolve the issue and keep your data pipeline running smoothly. dbt provides a variety of intrinsic testing options. Among these, you’ll find fundamental tests like unique, not_null, accepted_values, and...

## Master dbt Testing: How to Avoid False Negatives when Testing Between Project Layers

We have a small project with four layers:  
1. Raw — incoming raw data  
2. Validation — Relationship and data validations. Transformations into facts and dims  
3. Reporting — joining facts and dims to meet presentation requirements  
4. Business Application — presentation layer. Views, with security where needed, of the reporting objects  
When we added relationship tests between project...