Lineage

Detailed Query Lineage

• reflects internal query structure and show relations inside queries.
• use "showQueryLineage" option in Input Description JSON to see Detailed Query Lineage in diagram.

Column-to-Column lineage

• strips lineage inside queries and shows only relations between database columns.
• use "databaseImageOptions" : { "showColumnLineage" : true } option in Input Description JSON to see Column-to-Column lineage in diagram.

Relation

Direct

• source: Database column, target: Database column
• direct relation between columns mean, that the value of target column is derived from value of source column.

Indirect relation

• TL;DR indirect relation means filtering and aggregation by the source value.
• source: Database column, target: Database table
• indirect relation from column to table means, that values in target columns are not directly derived from source column value, but their occurence is result of aggregation or filtering by source column value.

Semidirect relation

• TL;DR semidirect is very simlar to indirect relation, but on the left of FROM clause.
• source: Database column, target: Database column
• the same as direct, but the target value is not directly derived from source value. Source value is a part of condition (CASE, IF) or other indirect part of expression.