2023-12-11 08-54-13
Neha Agrawal
Champion
AI-Powered Impact Semantic Analysis - Data Contract Sentry
43
Views
0
Comments
New
AI/ML

An AI agent that acts as a "Guardian" for our Data Fabric. 
When a developer changes an entity (like changing a User_ID from a LongInteger to Text), the AI scans not just the OutSystems code, but also the "Contracts" with external tools like Power BI, Snowflake, and external APIs. It warns the developer before they publish: "Stop! This change will break the 'Sales Dashboard' in Power BI." 

Real-World Example

  • Imagine we have an OutSystems app for Order Management.
  • We decide to change the Price field from a Decimal to a Text (maybe to support currency symbols).
  • The Internal Impact: OutSystems tells us to fix the math formulas in the app. We fix them. 0 Errors. Happy!
  • The Hidden External Impact: * Power BI: A "Revenue Chart" was pulling that Price field. Now it crashes because it can't "Sum" text.
  • Snowflake: An automated data pipeline was expecting a Number. Now it rejects every new record.

The AI Sentry Solution: Before we click "1-Click Publish," the AI pops up with a -

"⚠️ External Impact Detected: The Price attribute is consumed by Snowflake Pipeline 'Orders_Sync' and Power BI Report 'Global_Sales'. These systems expect a Decimal. Changing this to Text will cause 2 downstream failures. Do you want to notify those teams?"


Low code tools that already address this issue - 

  • Atlan - Automatically maps how a change in a database affects a dashboard in real-time.
  • Informatica (CLAIRE AI) - Uses AI to predict the "blast radius" of a metadata change across different systems.
  • Collibra - "Harvests" metadata from different tools (SQL, APIs, BI) to show a visual map of dependencies.