1. Concepts

redlin is a specialized Python module built for comprehensive data lineage analysis and tracking, particularly tailored for complex SQL environments like Exasol and MicroStrategy.

At its core, redlin is designed to bring transparency to data ecosystems. It parses and maps out intricate SQL data flows, helping data engineers visualize exactly how data moves, transforms, and is consumed from its raw source to its final target. By leveraging powerful parsing logic under the hood (including tools like sqlglot), it breaks down complex queries into structured, traceable lineage trees.

Key capabilities include:

• Automated SQL Parsing: Deep inspection of SQL scripts and transformations to automatically extract table and column-level relationships.

• Targeted Ecosystem Support: Built with specific lineage generation logic for Exasol data warehouses and MicroStrategy reporting layers.

• Developer-First Tooling: Equipped with a dedicated command-line interface (redlinctl) and structured as a modern Python package (managed via uv), making it easy to integrate into CI/CD pipelines and automated workflows.

Topics:

• 1.1. Architecture
• 1.2. Workflow
• 1.3. Datamodel
• 1.4. Exploring Lineage Graphs
• 1.5. Live Lineage