Skip to main content
Workday User Guide
Last Updated: 2024-03-08
View Pipeline Snapshot Comparison

View Pipeline Snapshot Comparison

Any of these security requirements:
  • Prism Datasets: Manage
    domain in the Prism Analytics functional area.
  • Prism Datasets: Owner Manage
    domain in the Prism Analytics functional area.
  • Prism Datasets: Publish
    domain in the Prism Analytics functional area.
  • Dataset Owner
    permission on the dataset.
  • Dataset Editor
    permission on the dataset.
  • Dataset Viewer
    permission on the dataset and the tenant is configured to have the
    Enable Prism Dataset Transformations
    check box enabled.
Have a derived dataset that has been published multiple times.
You can find changes in datasets and tables easily and securely to help you debug any issues encountered during dataset publishes. You can select 2 publish activities of a dataset to compare changes made to its pipeline between snapshots.
A pipeline is a collection of datasets and tables that are upstream from a dataset and comprise the upstream lineage until it reaches base datasets or tables.
Workday displays the
Pipeline Snapshot Comparison
report and highlights all changes made between pipeline snapshots using a color scheme defined in the legend.
  1. Access the
    View Dataset Details
    report. From the
    Data Catalog
    you can:
    • Double-click a dataset.
    • Right-click a dataset, and select
      View
      from the menu.
    • Select a dataset, and select
      View
      from the actions menu on the right side of the selected row.
  2. On the
    Activities
    tab, select 2 publish activities.
    If you want to select a different publish activity to compare, clear one of your selected activities first. You must clear one of your selected activities to select a different activity.
  3. Select
    Compare
    .
  4. Workday opens the
    Pipeline Snapshot Comparison
    report and displays information you have permission on. Workday displays different information depending on the component:
    Component
    Description
    Dataset and Table List
    Workday lists the upstream datasets and tables in the pipeline that impact this dataset.
    The report displays datasets and tables you have at least Dataset Viewer permission on.
    Comparison Window
    Workday:
    • Displays a side-by-side comparison of the stages in the selected dataset or table.
    • Highlights any differences between snapshots.
    Workday displays different information depending on your permissions.
    The window displays the stage information if you have either of these permissions on the dataset selected:
    • Dataset Editor.
    • Dataset Viewer permission, and your tenant is configured to enable the
      Enable Prism Dataset Transformations
      check box.
    The window displays
    View the output fields
    if:
    • You have Dataset Viewer permission, and your tenant is not configured to enable the
      Enable Prism Dataset Transformations
      check box.
    • The dataset imports a dataset or table you don't have Dataset Viewer permission on.
    • You select a table.
    If you see the details for only 1 snapshot, then the dataset or table selected was either added or removed from the pipeline between snapshots.
    Color Legend
    The definition of what each highlighted color represents.
  5. Click the stage in the comparison window to compare the details between activities. You can view the definition, calculated fields, and output fields of the selected stage.