Azure Purview
783 Ideas
Vote
Microsoft
4 years ago
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.
Planned
Azure PurviewLineagePlanned
Microsoft
Company Response
2 years agoLineage from stored procedures for the AzureSQL database has been released into public preview and you can find additional information in the following announcement: https://azure.microsoft.com/en-us/blog/introducing-dynamic-lineage-extraction-from-azure-sql-databases-in-azure-purview/
and the Azure Purview documentation: https://docs.microsoft.com/en-us/azure/purview/register-scan-azure-sql-database?tabs=sql-authentication#lineagepreview
On-premises SQL Server is scheduled for later this year