Provide the capability to copy data from Blob to Snowflake data warehouse
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