Data Lineage
You can use Lineage tab to...
  • Understand how different parts of your data interact
  • ​Evaluate impact of changes to upstream or downstream data sources
  • Filter your data lineage by Data Type, Search Term, and by Excluding your Search Term
Watch this video for detailed information on using the lineage feature, or continue reading for an overview.

Lineage

Data Lineage is designed to indicate where the data is coming from, so you can find dependencies of each table, column, or dashboard.
When you connect a data source to Select Star, Lineage is automatically generated from ETL SQL queries, such as:
  • CREATE_TABLE_AS_SELECT
  • CREATE_VIEW
  • MERGE
Click on the Lineage tab from a table page to see how it connects to your other tables and dashboards.
The lineage modal opens with a graph of the Upstream Sources and Downstream Targets of the data asset you're looking at. There is also a sidebar on the left side of the page which shows the same information as a directory tree.
You can navigate through the lineage using either the graph or the sidebar. The sidebar may be easier to use when navigating large graphs which show lots of connected data.
​
πŸ“Š
Make sure Dashboards is checked at the bottom of the lineage graph if you want to see downstream dashboards or reports.
​
🧩
Want to keep track of all the tables you've clicked on? Check Auto-close unrelated assets is checked by default to keep your lineage loading quickly. If you'd like to keep everything you've clicked on open on the graph, uncheck this option.
If in doubt, hover over any of the icons in the graph to show what will happen if you click on them.
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.

Filtering Data Lineage

If you need to thin down results, use some of our filtering features on your upstream or downstream lineage:
  • Filter by:
    • Data Type
    • Search Term
    • Exclude Search Term
Note that you can layer the Data Type and Search Term/Exclude Search Term, but Search Term and Exclude Search Term are not able to be layered/applied simultaneously.
Open your πŸ” Filtering Options to get started:
From there, you can Search by Term:
Search by Term and Filter by Data Type:
And Exclude Search Term: