Exporting Lineage to CSV

Bigeye lineage exports come in two files that work together: a nodes file, which contains every asset in your lineage graph, and an edges file, which contains the connections between the assets in your lineage graph. Use the nodes export to export a list of "what exists" and the edges export for a list of "how it flows."

Why Export Nodes, Edges, or Both

Export nodes for an asset inventory, to audit reports, to catalog what exists across sources, and perform coverage checks. It tells you what exists, not how assets are connected.

Export edges when performing impact and root-cause analysis (what feeds a dashboard, what breaks if a table changes), tracing end-to-end flow across warehouses, BI, and ETL tools, and loading lineage into an external graph or BI tool since each row already has both endpoints.

Nodes Export Details

In the nodes export, there will be one row per asset. Below is the data model for each row.

Column NameDescription
IDThe asset's unique ID in Bigeye.
typeWhat kind of asset it is - a schema, table, or column in a warehouse, or a BI/ETL object like a Looker dashboard or a PowerCenter load target.
nameThe asset's display name.
sourceTypeThe kind of system it comes from (e.g. Snowflake, Oracle, Looker, PowerCenter).
sourceNameThe name of the specific connected source. Warehouse assets show a source name; BI/ETL objects often leave this blank.
schemaNameThe schema and table the asset lives in. Populated for warehouse tables/columns; blank for BI/ETL objects that aren't table- or column-level.
pathThe full location, with levels joined by " > ". This is your cleanest field for uniquely identifying an asset.
originatingSrcThe originating source of the data, when captured via the “Originating Source” attribute.
transformExprAny transformation expression applied, when captured via any of the following keys: "Transformation Expression", "Transform Expression", "Sql Transform Expression", or "SQL Transform Expression"

Custom attributes: If your workspace has configured extra catalog attributes, they appear as additional columns after the transformExpr column. Custom attributes can only be added when enabled by Bigeye.

Edges Export Details

In the nodes export, there will be one row per connection, carrying the full details of both ends side by side: an "upstream" set of columns followed by the identical "downstream" set. Any configured extra attributes appear as paired "upstream " and "downstream " columns.

Read a row as "upstream feeds downstream," so this file is what you use for impact analysis, root-cause tracing, and mapping end-to-end data flow across your warehouses, BI, and ETL tools.

Below is the data model for each row.

Column NameDescription
upstreamIdThe source asset's unique ID in Bigeye.
upstreamTypeThe kind of asset it is: a schema, table, or column in a warehouse, or a BI/ETL object like a Looker dashboard or a PowerCenter load target.
upstreamNameThe source asset's display name.
upstreamSourceTypeThe system associated with the asset (e.g. Snowflake, Oracle, Looker, PowerCenter).
upstreamSourceNameThe name of the specific connected source name that shows in the Bigeye catalog.
upstreamSchemaNameThe schema the asset lives in. Populated for warehouse tables/columns; blank for BI/ETL objects that aren't table- or column-level.
upstreamTableNameThe table the asset lives in. Populated for warehouse columns; blank for BI/ETL objects that aren't table- or column-level.
upstreamPathThe full location, with levels joined by " > ". This is your cleanest field for uniquely identifying an asset.
upstreamOriginatingSrcThe originating source of the data, when captured via the “Originating Source” attribute
upstreamTransformExprAny transformation expression applied, when captured via any of the following keys: "Transformation Expression", "Transform Expression", "Sql Transform Expression", or "SQL Transform Expression".
downstreamIdThe source asset's unique ID in Bigeye.
downstreamTypeThe kind of asset it is: a schema, table, or column in a warehouse, or a BI/ETL object like a Looker dashboard or a PowerCenter load target.
downstreamNameThe source asset's display name.
downstreamSourceTypeThe system associated with the asset (e.g. Snowflake, Oracle, Looker, PowerCenter).
downstreamSourceNameThe name of the specific connected source. Warehouse assets show a source name; BI/ETL objects often leave this blank.
downstreamSchemaNameThe schema the asset lives in. Populated for warehouse tables/columns; blank for BI/ETL objects that aren't table- or column-level.
downstreamTableNameThe table the asset lives in. Populated for warehouse columns; blank for BI/ETL objects that aren't table- or column-level.
downstreamPathThe full location, with levels joined by " > ". This is your cleanest field for uniquely identifying an asset.
downstreamOriginatingSrcThe originating source of the data, when captured via the “Originating Source” attribute
downstreamTransformExprAny transformation expression applied, when captured via any of the following keys: "Transformation Expression", "Transform Expression", "Sql Transform Expression", or "SQL Transform Expression".

Custom attributes: If your workspace has configured extra catalog attributes, each one adds two columns - an "upstream " and a "downstream " - appended after the built-in columns (upstream ones first, then downstream). Custom attributes can only be added when enabled by Bigeye.



Did this page help you?