Skip to main content

​
Column-Level Lineage

Column-level lineage lets you trace individual fields — not just tables — as they move through your data pipelines. Use it to understand exactly where a column comes from, how it’s transformed, and what depends on it. Column-Level Data Lineage in Collate
Tip: Drill down into any table node to see its individual columns and their lineage connections.
Collate generates column-level lineage automatically when you run the Lineage Agent. You can also edit it manually to capture any relationships that aren’t automatically detected.

​
Manually Edit Column-Level Lineage

Edit column-level lineage directly in the Collate UI. No ingestion is required. To link columns by hand:
  1. Open the table and select the Lineage tab.
  2. Click Edit (the pencil icon) in the lineage toolbar. The asset panel opens next to the graph. Edit icon in the lineage toolbar
  3. If the table that holds the column you want to trace is not in the graph, add it first:
    • In the asset panel, choose the asset type, such as Tables.
    • Search for the table and add it to the graph.
    Asset panel in lineage edit mode listing Tables, Dashboards, Charts, Stored Procedures, Topics, and ML Models
  4. Find the column in the source table. Each column has an anchor point on its edge.
  5. Drag from the anchor point of the source column to the anchor point of the column it feeds in the other table.
  6. Repeat for each column you want to link.
  7. Optional: To remove a link, select the x icon on the connecting line.
  8. Save your changes.
Manually Edit Column Level Lineage Watch the video below to see column-level lineage editing in action.

​
Metric Column Lineage

A metric is often calculated from a single column. Link the column to the metric so the lineage shows exactly which field feeds the metric. For example, link sales.amount to the metric Total Sales.
  • Direction: Connect a column to a metric (column feeds the metric), or a metric to a column.
  • Endpoint: A metric has no columns of its own. In column-level lineage, the metric appears as one connection point that carries the metric’s own name.
  • Visibility: The connection point appears on a metric node at the Field-level Lineage level or in edit mode. In the default view, a metric node shows no connection point.
  • Impact Analysis: The column-to-metric link also appears in the column-level Impact Analysis view, so you can see which metrics depend on a column before you change it.
Before you start, make sure you can edit the metric and the table that holds the column.
  1. Open the metric and select the Lineage tab.
  2. Select Edit (the pencil icon) in the lineage toolbar.
  3. If the table that holds the column is not in the graph, add it from the asset panel. For more information, see Manually Edit Column-Level Lineage.
  4. Select the Layers button and, under Level, select Field-level Lineage so the table’s columns are listed.
  5. Drag from the anchor point beside the column to the anchor point on the metric.
  6. Save your changes.
To remove the link, select the x icon on the connecting line in edit mode.
You can also create these links with the API by adding a columnsLineage entry whose toColumn is the metric’s fully qualified name.

How to Manually Add or Edit Lineage

Edit the table and column level lineage manually.