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?

CodePudding user response：

Additional Columns

As per official

CodePudding user response：

ADX sink doesn't support altering the table using Copy activity. To add a column to the ADX table, use .alter-merge table command in advance and map the additional column to the target column under the Mapping tab of the Copy activity. .alter-merge table command