Skip to main content

Column Lineage and Propagation

Coalesce includes a way to quickly view the lineage of each column as it is transformed throughout your Nodes.

Screenshot of the Coalesce DAG Exploration interface showing a focused data flow graph. The left panel lists available data store and aggregate nodes. The main workspace displays a linear and branching sequence of connected tables, representing data lineage from source to derived views. Each node box includes column counts and joins to multiple downstream nodes. The bottom bar shows branch, commit time, user, and Snowflake account details.

View Column Lineage​

To view Column Lineage:

  1. Either open a Node or change to Column Grid view.

  2. Right-click on any populated column and select View Column Lineage.

    alt text
    Mapping Grid
    alt text
    Column Grid

  3. A new tab with the column lineage will open.

Explore Column Lineage​

Screenshot of a data lineage graph in Coalesce’s DAG Exploration view. The central node, labeled “DS_FNR_FORECAST_LATEST,” is selected, displaying its column list and a small context menu with “Edit” and “View Lineage” options. Connected nodes appear to the left and right, showing the data flow between tables. The interface header includes open tabs and navigation options for related views.
  • Column lineage shows automatically opens with all Nodes collapsed to save on space. You can expand the Nodes one at a time.
  • The t next to the column name indicates that a transformation has been applied.
  • Click the : to edit and View Lineage.
info

When viewing column propagation, the view changes to All, so all Nodes with that column can be shown.

Column Propagation​

You can propagate column changes across nodes across Nodes with a few clicks. 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.

  1. Open the Node with the changes you want to propagate.

  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.

  4. To propagate column changes click ⋮ and then select Propagate Addition or Propagate Deletion.

    Screenshot of the Coalesce DAG Exploration interface showing a segment of a data lineage graph. The main view highlights connected nodes labeled with table names such as “VW_FNR_FORECAST,” “VW_FCT_FNR_FORECAST,” and “FCT_FNR_FORECAST.” A context menu is open beside one node, offering options “Propagate Addition” and “Propagate Deletion.” The left panel lists available data store nodes and column metadata, while the bottom bar displays user, branch, and Snowflake account information.

  5. You'll then be able to select the Node you want to propagate the changes to, preview, and apply the changes.

Screenshot of the Coalesce DAG Exploration interface showing the “Preview Propagation Deletions” mode. The main view displays a connected lineage graph of nodes representing tables, with blue lines showing data dependencies. A blue header bar at the top provides instructions: “Select checkboxes next to downstream columns, then click Apply to delete them,” along with “Cancel” and “Apply” buttons. The left panel lists data store nodes and column metadata, and the bottom bar shows user, branch, and Snowflake account details.