https://community.databricks.com/t5/data-engineering/column-access-patterns/m-p/128207#M48181 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/124839">@noorbasha534</a>&nbsp;,</P><P>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.</P> Tue, 12 Aug 2025 12:21:00 GMT SP_6721 2025-08-12T12:21:00Z https://community.databricks.com/t5/data-engineering/column-access-patterns/m-p/128110#M48159 <P>Hello all</P><P>Floating this question again separately ((few weeks ago I clubbed this as part of predictive optimization)) -</P><P>Has anyone cracked to get the list if columns being used in joins &amp; filters, especially in the context that access to end users is given at views level (not table level) &amp; these views can be deeply nested until the point we trace the underlying tables...</P><P>The idea is to map these columns back to the original/underlying tables...</P><P>Appreciate the mind share here.</P><P>Br,</P><P>Noor.</P> Mon, 11 Aug 2025 21:49:09 GMT https://community.databricks.com/t5/data-engineering/column-access-patterns/m-p/128110#M48159 noorbasha534 2025-08-11T21:49:09Z https://community.databricks.com/t5/data-engineering/column-access-patterns/m-p/128207#M48181 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/124839">@noorbasha534</a>&nbsp;,</P><P>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.</P> Tue, 12 Aug 2025 12:21:00 GMT https://community.databricks.com/t5/data-engineering/column-access-patterns/m-p/128207#M48181 SP_6721 2025-08-12T12:21:00Z