Forum Discussion
Chaitanya_Koneru
Aug 26, 2021Copper Contributor
Snowflake as Sink is not working in ADF
We are copying data from on premise SQL server to Snowflake hosted in AWS(west-us2 region). As there is no direct option we had created a Azure BLOB (in west-us2 region) staging area to use it. Howe...
MadhanKS
Nov 09, 2021Copper Contributor
Did you get any solutions?. I am also facing the same issue
Chaitanya_Koneru
Nov 09, 2021Copper Contributor
No, mine is different. As my Source and Target is hosted both in the Snowflake we handled it by writing the complete logic in Snowflake Stored procedures and called them in ADF using Lookup activity. However the above requirement is for existing data migration from On premise SQL server to Snowflake. As this is a one time task , we handled it in a different way (which is outside of ADF).