Technical lineage export types

If you want to share a technical lineage graph of your technical lineage, you can export the information to one of the following export types, via the Settings tab pane:

PDF and PNG

The PDF and PNG exports show only the technical lineage graph of the selected table or column.

Graph CSV

The CSV export option generates a ZIP file with the following CSV file:

File name

File content

current_graph_column_lineage.csv

The technical lineage graph of the selected column or table.

Full Batch CSV

The Full CSV option generates a ZIP file with the following CSV files:

File name

File content

current_graph_column_lineage.csv

The technical lineage graph of the selected column or table.

full_batch_column_lineage.csv

The technical lineage graph of the full technical lineage.

Example

The current_graph_column_lineage CSV file and the full_batch_column_lineage CSV files show the same information, but with a different scope. These CSV files show how data flows from source to target.

The following example shows a typical data flow. If your data sources contain data with more asset types, the CSV files contain more columns. For example, if you create technical lineage for Power BI, the CSV files include all BI asset types.

No

Column

Description

source_system

The name of the source system.

Note This column is only shown when useCollibraSystemName is set to true in the lineage harvester configuration file.

source_database The name of the source database.

source_schema The name of the source schema.

source_table

The name of the source table.

source_column

The name of the source column.

target_system

The name of the target system.

Note This column is only shown when useCollibraSystemName is set to true in the lineage harvester configuration file.

target_database

The name of the target database.

target_schema

The name of the target schema.

target_table

The name of the target table.

target_column

The name of the target column.

procedure_name

The name of the stored procedure. This column remains empty when an object in your technical lineage doesn't have stored procedure.

Warning This column is deprecated and will be removed in the future.

query_name

The name of the specific source code fragment or transformation detail.

You can use this name to search for more information in the Sources tab page.

Tip The names of the source and target objects indicate the full path of the object. For example, the full name of a column is (system) > database > schema > table > column. This path is used to stitch your technical lineage objects to assets in Data Catalog.

JSON Lineage

This export option generates a JSON file that is formatted in the same manner that is required for creating a custom technical lineage.