Is there a way to distinguish between direct and indirect column relationships?

[brampostma-alt]

I want to know when a column is directly used for the value of a downstream column or when the column is only used for filtering etc.

For example, I have the following code:

COALESCE(
    table1.columnA,
    MAX(table1.columnA)
        OVER (PARTITION BY table1.columnB ORDER BY 1)
) AS columnC,

Here i would like to know that columnC has a direct relationship with columnA but only a indirect relationship with columnB. Is there anyway of retrieving this difference. Currently the lineage-extractor tells me simply that columnC depends on both columnA and columnB