Case Study
Clear Skies Ahead with Data Governance
Challenges
Large Commercial Airline operating a global data organization, managed 1,400+ Talend jobs across 20+ teams, orchestrated in Talend Management Console (TMC) and versioned in Azure DevOps. With Snowflake becoming the analytical backbone, the client needed to answer critical questions at scale:
Which Talend jobs read/write specific Snowflake databases, schemas, tables, and columns
Which jobs violated naming, context, or mapping standards
How to reconcile inventory mismatches between TMC and Git
How to deliver trusted lineage and metadata to Collibra for governance and discovery
Manual spreadsheets and scripts couldn’t keep pace with these demands
PaaS Solution
The company adopted ADEPT to automate column-level lineage discovery and transformation capture. ADEPT delivered a governed, end-to-end view of lineage, mapping each CDE from source → transformations → target reports.
- Automated lineage extraction: Captured every column-level transformation, including joins, filters, and calculated fields
- Source-to-target mapping: Provided transparent lineage through all data processing stages
- Audit-ready outputs: Generated governed reports for auditors with reproducible evidence
- Cross-team alignment: Reduced reliance on SMEs by centralizing lineage into a single framework
Results
Audit Efficiency: Reduced audit preparation from 6 months to just 3 days
Risk Reduction: Eliminated manual documentation gaps, strengthening compliance posture
Productivity Gains: Freed multiple teams from months of repetitive lineage work
