Lineage Presentation Examples

Stored Procedures

Database models may include stored procedures that move data either within a database or from / to external databases (which also requires connections to be stitched).

In this case, we have a stored procedure reading from the PaymentStatus and writing a note to the CustomerName if PaymentAmount is a negative amount.

We can see this when tracing the lineage from CustomerName in Staging DW.MITI-Finance-Staging-DW.dbo.Customer:

Click the Show Lineage Details icon to the right of the name of the stored procedure:

You may also go to the Overview tab to see the details about the stored procedure itself.

Script Based DI Models

For this scenario, please see the pySpark Databricks Notebook example.