Having generated a file in Data Factory (using a Copy Task where the source data set is a Sql SP, and the sink is Azure blob storage) I am trying to follow the answer to this question to copy the file into an AWS S3 bucket. I have the Azure function working fine, but it requires the URI-with-SAS-token of the file to transfer.

How do I get the SAS Token in the ADF pipeline, please? (Alternatively, if you can suggest a better way of copying a file from Blob Storage to S3, please do.)

CodePudding user response：

You can store the SAS token in a key vault and get the value from key vault via web activity. The below GIT location has the JSON code for the same: https://github.com/NandanHegde15/Azure-DataFactory-Generic-Pipelines/blob/main/Get Secret From KeyVault/Pipeline/GetSecretFromKeyVault.json