Bulk updates for column name descriptions

Brass Contributor

Is there another option to update the column name descriptions other than having to go into every object and update description within the tool? Is Purview able to extract this from the metadata in a Azure SQL database and if so how?

 

3 Replies

Hi @ChandruS , do you know if this is currently on the roadmap?

Yes, It is in the roadmap for H2 2021. In the meantime you can use the custom utility to perform bulk operation. https://github.com/wjohnson/pyapacheatlas/wiki/Azure-Purview-Tips
We have the need to tag over 60,000 columns spanning many databases. We are also hoping to see Microsoft provide a solution for this. We have asked them, but the response so far is that it is on the roadmap but no clear answer on time frame yet. Doing it one table at a time will take about 20 years to complete!