Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,417 questions
Do we have any limit to add number of columns in Azure Data Factory copy activity Dynamic Column Mapping ?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 4%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
Gane Kameswar Rao
0
Reputation points
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) .
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Subashri Vasudevan 11,226 Reputation pointsFeb 27, 2024, 12:54 PM Hi, there's no screenshot,.could you please check? Ideally there should not be any restriction on column count. Do you encounter any issues while doing the dynamic mapping ?
-
Subashri Vasudevan 11,226 Reputation points
Feb 29, 2024, 10:29 AM Hello @Gane Kameswar Rao did you get a chance to check the above comment?
Sign in to comment
Sign in to answer