Share via

Copy data Mongodb Collection,need add new field before sink.

kkrao8 1 Reputation point
2022-09-30T22:45:19.877+00:00

Hi,

I am trying to copy data of mongodb(Azure Cosmos DB API) collection from one database to other database, but I need to modify and insert(set new field) my collection before I sink to new Database

Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,356 Reputation points Microsoft Employee Moderator
    2022-10-03T23:12:35.703+00:00

    Hello @kkrao8 ,

    Welcome to the MS Q&A platform.

    Please correct me if my understanding is wrong. You are trying to copy data from one Cosmos Db collection to another cosmos DB collection and you want to modify and insert a new field to your sink database.

    You can use the derived column in your dataflow to achieve this. Please see the below screenshot for your reference.

    Let me know if you have any further questions.

    247168-image.png

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.