Update: 9th of June 2020:
ADF now supports data integration with Snowflake
A few days ago an Idea on “Azure Feedback” got a Status update which is very good news! Microsoft started working on Support Snowflake as a Sink Feature. This makes Snowflake and Microsoft Azure Data Factory are more interesting combination.
Until now you can build your own connector with a few lines of Code, picking up some Examples:
https://blogs.endjin.com/2019/04/snowflake-connector-for-azure-data-factory-part-1/
However, there is also a GA Announcement in Azure Data Factory – Mapping Data Flows.
Not forget about Wrangling Data Flows which basically lets you execute Power Query M Scripts in Azure Data Factory including Power Query Online Mashup Editor, they are currently in private Preview.
Pulling all that together, Azure Data Factory or better Microsoft and Snowflake (on Azure) are a good combination, thinking of Power BI as well. There are also Hybrid Data Integration Scenarios available – extending on-premises Data Solution to the Cloud. (Snowflake and Microsoft Azure Data Factory)
https://datadriven.pro//2019/05/26/extending-on-premises-data-solutions-to-snowflake-on-azure/
So from my point of view there are less things missing to bet on a Dual Vendor Strategy in Terms of Data Management and Analytics. Just to Name it again:
Azure High Level Architecture Data Platform & Self-Service Data Preparation
-
Data Orchestration
- Azure Data Factory Mapping-, Wrangling Data flows, Snowflake as Sink, Custom Functions and Activities
-
Data Analytics
- Power BI Desktop, Power BI Service, Power BI Dataflows stored in Azure Data Lake Storage Gen2
-
Data Lake
- Snowflake on Azure, Snowpipe
-
Data Science
- Azure Databricks, Azure Machine Learning
-
Hybrid Data Management
- On-premise Data Sources
- Security
- Single Sign On, Azure Active Directory, ADFS Active Directory Federation Services
Other Ideas to Support:
https://feedback.azure.com/forums/270578-data-factory/suggestions/34633954-support-snowflake-as-sink
Views: 620