Building data models and KPIs shouldn’t be a multi-day project. In this demo, see how Peliqan AI helps data engineers and analytics teams debug SQL query pipelines and generate KPIs in minutes – using a live Chargebee connection (customers, invoices, items, transactions).
What you’ll see:
1. Query lineage debugging
We build a chain of dependent queries (Query1 Query2 Query3), then break it by removing a column. Peliqan AI investigates the failure, traces the lineage across the pipeline, and fixes the broken query — with the full reasoning shown step by step. You can interrupt the agent at any time, inspect every tool call, and approve write actions manually or with auto-accept.
2. KPI generation from project notes
With a single prompt, Peliqan AI reads your project notes, identifies the KPIs that matter, and structures the SQL using the Medallion architecture. Results are ready to verify in seconds.
– No more hunting through pipelines to find what broke
– Lineage-aware fixes instead of guesswork
– KPIs structured the right way, following modern data warehouse best practices
– Full transparency and human-in-the-loop control