snowflake to Azure sql table

Question

Hello Team,

I am trying to transfer data from snowflake to Azure sql db:

Source : Snowflake DATASET :

Target : SQL Server dataset :

When i run the pipeline i am facing Validation issue :

Please advise

Answer 1

Hello @Rohit Kulkarni ,

Thanks for the question and using MS Q&A platform.

This is an excepted behaviour, if your sink data store and format meet the criteria described in this section, you can use the Copy activity to directly copy from Snowflake to sink. The service checks the settings and fails the Copy activity run if the following criteria is not met:

Make sure to check the below conditions to successfully copy data from Snowflake.

For more details, refer to Direct copy from Snowflake.

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators