Load data from snoflake to cosmos db

Question

Hi,

I am looking for a solution to copy data from snowflake to cosmos db in azure. I have seen we have Azure Data Factory and Talend data factory available to export data but i am looking for other options which is cost-effective. This is not a commercial development and I am using it for an experiment. Please suggest. If ADF is the only option, how do I configure as it is a PaaS service and not available in Azure as SaaS.

Answer 1

Hi @Sunil Kumar Puthiya Veettil ,

Thank you for posting in Microsoft QnA platform.

Direct Snowflake to Cosmos DB data load is currently not supported.

In Azure Data Factory, we can first stage the data from Snowflake to Azure Blob storage (must use shared access signature authentication) with sink data format is of Parquet, delimited text, or JSON. Then we can transfer from Blob Storage to Cosmos DB.

Helpful links are:

• connector-snowflake
• data-load-azure-config.html
• copy-data-from-snowflake-to-cosmosdb.html

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification