Share via

A community member has associated this post with a similar question:
Copy activity with REST source - mapping JSON to SQL

Only moderators can edit this content.

Data Factory/Synapse: Additional column in copy activity does not get mapped correctly with collection refence

Paul Hernandez 691 Reputation points Microsoft Employee
2022-02-10T16:12:41.847+00:00

Hi everyone,

I want to add an additional column to the source of a copy activity like this:

173261-image.png

After added it the output now looks like:

173157-image.png

I want to flatten out this json but I found two issues.

If I configure the mappings like this (selecting a colection reference):

173175-image.png

The added column "DSTS" has only NULL values in the target table.

If then I do not select any collection reference, only one line is inserted with all columns at NULL except the "DSTS"

According to this article https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-schema-and-type-mapping

Conclusion: cross-apply is not working

Do you see something wrong?

Thanks in advance!

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.