Dynamic SQL Lineage in Microsoft Purview
Microsoft Purview is an essential service in the Azure cloud that enables organizations to scan, classify, and govern their data assets. As the service continues to evolve, it offers even more valuable tools to users. One question that frequently arises among Purview users is related to data lineage, which is the process of tracking and documenting the origin and movement of data within an organization.
In this article, we will examine dynamic SQL lineage in Microsoft Purview, which involves querying the metadata of a SQL Server query to build the data lineage. This process can be automated by using T-SQL queries and SQL Server Integration Services (SSIS) packages that leverage Purview APIs. By leveraging dynamic SQL lineage, organizations can gain a comprehensive understanding of their data architecture, thereby enabling them to make informed decisions regarding their data.
Overall, this article is an insightful guide to dynamic SQL lineage in Microsoft Purview that will be useful to data professionals looking to gain greater visibility into their organization's data flow.
The post Dynamic SQL Lineage in Microsoft Purview originally appeared on SeeQuality.
Published on:
Learn moreRelated posts
Microsoft Purview compliance portal: Purview Activity Explorer – Limiting sensitive data access to “Data Classification Content Viewer” role
This post talks about the recent update to the Microsoft Purview compliance portal, specifically with regards to the Purview Activity Explorer...
Mastering Microsoft Purview Workflow: Revolutionize Your Data Governance
If you're struggling to manage your ever-growing data landscapes while ensuring compliance, quality, and collaboration, then Microsoft Purview...
Incrementally loading files from SharePoint to Azure Data Lake using Data Factory
If you're looking to enhance your data platform with useful information stored in files like Excel, MS Access, and CSV that are usually kept i...
Azure Data Transfer authorized for Azure Government Secret and generally available for critical mission data types
Azure Data Transfer has secured an important provisional authorization from the Department of Defense (DoD) Impact Level 6 (IL6). This enables...
Data API builder for Azure SQL Databases – Public Preview
Good news for developers using Azure SQL Databases! The public preview of Data API builder is here to make developers more efficient and effec...
Exploring Microsoft Purview for data governance
In this video, Buck Woody and Patrick delved into the benefits of using Microsoft Purview for data governance. Microsoft Purview is a powerful...
Episode 416 - Azure Purview
In this episode, Amber Zhao and Karen Ekberg from the Azure FastTrack team take a deep dive into Azure Purview and how it helps customers mana...
Where is your Data? - A need for Data governance platform
The advent of digital transformation and app modernization programs has led to the generation, movement, collection, and storage of data in th...
Where is your Data? - A need for Data governance platform
In today's world, digital transformation and app modernization has given rise to new applications developed in the cloud, and legacy apps shif...