Support Snowflake as Sink
Provide the capability to copy data from Blob to Snowflake data warehouse
Thanks all for the feedback for supporting Snowflake as sink! We have started working on this feature and hope to make it available in upcoming months. Please stay tuned!
Kiriti Chirravuri commented
Please add a native connection to Snowflake data warehouse for Azure Data Factory and SSIS
The ability to connect to Snowflake as a data sink and also the ability to execute scripts of SnowSQL would allow Azure Data Factory to function as an ETL/ELT process. Currently, it fails in the final step.
Grotheer, Matt commented
Frederic Forest commented
We are definetly loosing ground to Matillion because of this. This is quite important...
I'd love to know if there's any plans to add this. Any updates???
With Azure functions and some app services, once you have it in blob storage, it's just a matter of putting the right service calls in place to get data into Snowflake with Data Factory.
Add support for a connection to Snowflake as a dataset