ADF adds Snowflake support in Mapping Data Flow

Published Aug 31 2020 10:31 AM 9,866 Views
Microsoft

Azure Data Factory now enables Snowflake connector in Mapping Data Flow to expand Snowflake data integration support. You can read data directly from Snowflake for analysis, or write transformed data into Snowflake for seamless ETL. For other Snowflake data integration support in ADF, refer to the earlier blog.

 

For example, when using Snowflake as a source in data flows, you are able to pull your data from a table or via custom query, then apply data transformations or join with other data.

Linda_Wang_0-1598893725741.png

 

Additionally, when using Snowflake as a sink, you can perform inserts, updates, deletes, and upserts so as to publish the analytics result set into the warehouse.

Linda_Wang_1-1598893725758.png

 

You can point to Snowflake data using either a Snowflake dataset or an inline dataset.

 

Here is a walkthrough video. And you can learn more about Snowflake support in Azure Data Factory from Snowflake connector documentation.

5 Comments
Version history
Last update:
‎Sep 01 2020 03:08 AM
Updated by: