Column access patterns

noorbasha534
Valued Contributor II

Hello all

Floating this question again separately ((few weeks ago I clubbed this as part of predictive optimization)) -

Has anyone cracked to get the list if columns being used in joins & filters, especially in the context that access to end users is given at views level (not table level) & these views can be deeply nested until the point we trace the underlying tables...

The idea is to map these columns back to the original/underlying tables...

Appreciate the mind share here.

Br,

Noor.

SP_6721
Honored Contributor II

Hi @noorbasha534 ,

I’m not aware of a direct way to do this, but one approach is to parse each view’s SQL definition to identify the columns used in join and filter conditions, then use lineage tools to trace them through nested views back to the underlying tables.