When we trace the lineage and try to expand on a large table with hundreds of columns, we see the pop-up warning message: "This object cannot be expanded because the number of components prevents reasonable graphical presentation. Please use the tree in the detail pane to view the contents." What is the limitation on the column number display?
In lineage, the maximum nodes (tables/columns) shown = 200, the maximum links = 1000
When a node is more than 200 and a link more than 1000, we suggest the below options:
- classic textual "business report" lineage with expandable trees (that's actually the default) rather than a graphical display of lineage which would be unreadable even on a huge monitor
- reduce the scope of the lineage at the feature/column level to start with, rather than table level and then expand everything