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

Sakshi Gupta 21 Reputation points
2021-07-17T21:30:50.233+00:00

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.

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,028 questions
Accepted answer
  1. KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee
    2021-07-19T23:14:57.303+00:00

    Hi @Sakshi Gupta ,

    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.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest