question

SakshiGupta-5276 avatar image
0 Votes"
SakshiGupta-5276 asked KranthiPakala-MSFT answered

Steps to Download schema description and lineage map from Azure Purview and ways to scan stored procedures and functions

Hello Team,

I am a newbie to Azure Purview and need to implement it for some of the projects. While analyzing the pros and cons, I found the following:

  • From the SQL server, we can only document tables and views. There is no way to document existing stored procedures, functions (table-valued, scalar functions). Can anyone suggest otherwise?

  • I am unable to see the overall database schema at a single glance. Can we see the database diagram in Azure Purview i.e. tables relationship?

  • Is there a way to download schema, tables, data map, lineage map, classifications, etc from Azure Purview in Excel/CSV/PDF?


Hoping to get the answers to my queries stated above.





azure-purview
· 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.

Hi @sakshigupta-5276,

Welcome to Microsoft Q&A forum and thanks for your query.
We are reaching out to internal team to get additional info regarding your query and will get back to you as soon as we have an update.

Thank you for your patience.

0 Votes 0 ·

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered

Hi @sakshigupta-5276,

As per my conversation with internal team, below are updates regarding your queries.

  • From the SQL server, we can only document tables and views. There is no way to document existing stored procedures, functions (table-valued, scalar functions). Can anyone suggest otherwise?

    Currently not possible. This is in the roadmap but we do not have an ETA at the moment.

  • I am unable to see the overall database schema at a single glance. Can we see the database diagram in Azure Purview i.e. tables relationship?*

    Unfortunately it is not possible. I would recommend you to please up-vote and/or comment on an existing similar feedback: Relationships/Diagram view

  • Is there a way to download schema, tables, data map, lineage map, classifications, etc from Azure Purview in Excel/CSV/PDF?

    Currently not possible. This is in the roadmap but we do not have an ETA at the moment.

  • I would also recommend you to please subscribe to Azure updates page to know about the latest feature announcements and updates regarding Azure products


    Hope this info helps.



    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


    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.