Hi Dan,

We've found that automated, end-to-end lineage (down to the field-level) does the trick, as well as a living, breathing data catalog (data discovery). Check out this post for more info on this approach: https://www.montecarlodata.com/data-catalogs-are-dead-long-live-data-discovery/

And don't hesitate to reach out via LinkedIn if you have more questions!

Barr