How to use Azure Data Factory with snowflake | Copy data from Snowflake to Azure Blob using ADF

How to use Azure Data Factory with snowflake | Copy data from Snowflake to Azure Blob using ADF
This video outlines how to use the Copy activity in Azure Data Factory and Azure Synapse pipelines to copy data from and to Snowflake, and use Data Flow to transform data in Snowflake. For more information, see the introductory article for Data Factory or Azure Synapse Analytics.
nowflake is cloud based lightening fast data warehouse. It has gained lot of traction since its launched. Many organizations are moving towards the snowflake and hence there is need to do shift and load, migrate their existing data from on-premise and cloud databases to snowflake. In this article we will see various ways through which we can migrate the data to snowflake using the Microsoft Azure Data Factory.

There are two ways to connect azure data factory with snowflake

1. Create the adf pipeline with copy activity having the sink dataset created using the snowflake connector provided by azure data factory.

2. Connect to azure blob storage by creating stage in Snowflake and use snow pipe to move the data to snowflake data warehouse table.

Let’s dive into both the approach in detail and see how can you integrate step by step using the example.

Scenario: Assume that we have a csv file available which is stored in azure blob storage. We need to load the csv file data in to a table in snowflake.

Please follow and ask any question to our linkedin profile and twitter or our web site and we will try to help you with answer.
Linkedin
  / softwizcircle  
twitter
  / soft_wiz  
website

FB
  / softwiz-circle-113226280507946  

Here Group of People are sharing their Knowledge about Software Development. They are from different Top MNC. We are doing this for community. It will help student and experience IT Pro to prepare and know about Google, Facebook, Amazon, Microsoft, Apple, Netflix etc and how these company works and what their engineer do.
They will share knowledge about Azure, AWS , Cloud, Python, Java,.Net and other important aspect of Software Development.