Introduction

This cookbook shows how to use Chicory AI agents to improve pipeline efficiency.

Tools & Integrations

• BigQuery – SQL execution and runtime insights

• dbt – Models and transformations

• Airflow – DAG orchestration and pipeline lineage

• DataHub / Redash – Metadata and dashboards

• GitHub – Source control & pull request workflow

• REST API – Deployment mechanism for Chicory agents

---

Problem: Cloud data warehouse queries and models often create inefficiencies. Without a comprehensive review of the entire data lakehouse environment, it becomes difficult to understand the broader impact that a proposed change may have on the system.

What You’ll Build

An agent that:

• Scans PR diffs for inefficient code

• Predicts pipeline performance impact

• Suggests targeted fixes

• Posts automated comments on PRs