Lineage of Views

The “Lineage” tab displays a graph of the data sources and views used to build the current view (considering it is not a base view). It also displays the source where the information of each field comes from. As explained in the graph for associations, this graph allows you to zoom in/out and to move through it with the mouse or with the arrows in the image. You can also export the current image.

By clicking on a node, you can see all its data: name, type, projected fields, where conditions, join conditions, etc.

Data lineage for a view

Data lineage for a view

You can also inspect the data lineage for a specific field. On the left side of the dialog, there is a list of all the view’s fields. By clicking on one of the fields, all the views and data sources that participate in the creation of this field will be highlighted. For instance, if a field f is obtained by evaluating an expression involving two fields f1 and f2 from different data sources, Virtual DataPort will highlight the data sources (and their associated views) providing f1 and f2, and the view where the expression to obtain the value of f is defined.

Data lineage for a field

Data lineage for a field

Details on the data lineage for a field

Details on the data lineage for a field

It is important to note that the information shown within the data lineage depends on the permissions of the current user. This way:

  • To see a data source, the user needs the privilege “METADATA” over the data source and “CONNECT” over the Virtual DataPort database of the data source; otherwise, they will not appear in the graph.

  • To see a view, the user needs the privilege “METADATA” over the view and “CONNECT” over the Virtual DataPort databases of the view; otherwise, a node with the legend “No Privileges” will appear.