View Table and Dataset Lineage
- Any of these security requirements for dataset lineage:
- Prism Datasets: Managedomain in the Prism Analytics functional area.
- Prism Datasets: Owner Managedomain in the Prism Analytics functional area.
- Prism Datasets: Publishdomain in the Prism Analytics functional area.
- Dataset Viewerpermission on the dataset.
- Dataset Editorpermission on the dataset.
- Dataset Ownerpermission on the dataset.
- Any of these security requirements for table lineage:
- Prism: Tables Managedomain in the Prism Analytics functional area.
- Prism: Tables Owner Managedomain in the Prism Analytics functional area.
- Prism Datasets: Publishdomain in the Prism Analytics functional area.
- Table Viewerpermission on the table.
- Table Editorpermission on the table.
- Table Ownerpermission on the table.
When you bring in data and transform it in Prism Analytics, you can create complex workflows containing multiple tables and datasets. You create a derived dataset by importing a table or dataset on which the derived dataset is based. The derived dataset depends on the table or dataset you import into it. You can visually see these dependencies by viewing the lineage for a table or dataset.
Viewing the lineage enables you to see dependencies, and to trace the origin of a derived dataset back to its tables and base datasets. The lineage gives you insight into the potential consequences of changes you make to your data (impact analysis).
If you're new to Workday, you don't have access to create or edit base datasets.
- Access theData Catalogreport.
- Right-click a table or dataset whose lineage you want to view, and selectView Lineage.On theView Table LineageorView Dataset Lineagereport, the graph displays dependencies in both directions from the selected object where applicable:
- Upstream and downstream dependencies. When you view the lineage of a derived dataset, the graph displays the datasets imported into the derived dataset, and any other derived datasets that import this derived dataset. Similarly, when you view the lineage of a table, we display the upstream datasets brought into a table through a data change task.
- Downstream dependencies only. When you view the lineage of a table or base dataset, the graph displays any derived datasets that import this table or base dataset.