@Ravineesh - Thanks for the question and using MS Q&A platform.
- The issue in the example provided in the previous email is due to the GUID or the schema being passed (which has no classification).
- To fix the issue, pass the GUID of the column (that is the entity which has the classification applied to it).
How to get the GUID of a column using Developer Tools
- Find the table (e.g. Customer Azure SQL Table)
- Click Schema
- Open “Developer Tools” in your browser (e.g. press F12 on your keyboard)
- Switch to the Network tab__.__
- Filter the network requests by clicking on the Fetch/XHR pill.
- Click on the column that has the classification applied (e.g. EmailAddress). Note: By doing so, this will fire off several network requests which we will filter down in the next step.
- Filter the network requests by typing “bulk” in the search box.
- Click on the bulk?exc… network requests to reveal it’s details.
- Switch to the Preview tab to see the formatted response.
- If you expand the JSON (entities.guid), you should find the GUID of the column.
- If you expand the JSON (entities.classifications.typeName), you should find the name of the classification.
Example of successfully removing the classification with the correct GUID/classification combination.
pv entity deleteClassification --guid GUID_OF_COLUMN --classificationName NAME_OF_CLASSIFICATION
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click
Accept Answer and
Yes for was this answer helpful. And, if you have any further query do let us know.