Not able to add additional column to the sink `Azure Data Explorer` in the Copy Activity of Azure Data Factory.

asked 2021-11-15T20:20:11.513+00:00
Bhagyesh Patil 21 Reputation points

Hi, I am trying to add an additional column to the Azure Data Explorer sink from the source Blob Storage using the "Additional columns" in the Copy Activity "Source" tab, but I am getting the following error:

"Additional columns are not supported for your sink dataset, please create a new dataset to enable additional columns."

When I changed the sink dataset to a blob storage, it works fine and an additional column gets created. Is there anything I am missing on here when I using the Azure Data Explorer as sink?

Alternatively, how can I add an additional column to the Azure Data Explorer table as a sink?

Azure Data Explorer
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.
248 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,250 questions
No comments
{count} votes

Accepted answer
  1. answered 2021-11-16T08:36:25.577+00:00
    PRADEEPCHEEKATLA-MSFT 53,006 Reputation points Microsoft Employee

    Hello @BhagyeshPatil-0681,

    Thank you for the question and using MS Q&A platform.

    This is an excepted behaviour when your Azure Data Explorer dataset was created long time before so that it is still using our old dataset model which is not supported by AdditionalColumns.

    To resolve this issue, you can just follow the error message to create a new ADX dataset and use this as copy sink.

    149822-image.png

    For more details, refer to Add additional columns during copy.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

0 additional answers

Sort by: Most helpful