Lineage of Views

The Data lineage tab contains a diagram that shows how the current view is built based on other views and how data flow from the data sources into the view in each query.

The diagram is a tree that has the current view at the top, as the root node, and the data sources at the bottom, as the leaf nodes. Starting from the current view, it explains how the data exposed by a view is the result of combining the data returned by other views, until you reach the data sources. Click the info icon of a view and a tooltip will appear with information about the specific operations performed by the view: projected fields, JOIN conditions, WHERE conditions, etc. You can click the more-info icon in the tooltip to get a popup with further information.

Diagram with the data lineage for a view

Diagram with the data lineage for a view

This diagram supports basic operations like zoom in, zoom out, moving the diagram by drag and drop, collapsing nodes in the tree, exporting it as an image, etc.

At the upper left corner of the diagram, you have the list of fields in the view. Click one of the fields, and the diagram will highlight the path the data follow from the data sources to the view, traversing all the intermediate views, in order to build that field. Let us imagine we click the field f of the current view. If it is obtained by combining the field f1 of the view v1 and the field f2 of th view v2, both views will be highlighted. However, if it only needs the field f1, only the view v1 will be highlighted. This process goes on until it reaches the data sources. At the end, the subtree that participates in the calculation of field f is highlighted.

Diagram highlighting the path that follow the data to build a specific field in the view

Diagram highlighting the path that follow the data to build a specific field in the view

If you check the information of a view when a field is selected, the fields of that view that are evaluated to build the selected field will be highlighted in bold.

Information of a view highlighting its contribution to build a field

Information of a view highlighting its contribution to build a field

Note

Take into account that you will only see those nodes in the tree view that you are allowed to according to your privileges in Virtual DataPort:

  • For a data source to appear in the diagram, you need to be granted with the CONNECT privilege on its database and with the METADATA privilege on it. Otherwise, it will not appear.

  • For a view to appear in the diagram, you need to be granted with the CONNECT privilege on its database and with the METADATA privilege on it. Otherwise, it will be replaced with a node labeled with the text No Privileges.