Links

Data Lineage in Secoda

After connecting your data to Secoda, you'll be able to get a high level view of your data lineage both at the table and column level.

Everything about Secoda Lineage

Secoda automatically extracts queries to generate data lineage. This can help data teams identify the downstream and upstream dependencies of a table easily.
On each dependency, you will be able to see how many levels away a particular table is.
  1. 1.
    Select the data asset that you'd like to view the lineage of from the Data button in the navigation bar, or, search for it using the search bar.
  2. 2.
    After selecting the asset you'd like to view, click on the Lineage tab. You'll find a visual demonstration of your data lineage here, and can zoom in, out, and select what lineage detail you'd like to view on the right side.
To view the dependencies of a table, click Downstream on the top tabs.
You'll be able to sort the dependencies of that table by source, name, resource type, and schema by typing the name of what you'd like to sort by. You can navigate through the lineage using either the graph or the downstream / upstream tabs. The list view may be easier to use when navigating large graphs which show lots of connected data.
Secoda also captures column lineage to show dependencies across your columns. To flip to the column lineage, just click on the "lineage detail" on the right hand side.

How is Lineage Created?

When you connect a data source to Secoda, Lineage is automatically generated from SQL queries, such as:
  • CREATE_TABLE_AS_SELECT
  • CREATE_VIEW
  • MERGE
  • JOIN
To make it even easier to navigate lineage for tables or dashboards with many fields, you can search within a table or dashboard.
First click the item you want to search so the magnifying glass icon appears, then type your search to narrow the results.
Not using Secoda to manage your data knowledge yet? Sign up for free here 👈