azure - Dynamic content for additional column with copy activity from table Storage to CosmosDb

Question

I am trying to copy form Azure Table Storage to Azure CosmosDb sql Api using Azure Data Factory V2. During copy I want to add a new field (column) to each document by concatenating two of the column values from table. E.g. my table has 2 columns imageId and tenantId and I want to make the id of document in cosmos db like image_tenant_ImageID_TenantID.

For this I am trying to add dynamic content for "Additional Columns" under "Source" in the ADF but couldn't figure out how to do that. Can anyone please help with this?

question from:https://stackoverflow.com/questions/65893551/dynamic-content-for-additional-column-with-copy-activity-from-table-storage-to-c

Answer 1

Seems like I can not do it as part of copy activity. So first I copy from table to temporary cosmos container and then use dataflow to create new column by using "Derived column" activity and copy the results to a new container.