ADF Copy Dataverse tables to csv - generate table column metadata

Question

I need to export few tables from Dataverse-Oracle. For this, I plan to run ADF copy data for each Dataverse table to csv(in blob storage), another team import to Oracle since no connection between the source-destination databases.
Requirement is to generate source table metadata, to make it simple for team importing data to create tables on destination database). Is there a way to generate source table metadata from ADF? Or I can only script table metadata from Dataverse? Or there is another functionality in ADF (eg: using data flow instead of copy data) that will allow to script source table metadata?

Thank you for your input!!

Answer 1

Hi @HSever ,

Thank you for posting query in Microsoft Q&A Platform.

If you I understand you query better, then you are trying to look for a way to get dataverse table metadata. If correct me if I am wrong.

Usually GetMetadata activity helps to get get Meta data information. But for Dataverse tables at this moment GetMetaData activity will not support. Clik here to know about support activities for Dataverse.

You can consider making API call to query table definitions in Dataverse. Click here to more about API. In ADF, we can use Web activity to make this API calls. Click here to know more about web activity. Also consider checking this video for web activity.

Hope this helps. Please let us know if any queries. Thank you.

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

Please consider hitting Accept Answer. Accepted answers help community as well.