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

Question

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 ?

Answer 1

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.