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

%3CLINGO-SUB%20id%3D%22lingo-sub-1447428%22%20slang%3D%22en-US%22%3EDynamic%20mapping%2FReusing%20Linked%20server%20for%20Datalake%20Json%20files%20to%20Azure%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1447428%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BHi%2C%3C%2FP%3E%3CP%3EI%20have%20loaded%26nbsp%3B%20Data%20from%20REST%20API%20to%20Datalake%20storage%20as%20Json%20files%2C%20I%20want%20to%20dynamically%20map%20columns%20from%20Json%20to%20Azure%20Database.%20As%20I%20am%20using%20shared%20Data%20set%20for%20Azure%20database%20it%20fails%20to%20load%20as%20the%20mapping%20changes%20for%20each%20destination%20table%20is%20different.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20create%20separate%20dataset%20for%20each%20Source.%20Is%20there%20anyway%20of%20doing%20it%20dynamically%3F%26nbsp%3B%3C%2FP%3E%3CP%3EPFA%20are%20the%20screenshot%20for%20the%20same.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

 Hi,

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