Forum Discussion
Solved
Parameterising a Json to SQL DW Mappingundefined
I have JSON files in a folder. I am delta loading them into a SQL Data Warehouse dependant upon if they have been processed or now. At the start I have a lookup that triggers a Stored Procedure usp...
All sorted quite quickly thanks. i just needed this in the copy activity in mapping
@json(activity('LookupGetParameters').output.firstRow.mapping)I had to wrap the json around it to make it work properly as part of the code
Hi DebbieE
I found a blog about dynamic mapping in Azure Data Factory. You may try if the solution can be adjusted to be applied to the data pipeline in Fabric. It might be helpful.
Best Regards,
Jing
Community Support Team
All sorted quite quickly thanks. i just needed this in the copy activity in mapping
@json(activity('LookupGetParameters').output.firstRow.mapping)
I had to wrap the json around it to make it work properly as part of the code