USER MANUALS


360 Graph (pka Reference Lineage)

The 360 Graph pill contains a graph that shows the external elements that use this view and how data flow from the view. Additionally, the node of this view is linked to its Data Lineage diagram, which shows how the current view is built based on other views and how data flows from the data sources into the view.

The 360 Graph now offers two visualization modes —tree and network— improving data clarity and accessibility. Both 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.

360 Graph Tree View

The 360 Graph highlights the current view as the root node. All other entities are connected as outgoing nodes, which can be leaf nodes or linked to a View node if this use a View to be built.

Diagram with the 360 Tree Graph for a view

Diagram with the 360 Tree Graph for a view

360 Graph Network View

For more complex relationship scenarios, a network view is shown. Instead of following a strict tree structure, the graph expands into a network layout to improve data clarity. The root node remains highlighted, along with all the relationships originating from it. However, the option to switch back to the tree view remains available.

Diagram with the 360 Network Graph for a view

Diagram with the 360 Network Graph for a view

360 Graph Components

There are two types of nodes: one line nodes or two line nodes. Both show the left-icon, the type and the minus or plus icon, except for the leaf nodes. The two-line nodes also show a left-icon, the name, and a more-info icon, when the element has a details page. The nodes are classified in three different groups which are identified by a color code in the top-left icon.

In Reports his classification uses red for Denodo Elements, grey for Data Sources, and blue for External Elements. The group of external elements can also be identified by the icon representing its server type, such as Tableau or Power BI. In contrast, custom external elements offer more versatility, allowing you to configure their colors and icons as detailed in the Setup Guide

To obtain more information about some element click the node and a tooltip will appear with information about the element: Connection Type, Extracts, Dataset Type, Server Type, etc. You can click the more-info icon in the tooltip to get a popup with further information. The view nodes have an expand button which show the Data Lineage tree of this view. When this tree is loaded, the view node is updated with the Denodo’s information, showing more details of this element.

360 Graph for a view and the more info tooltip

360 Graph for a view and the more info tooltip

Additionally, since the introduction of custom external elements you can obtain more information about the relationship between two elements by clicking on the connecting lines. Then, a tooltip will appear with information about the two elements and the kind of relationship between both. Furthermore, the direction of the relationship arrow indicates the data flow between the two elements.

360 Graph for a view and more info relation tooltip

360 Graph for a view and the more info relation tooltip

Note

You will only see the 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.

  • For a custom external element appear in the diagram, you need to be granted with the Visualize privilege on its external element type configuration.

Add feedback