Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
482 questions
Column Mismatch in ADF copy activity with explicit 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(272, 92%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZC%3C/text%3E%3C/svg%3E)
Zhen Chen
6
Reputation points Microsoft Employee
With explicit mapping on the ADF copy activity(Kusto -- ADF -- Kusto), there is also a column mismatch happened. Some columns of data are copied from the previous to the subsequent column.
the pipeline runID : 587a6b05-cc52-4ae6-87ab-b25ec58e5c09
some issue picture :
{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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee2021-10-29T23:06:55.3+00:00 Hello @Zhen Chen ,
Thanks for the ask and using Microsoft Q&A platform .
Well I do not see anything which points out what is odd at this time . Can you please send me the table defination in Adx ? I can try out if there is anything wrong with the field names . Also please ADF JSON .Thanks
Himanshu -
Zhen Chen 6 Reputation points Microsoft Employee
2021-11-08T09:52:33.98+00:00 
-
Zhen Chen 6 Reputation points Microsoft Employee
2021-11-08T09:54:26.45+00:00 What you mean by ADF JSON？ @HimanshuSinha-msft
-
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
2021-11-17T17:42:40.407+00:00 Hello @Zhen Chen ,,
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
ADF name :
Pipeline runid :
Subject : Attn Himanshu
Please let me know once you have done the same.Thanks
Himanshu -
Zhen Chen 6 Reputation points Microsoft Employee
2021-11-19T05:41:25.967+00:00 Could you provide a process for how to file a ticket to the ADF team?
-
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
2021-11-24T19:26:02.017+00:00 Hello @Zhen Chen ,
As requesdted before please droip an emal to azcommunity@microsoft.com and I will help you with that .
Thanks
Himanshu
Sign in to comment