Upload Metadata to Pureview from files like excel

Pedro Gutierrez 1

How to upload metadata in excel files to purview?

1 answer

PRADEEPCHEEKATLA-MSFT 83,966 Reputation points Microsoft Employee

2021-05-31T12:10:31.187+00:00

Hello @Pedro Gutierrez ,

Welcome to the Microsoft Q&A platform.

UPADTE (2/6/2021):

Unfortunately, you cannot upload Metadata to Azure Purview from files like excel.

Make sure the data is available in the Azure Purview supported data sources.

-------------------------------

May I know, where does the metadata excel files are located?

Azure Purview supports metadata extraction from the supported data sources shown below.

For more details, refer to Supported data sources and file types in Azure Purview.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.
Please sign in to rate this answer.
Pedro Gutierrez 1 Reputation point

2021-06-01T19:27:46.92+00:00

Pradeep,

Thanks for your answer. We have a problem that we don't have access to the databases then we won't be able to explore the data dictionary to feed PurView. Then, we will need to ask the DBA's to dump the data dictionary in a csv or excel file that will contain the name of the tables and columns and the type of the columns; then we want to upload all the excel files into PurView. The location of the csv or excel files with the metadata could be stored in any reachable directory. The structure of all the csv or excel files will be like DBName, Table_name, Column_name, Column_type. Is this feasible? How?

Best Regards,

Pedro E. Gutierrez

PRADEEPCHEEKATLA-MSFT 83,966 Reputation points Microsoft Employee

2021-06-02T07:57:44.31+00:00

Hello @Pedro Gutierrez ,

Thanks for the details.

Unfortunately, you cannot upload Metadata to Azure Purview from files like excel.

Make sure the data is available in the Azure Purview supported data sources.

Hope this helps. Do let us know if you any further queries.

-----------------------------

Please Accept the answer if the information helped you. This will help us and others in the community as well.

PRADEEPCHEEKATLA-MSFT 83,966 Reputation points Microsoft Employee

2021-06-04T09:41:59.797+00:00

Hello @Pedro Gutierrez ,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

PRADEEPCHEEKATLA-MSFT 83,966 Reputation points Microsoft Employee

2021-06-07T10:27:56.677+00:00

Hello @Pedro Gutierrez ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Sign in to comment

Share via

Upload Metadata to Pureview from files like excel

1 answer