Can Purview pull SQL Table description into Purview Data catalog.

Question

I recently started using Azure Purview for Data Governance and I have a question.
When a table description is added to a SQL table, can that description be visible from Purview data catalog.

Thanks very much for your help!!

Answer 1

Hello anonymous user-6983,

Thanks for the question and using MS Q&A platform.

Unfortunately, no. Azure Purview do not pull that automatically.

But as a workaround you may try exploring this blog by one of the community volunteers and see if you can take a similar approach. This blog uses pyapacheatlas which lets you work with the Azure Purview and Apache Atlas APIs in a Pythonic way. - Using PyApacheAtlas to import SQL Server extended properties to Azure Purview

In case if you have any feedback or a feature request for the product team, I would recommend you to please share in IDEAS forum here - https://feedback.azure.com/d365community/forum/82d7bddb-fb24-ec11-b6e6-000d3a4f07b8. Please do share the link once the feedback is provided so that we can share it with internal teams for reveiw.

Hope this will help.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators