This article is contributed. See the original author and article here.

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.

Learn more about Snowflake support in Azure Data Factory from Snowflake connector documentation.

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.