5.3.7 Adding Lineage

STSA tracks data lineage, showing how data moves through the organization's systems. Users can visualize how data is transformed and where it is used, helping with data traceability and impact analysis. STSA supports lineage for Database, Dashboard, and Pipelines.

To add a lineage:

1. Login to STSA.
2. In the Workspace Summary, Sandbox tab, select the required workspace.
3. On the bottom, click Data Catalog, click the preview button on the Lineage section.
   The Lineage Screen summary page is displayed.
4. In the Lineage Screen summary, click Add.
5. In the Lineage CSV Upload File screen that opens, browse for the .CSV file created in the earlier step and select this file for upload or drag and drop the file in the Drag and Drop field.
   Download the template and fill in the details such as Type, Entity Name, Additional Attributes, and so on.
6. Click Upload.

   The file is verified and the status of the upload is displayed in the Lineage Screen summary screen.

   If the upload is successful, the uploaded status is displayed as COMPLETED.The details like number of rows created, number of successful uploads, number of failed entries in the excel sheet is displayed along with when the excel sheet was created and by which user.

   To download the lineage, in the Lineage Screen summary screen, click Actions and then click View CSV against the lineage report you want to download

   If there are any errors, the status shows as FAILED and you can download the error report by clicking actions and then select Download Error Report. The excel file is appended with an error column that explains the error for the failure. Fix the errors and reupload the excel sheet.