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

Bhagyesh Patil 26 Reputation points Microsoft Employee
2021-11-15T20:20:11.513+00:00

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.
546 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,209 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA 90,536 Reputation points
    2021-11-16T08:36:25.577+00:00

    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

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.