Scanning/Lineage of stored procedures in SQL Server and Azure SQL
We use stored procedures to transform our data. So we are not able to see these steps in the lineage visualization. Although it might be tough to analize all possible ways of transformations included in a stored procedure it would be great to get the information extracted. I think there will be a lot of customers who use stored prcedures who would benefit from it.
Trenton Tamura commented
Yes, we use lots of Stored Procedures to perform data movements. The ability to Scan stored procedures would be awesome and identify what tables are being touched. Even the ability to manually assign stored procedures in the data lineage flow would be a good starting point
I agree with Christopher's comments that using procs to transform data is a very common practice and deciphering transformations would be very challenging. But a starting point would be just identifying what stored procedures update a column. So if the proc has an insert statement or update that references the column it is shown in the data lineage.