Parameterization and Dynamic content at the Azure Data Factory

The parameter at the Azure data factory plays an important role when we need to load data from multiple source database tables to the destination.

There are two ways to set the parameters:

(i) Parameters at the Data set.

(ii) Parameters at the Linked service.

Parameters at the Data set

PARAMETERS AT THE DATASET

Dynamic content in the Data set

Click on the Connection -> select add dynamic content -> select the Parameter

DYNAMIC CONTENT IN THE DATA SET

Dynamic parameters

DYNAMIC PARAMETERS

Set values to the Dynamic parameters

DYNAMIC PARAMETERS

Parameters at the Linked service

Thanks for the read🙂. Do clap 👏👏if you find it useful.