Share via

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.
11,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.