How to save the script activity output in csv file from Data Factory

Ashish Pal 1 Reputation point
2022-05-04T03:48:39.387+00:00

Hi All,

I have requirement like once Run the script activity it will return some result set and now i want to store that result set into csv file in blob storage.

For. E.g:- I run the sql script against Snowflake DB and I successfully get result that i want . The out put of the script is with 11 column and 11 rows.

But now i want to store the same result set in csv file in blob storage.

So can anyone have any idea which activity i have to use after script activity for copying the data in blob storage. And how I pass the script activity output into another activity for store the result set.

Regards
Ashish Pal

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,161 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 31,436 Reputation points MVP
    2022-05-04T03:55:14.323+00:00

    Hey,
    Any reason why you want to use script activity?
    You can use Copy activity with the source as the query and sink as the blob storage.
    Thanks!

    2 people found this answer helpful.