@LIU, PETER - Thanks for the question and using MS Q&A forum.
I tried to repro the scenario, and the activity was completed successfully without any issues.
Follow these steps to copy a CSV file from blob storage to snowflake table:
- Create an Azure Data Factory.
- Create Blob storage and upload one CSV file in it.
- Create Linked Service for blob storage as shown in below figure. Select Authentication type as SAS URI and copy paste the SAS URL from blob storage. Click on test connection, make sure the connection must be successful.
- Create a Snowflake instance, then set up a database, warehouse and add a table to the database as illustrated in the figure.
- Create linked service for Snowflake as shown in figure. Enter Account name, Database and Warehouse names correctly from the Snowflake created. Click on test connection and save.
- Create Dataset for Blob storage.
- Create Dataset for snowflake.
- Create a pipeline and add a copy activity. Select source dataset as Blob storage.
- Select sink dataset as snowflake, click on publish all and validate and click on debug.
- Pipeline status is succeeded. Hope this helps. Do let us know if you have any further queries. ------------- If this answers your query, do click
`Accept Answer`
and`Yes`
for was this answer helpful. And, if you have any further query do let us know.