Skip to content

Column lineage with Xformations

In the DataPilot SaaS UI, you can see model level as well as column level lineage. You can also see the types of changes that occurred during the column lineage traversal e.g. column was unchanged or alias was used

Setups steps needed for the information to show in SaaS UI

View Model Level Lineage

Go to code -> dbt from the left-hand navigation menu and see the available list of dbt Models. You can also search on the top or use provided filters to find the exact model you are looking for.

dbt Models

Click on the "View Details" button and go to the Lineage tab. You can expand the lineage further by clicking on (+) signs on individual blocks.

View Lineage

If you click on the specific model in the lineage view, the lineage graph for only that model will be highlighted, as shown in the image above.

View Column Level Lineage

In order to view column-level lineage, first click on "View Details" button in one of models shown in the lineage view. This will display a list of columns present in the model. Click on the column for which you need to view the lineage.

Column Selection

Once you click on the column, you will see the column lineage view as below:

Lineage SaaS

Code transformations

You can also see how that particular column was created from previous stage columns via transformation information available as icons at each block level. The following type of transformations are shown in this view:

Type Description
Original The original column in the lineage graph
Alias Alias was used on the previous stage columns
Transformation Transformation was used on the previous stage columns
Unchanged No change was made in the previous stage column
Not sure Not known how this column was created

If code is available for a particular transformation, a small code icon is displayed. When you click on the code icon, it shows the list of code transformations that were performed to create that column.

SaaS Code

Recorded Demo

Using this feature requires an API key. You can get it by signing up for free at Also, you need to perform the setup steps outlined on the Setup UI page