Snowflake connector as both source and 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!
Is there early adoption available? And will this update also come with the ability to execute SQL against Snowflake? Since Snowflake doesn't support Stored Procedures, the current option is to hack it by using the lookup task, but that doesn't work well either since though it does successfully run the SQL, Datafactory says the task fails.
do we have an ETA on this connector? We have many use cases waiting for this connector
Mika Laitinen commented
Snowflake can be used as both source and sink by using ODBC connector:
Data also can be loaded from Azure Blob Storage to Snowflake:
Is there early adoption available?
Any idea when it is planned for release?
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