Skip to main content

Column Lineage

Take a look at our short video on column lineage or keep reading for more.

Column Lineage Walkthrough

Coalesce includes a way to quickly view the lineage of each column as it is transformed throughout your nodes. We'll be using the following Node Graph in examples.

Sample DAG

To view Column Lineage, take the following steps:

  1. Open a node.
  2. Right-click on any populated column and select View Column Lineage.
  3. You'll now be in a new tab with the current Node highlighted in blue.
Click on a populated column to view Column Lineage

From here you can select different columns of the selected node and it's lineage will be highlighted across the relevant Nodes. If you'd like to see lineage for columns in other Nodes, you can click ⋮ and then View Lineage on the others like in the following screenshot.

Viewing the lineage on different nodes

Column Propagation

Each individual column can have its addition and deletion to other nodes propagated as well by clicking on the three dots next to a the column name and selecting the relevant option.

Image showing the column lineage