Dynamic mapping/Reusing Linked server for Datalake Json files to Azure Database

Copper Contributor


I have loaded  Data from REST API to Datalake storage as Json files, I want to dynamically map columns from Json to Azure Database. As I am using shared Data set for Azure database it fails to load as the mapping changes for each destination table is different. 

I don't want to create separate dataset for each Source. Is there anyway of doing it dynamically? 

PFA are the screenshot for the same.

0 Replies