Lineage

What is it ?

Where does data come from ? Does a dashboard which uses this data exist ?

Lineage answers many questions! Amongst them:

• I've found an interesting dashboard, but I want to make sure it uses the right source of data ?

• I know a table has the information that I need. Does a dashboard already provide analysis for it ?

Asset level vs field level

When we talk about asset level lineage, we want to understand how tables, dashboards and BI tool models are linked to one another.

We sometimes have very specific question and would like to drill down. This is when field level lineage comes in super handy ! You can understand data flows at column level.

Sources

Ever wondered which tables are the ancestors of a table or dashboard?

Well that's easy now, Sources travels up the lineage to the first ancestral elements.

Parents / Children

Find out which tables and dashboards are directly related to your tables upstream and downstream.

By clicking the "Export Children" button, you can also export and download all lineage children in a CSV file.

Lineage Graph

Lineage graphs are not only nice to look at, they are also super useful!

In Catalog, we want you to focus on the most useful use cases and make graphs as clear as possible.

📈 You start small, then expand to get the information you need.

Going downstream

You need to make a modification to a table and need to check the impact?

Or simply check where a tables is used?

👉 By clicking "+" on the right of any table in the graph lineage, you will discover assets created from the selected one

Going upstream

You need to troubleshoot a problem in a table? Checking were the data comes from is always a good idea.

👉 Deep dive in the origins of the data by clicking on the "+" on the left of a table

Dashboards <> Tables

Dashboards and Tables come from different technologies. Understanding the link between them is not straightforward.

🦸 Catalog can help for that!

Full links between tables and dashboards can be established with Graph lineage:

Lineage Graph Refresh

Every time your data is synchronized into Catalog, the lineage is refreshed. The lineage graph displayed in Catalog computes your data from the last 30 days.

🤔 Still seeing some old links in your graph? Try updating the timeframe as below, so you can see your lineage computed on less than 30 days and see your recent SQL changes impacts!