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.
Comments
Post a Comment