How to ingest a csv file with only metadata into Purview

Chandraprakash 5 Reputation points
2023-07-16T14:24:27.7466667+00:00

If i have a csv file with only db, schema, table, column information and would like to scan this csv file in purview is it possible?

If anyone has tried it could you please provide the steps.

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,380 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 34,011 Reputation points Microsoft Employee
    2023-07-17T08:41:26.1333333+00:00

    Hi Chandraprakash ,

    Welcome to Microsoft Q&A platform and thanks for posting your query here.

    As per my understanding, you are trying to know if it is possible to scan a CSV file with only database, schema, table, and column information in Purview. Kindly let me know if that is not the case.

    You can ingest the csv file with metadata but you need to define custom type and push metadata to Azure purview. Please refer to the below documents on Azure Purview REST API's usage and using excel based utility to upload custom metadata and lineage to Azure Purview.

    Rest API document
    Video showing how to use the APIs-
    Excel based utility to report custom metadata & lineage

    Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.