Prizm Pulse installs statistics

GitHub Application Integration for dbt Projects (Prizm)

This GitHub application continuously captures pull request (PR) and commit-level changes from your dbt repositories, stores them in your database, and makes them available to the Investigation Agent. When an alert triggers, the agent correlates the alert with recent code changes and lineage context to generate a root-cause hypothesis—including the exact PR, files, authors, and downstream impact.

How it works (end-to-end)

• Capture PR • Monitors PR open/merge events and associated commits. • Detects changes to .sql and .yml files (typically under models/ and seeds/). • Extract + persist change metadata • Parses diffs to identify: • Models/assets changed • What changed (SQL/YAML diff signals) • PR + commit details (PR number/link, author, timestamps, branch) • Stores this metadata in your database as an auditable change log. • Lineage-aware investigation • When an alert occurs, the Investigation Agent: • Starts from the impacted downstream asset(s) • Traverses upstream through lineage to find the most likely originating change • Checks for recent PRs/commits touching any upstream models in the path • Produces a ranked root-cause hypothesis tied back to the exact PR(s)

Key features

• Automated change tracking across PRs/commits • Lineage traversal (upstream + downstream) to connect one code change to many impacted models • Root-cause hypothesis generation that links alerts to: • PR number + link • Changed files and models • Author and time of change • Downstream assets affected

Example insight

• “Alert on order_invoice.amount likely caused by PR #42 (merged 2 hours ago) which modified models/orders.sql; downstream lineage shows order_invoice depends on orders.”

Benefits

• Accelerates root-cause analysis for data incidents by connecting alerts to recent code changes • Improves visibility and accountability with a clear, auditable PR-to-asset change history • Strengthens governance and collaboration in dbt-driven environments