This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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!
Hello @Patrick Thibodeaux ,
Thanks for the question and using MS Q&A platform.
We are reaching out to internal team to get more information related to your query and will get back to you as soon as we have an update.
Any updates? :)
Hello @Patrick Thibodeaux ,
We are still awaiting for the response from the internal team and will get back to you as soon as we have an update.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 31%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Was this ever answered?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 22%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Please - any update?
In case anyone else is stuck on this, this article seems the lead the way...
Thanks to Danaraj Ram Kumar
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 44%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
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.