Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics


Introduction

In this article, we will talk about Azure Data Factory’s newly introduced Pipeline return value features. We can return value from a pipeline using the Set Variable Activity and retrieve the value in another pipeline using the Execute pipeline activity. Let’s create a demo pipeline to explain this feature.

Pipeline Demo

I used a Get Metadata activity in the pipeline. The get metadata activity is used to retrieve metadata information from Azure such as file name, size, etc. I added two arguments in the settings:

Size – It returns the size of the file. Item name – It