The latest articles on Forem by Christian Wagner (@chrhiswagat). https://forem.com/chrhiswagat https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3690591%2F0c9c35b7-ce3a-4b08-a1d9-49b3a870d182.png https://forem.com/chrhiswagat en Christian Wagner Fri, 02 Jan 2026 23:44:47 +0000 https://forem.com/chrhiswagat/stop-manually-tracing-azure-synapse-dependencies-p2e https://forem.com/chrhiswagat/stop-manually-tracing-azure-synapse-dependencies-p2e <p>Tracing dependencies across 50+ DWH objects manually takes time, and documentation is outdated the moment you finish. I stopped after 20.<br> Existing lineage tools struggle with complex stored procedures, are expensive, or cloud-dependent. So I built my own.</p> <p><strong>The Build</strong><br> Used Claude Code. More time-consuming than expected: planning, building, changing, and lots of testing — especially keeping parsing rules stable without regression after each change.</p> <p><strong>Technical Specs:</strong></p> <ul> <li>YAML Parser: Extraction rules defined in YAML — no need to touch Python to add new SQL patterns</li> <li>Stack: Python metadata-driven + React Flow UI</li> <li>Privacy: Client-side/local in import mode, or direct connect to DWH</li> <li>Scope: Object-level (column-level not supported)</li> <li>Tested with: Azure Synapse</li> <li>Deployment: Docker-ready</li> </ul> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F5na34cvssw6e56br01sk.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F5na34cvssw6e56br01sk.png" alt=" " width="800" height="398"></a></p> <p><strong>Result</strong><br> Easy dependency analysis. More use cases to follow.</p> <p><strong>Get It</strong><br> Full source released under MIT.<br> 👉 <a href="https://chrisdevrepo.github.io/data_lineage/" rel="noopener noreferrer">GitRepo</a></p> <p>Repo, live demo, and video walkthrough all linked there.<br> Feedback welcome — it’s yours to explore or fork.</p> <p>Greetings,<br> Christian</p> database sql opensource dataengineering