Share via

Do we have any limit to add number of columns in Azure Data Factory copy activity Dynamic Column Mapping ?

Gane Kameswar Rao 0 Reputation points
Feb 27, 2024, 10:40 AM

I am trying to perform column mapping to copy data for required columns.
My source is CSV file and Sink is Synapse Dedicated SQL pool. But the CSV file is having 135 columns and I want to load only 130 columns by doing column mapping and that to need to pass as json object in copy activity mapping section [add dynamic content] (Please refer screenshot) .

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,398 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.