Reporting data lineage and business lineage
You can create reports that analyze the flow of data from
data sources, through jobs and stages, and into databases, data files,
business intelligence reports, and other assets. In addition, you
can create a business lineage report that displays only the flow of
data, without the details of a full data lineage report.
Assets that are included in lineage reports
Jobs and mapping specifications are excluded from lineage by default. Assets of all other types are included for lineage by default. When you include or exclude an asset type for a report, the child assets of that asset type are also included in or excluded from the report. In addition, virtual assets are also displayed in a lineage report. A virtual asset is an asset that was not imported or created in the catalog, but it is accessed by a job.
Data lineage and business lineage reports
Data lineage reports show the movement of data through a job or multiple jobs. These reports can show the order of activities within a run of a job. Business lineage reports show a simplified view of lineage that highlights the transformation and aggregation of data that is needed by a business user. Business lineage reports do not show jobs and mapping specification asset types.
Running data lineage and business lineage reports
You can run lineage reports that combine information from job designs, operational metadata, and user-defined relationships between assets. You can also include dependencies that are not related to data flow, such as job sequencing, for impact analysis. You can see the flow of data through specific child assets, for example, the flow of data through selected database columns of a database table. You can hide assets, or assets and their flows, from the report.