Charting lineage across views and statements

Question

Hi,

A customer today asked whether we could offer anything like the nice lineage charts that dbt offers, based on SQL view metadata. They are very much aware of our dbt-iris adapter, but were asking in the context of their landing area, which combines foreign tables and views, ahead of possibly using dbt for onward transformations.

I didn't have anything to point at right away, but was wondering if any creative minds in the Developer Community would have looked into something like this, and used any data viz libraries to feed on the DependsOn keyword for SQL view classes that point at the tables they depend on. And while we're at it, a similar (or combined) type of analysis could be made for query statements as a whole, drawing from the INFORMATION_SCHEMA.STATEMENT_RELATIONS table. I'm curious if this resonates with the audience here, and if someone would have particular suggestions wrt the graphics libraries one might use to implement this.

Thanks,
benjamin