Extracting the metadata from Purview in Json file using Purview CLI

Maria Diana 45 Reputation points

I have successfully scanned few data sources in Purview UI. I would like to extract the metadata from purview in Json format so I can store the Json files in Jupyter 1.

So there are two things here, First one will be extracting the metadata from Purview. How can I do this. Is there any clear documentation somewhere? I have gone through some documentation and found that we can use purview cli to do it But I am not able access purview commands (pv commands) after installing purview cli through powershell. Powershell is not recognizing the pv commands (error “The term 'pv' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again”). 

Can you please help me to understand how can I extract the metadata using purview cli in json format so that it can be moved to Jupyter 1?

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.
762 questions
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 45,887 Reputation points Microsoft Employee

    @Maria Diana Thanks for the additional details.

    All of the tayganr/purviewcli: Microsoft Purview CLI (github.com) are NOT powershell, it is its own shell command.

    Video: Could you please try Visual Studio Code instead of Powershell as demonstrated in this video: CLI wrapper to Microsoft Purview APIs (purviewcli)

    You should just call pv entity read --guid 'abc-123' and it will pull the content down in json.

    If you would like to explore Powershell cmdlet, it's a different pacakge: Azure/Azure-Purview-API-PowerShell (github.com)

    Hope this info helps. Let us know how it goes.

    Thank you

    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Ravineesh 20 Reputation points

    @Maria Diana , Have you tried running the command pv search query ? I think you can get the data for collection level by using pv search query

    Also have a look at this https://github.com/mdrakiburrahman/purview-collection-aggregator/blob/main/explore.ipynb it might be useful

    0 comments No comments