Arrow to bar

Symbols like ⇤ and ⇥ are used when data lineage cannot be displayed in a full length. This happens for three reasons:

  1. the user adjusted Graph depth and thus restricted maximum graph size
  2. the graph size was too large and depth was auto-adjusted to avoid overloading the web-browser.

In such cases a special symbol is displayed to alert the user about a partial data lineage. Based on the lineage direction left handed or right handed arrow appears. 

Tip: To overcome problem with an oversized graph we recommend browsing the lineage on a column level.

Double arrows

When option Show only ending points is enabled some tables might be hidden. In that case double arrow is displayed. See full explanation in this help article

Exclamation mark

A triangle with an exclamation mark is displayed when table exist in a SQL statement which failed to be processed by SQL parser.

It gives you a chance to notice something might be wrong with your lineage.

Example

1st query (valid syntax)

create table public.tmp
as select acc_id
from dwh.accounts;

2nd query (it contains invalid SQL syntax):

update table public.tmp as set; 

Visualisation

Table TMP exists in 2 statements although only the first statements is valid and thus it got visualised.

As a next step we have detected that table TMP exists in a failed query. Thus we display the exclamation mark next to table TMP to alert you about it.

Right-click on exclamation mark to open a pop-up menu:

By selecting the option Show failed SQLs all such SQL queries will be listed at bottom of the screen. You can now investigate what went wrong.

Did this answer your question?