CODEWITHSUNDEEP
azureazure-data-factory
user849204
user849204

Reputation:

Data factory: how to execute query after copy from blob to SQL?

I'm trying to schedule copy pipeline from blob to SQL. Is there way to run a custom query after the copy is done (e.g. creating/updating view in SQL database)?

Does sqlWriterCleanupScript run before or after the copy is done?

Upvotes: 1

Views: 5887

Answers (1)

Harish
Harish

Reputation: 91

sqlWriterCleanupScript runs as the first step but only for the re-runs of the copy activity. If you want to run a custom query post copy activity then use the stored procedure activity as https://azure.microsoft.com/en-us/documentation/articles/data-factory-stored-proc-activity/ .

Upvotes: 1

Related Questions