Share via

Azure Purview : Generate list of schema.table.column for all fields that Purview has marked a Classification on?

Patrick Thibodeaux 1 Reputation point
2022-04-26T14:32:03.027+00:00

We have Azure Purview setup at the client and have ran the first couple of scans and see that Purview has marked some columns with the Classifications of PII data. Do you happen to know the simplest way to produce a list of all the fields that have been Classified (i.e. "generate a list of schema.table.column for which we might script masking or encryption on"? I dug for a while and only saw a few people on Google going through what seems a lot of work of using Synapse with Python calling the Purview REST API and parsing the JSON. Thanks for your help!

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,224 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Manuel Bustamante 47 Reputation points
    2023-02-01T19:48:09.9733333+00:00

    Well, we are in 2023 and use Synapse + Purview REST API is still the only way to do what you are asking for. It's not complicated actually. Search for pyapacheatlas, it's a python library that works like a layer on top of the REST APIs.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.