[Feature] Column lineage to see downstream impact

[MikkoPaajanen]

Describe the feature

There is a need to see downstream effect of a column change. It should be visible what downstream models use that changed column and then user could inspect the impact of the downstream models that are affected by this specific column.

At the moment it does show downstream models of the change. But if there's 10 models and only 1 references that column that was changed upstream, it would be nice to see it straightaway instead of going through them one by one.

Describe alternatives you've considered

No response

Who will this benefit?

All the column changes of existing models when the model is referred by multiple downstream models.

Are you interested in contributing this feature?

No response

Anything else?

No response

[DaveFlynn]

Hi @MikkoPaajanen,
Thanks for opening this issue. We're discussing the possibility internally and someone from the development team will respond soon.
Dave

[clkao]

@MikkoPaajanen i think most of the building blocks are there! not sure if you've seen https://github.com/canva-public/dbt-column-lineage-extractor

do you have any initial thoughts on how this can be surfaced in Recce's lineage impact view? perhaps a toggle to swtich between model-level & column-level lineage?

[MikkoPaajanen]

I didn't think that far yet. But a toggle switch might be a good way. Or by clicking a model in the lineage it would show column lineage from that model.