Amazon Redshift Sources > View results in Data Governance and Catalog > View data lineage
  

View data lineage

Data lineage is a visual representation of the flow of data across the systems in your organization. Lineage depicts how the data flows from the system of its origin to the system of its destination.
Data lineage views are available for technical assets in the catalog source. You can view lineage at the catalog source, data set, or data element level.
The lineage at the catalog source level shows how data flows from one catalog source to another. The lineage at the data set and the data element levels show how other technical assets such as files or tables contribute to the selected asset.
If linking catalog sources is available for your catalog source, you can use Metadata Command Center to generate data lineage based on rules or by generating automated lineage with CLAIRE. You can choose source and target catalog sources and objects to link and generate lineage.
To determine whether linking catalog sources is available for your catalog source, navigate to the Configuration tab of the Link Catalog Sources page. The catalog source must appear in the list of source and target catalog sources.
For information about linking catalog sources, see Link catalog sources.

View lineage at the catalog source level

The catalog source level shows how data flows from one catalog source to another with the lineage aggregating data from the data set and data element levels.
To view data lineage at the catalog source level, open a technical asset, click the Lineage tab, and then verify that the level is set to Catalog Source Level.

View lineage at the data set level

The data set level displays individual sets of data in the data flow.
To view lineage at the data set level, open a technical asset, click the Lineage tab, and then verify that the level is set to Data Set Level.
The following image shows data set level lineage where the order_details_view target reference data set gets data from the order_items, orders, products, and users source reference data sets using the order_details_view model instance before connection assignment:
The source lineage diagram starts at the order_items, orders, products, and users reference data sets and shows how the data flows to the target order_details_view reference data set before connection assignment.
The following image shows data set level lineage where the order_details_view target view gets data from the order_items, orders, products, and users source tables using the order_details_view model instance after connection assignment:
The source lineage diagram starts at the order_items, orders, products, and users source tables and shows how the data flows to the target order_details_view view after connection assignment.
After connection assignment, the referenced object icons change to specific object icons.

View lineage at the data element level

The data element level displays details of the data set level. At the data element level, you can see the input sources for expressions or commands and calculations or transformations on the data.
To view data lineage at the data element level, open a technical asset, click the Lineage tab, and then verify that the level is set to Data Element Level.
The following image shows data element level lineage where the username reference data element of the order_details_view reference data set gets data from the username reference data element of the users reference data set using the username calculation of the order_details_view model instance before connection assignment:
The data element level lineage diagram starts at the username reference data element of the users reference data set and provides output to the username reference data element of the order_details_view reference data set using the username calculation of the order_details_view model instance before connection assignment.
The following image shows data element level lineage where the username view column of the order_details_view view gets data from the username column of the users table using the username calculation of the order_details_view model instance after connection assignment:
The data element level lineage diagram starts at the username column of the users table and provides output to the username view column of the order_details_view view using the username calculation of the order_details_view model instance after connection assignment.
After connection assignment, the referenced object icons change to specific object icons.