Tracking Data lineage from Dashboard -> Business view -> Physical tables

I have a use case where I want to track all the columns used in a dashboard back to the business schema I am pulling from and also need the source column which points to the physical schema but I also need the capability to track lineage of these columns across the physical schemas in a table insight or an mv. Currently, the dashboard’s source column points to the Silver layer, which I can retrieve using inspector metadata. However, I also need the ability to track lineage across physical schemas—for example, from Silver back to Bronze—either at the column level or, if that’s not feasible, at