Dynamically copy from Cosmos DB to Blob Storage with Azure Data Factory

kosmos 246 Reputation points
2022-11-24T13:34:16.13+00:00

I have many containers in Cosmos DB and I want to move them to Snowflake dynamically.

To do this I need to export from cosmos to blob storage and from there to snowflake.

I want to iterate through the containers in Cosmos and the "Get Metadata" and "Lookup" activity are not appropiate for this.

What is the best way to retrieve a container list and iterate ?

Any other smart idea to move from Cosmos to Snowflake that I am not considering with Azure Data Factory ?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,085 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. JimmySalian-2011 42,066 Reputation points
    2022-11-24T14:16:58.963+00:00

    Hi Kosmos,

    Backup and restore is another option however you can check the process here detailed steps here

    Another link.copy-data-from-and-to-snowflake-with-azure-data-factory

    Hope this helps.
    JS

    ==
    Please Accept the answer if the information helped you. This will help us and others in the community as well.