Trying to create a data lineage from a stored procedure

Database
N/A

Trying to create a data lineage from a stored procedure

Hi experts, I have a requirement like creating a data lineage report (at column level) for a bunch of stored procedures. Condition is not to use any third party tools. Is there any Teradata tools which can help us in preparing this ? Expected input : stored proc name / definition , output : which target table/report column is sourced from which column in which table/view?

Any pointer to achieving this would be helpful.

Regards,

2 REPLIES
N/A

Re: Trying to create a data lineage from a stored procedure

Hi Experts, any thought on it? Any response would be appreciated.

N/A

Re: Trying to create a data lineage from a stored procedure

Can you provide a guideline on how to create a dependency report at table level ? For a stored procedure - input could be stored procedure name/definition in text format.

Regards,