question

JanakaHewavitharana-6277 avatar image
0 Votes"
JanakaHewavitharana-6277 asked MedhaBhatt-7066 edited

Purview relational database table relations

Does Azure Purview show table relationships(references) for captured SQL Server tables? The related tab shows all tables in the schema!
Thanks

azure-purview
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered MedhaBhatt-7066 edited

@JanakaHewavitharana-6277 Thanks for using Microsoft Q&A !!

Unfortunately, you cannot visualize the table/schema relationships in Azure Purview. There is already a feedback available in Uservoice which you can upvote so that products team can review and plan in future releases. I will also provide your feedback internally to products team. Can you also provide details of your scenario why you are looking for relationship visualization ?


Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@SaurabhSharma-msft, @PRADEEPCHEEKATLA-MSFT when is this feature going to be available in Purview? This was available in Data Catalog and if Microsoft claims that Purview is an advanced version of Data Catalog, shouldn't it at least retain those existing features?
We have a strong need for this and would like to know if there is any alternate way through API etc. that I can leverage?

Thanks.

0 Votes 0 ·
JanakaHewavitharana-6277 avatar image
0 Votes"
JanakaHewavitharana-6277 answered SaurabhSharma-msft commented

Thanks Sharma for your reply.
Understanding the table relationship helps our developers when writing queries and also gives a view of table table relationships etc. You had this functionality in the Data Catalog.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@JanakaHewavitharana-6277 Thanks, I will provide your feedback internally to products team as well.

0 Votes 0 ·