CODEWITHSUNDEEP
azure-data-factory
Patterson
Patterson

Reputation: 2825

Azure Data Factory Not Copying all JSON fields when Copying to Azure SQLDB

I am copying data from JSON file to Azure SQLDB. The data in JSON looks like the following:

enter image description here

The data that is sent to Azure SQLDB looks like the following:

enter image description here

You will notice the Businessday, Finaldeadlineday, CommentaryWriter, and TemplateCode aren't copied to the Azure SQLDB

Can someoone explain why this is? And how to get to copy all the fields from the JSON file to Azure SQLDB please

Upvotes: 0

Views: 88

Answers (1)

Rakesh Govindula
Rakesh Govindula

Reputation: 11464

To achieve your required output, you need to use Collection reference and Advanced editor in the copy activity mapping.

enter image description here

Here, you can remove the extra columns and give the required data types for the target columns.

Result table:

enter image description here

Upvotes: 0

Related Questions