Menu
How do I set an variable of type array of strings in ADF v2 so that I can iterate over each element? Each element represents a database name?
The 'Set Variable' activity has a dropdown but displays 'no results found'?
Many thanks,
506
To add parameters to your data flow, click on the blank portion of the data flow canvas to see the general properties. In the settings pane, you will see a tab called Parameter. Select New to generate a new parameter. For each parameter, you must assign a name, select a type, and optionally set a default value.
Let's compare Azure Data Factory Version 1 and Version 2 at a high level. ADFv1 – is a service designed for the batch data processing of time series data. ADFv2 – is a very general-purpose hybrid data integration service with very flexible execution patterns.
from the official doc:
Use the Set Variable activity to set the value of an existing variable of type String, Bool, or Array defined in a Data Factory pipeline.
https://learn.microsoft.com/en-us/azure/data-factory/control-flow-set-variable-activity
You'll need to use the pipelines Variable first:
You can also find a good tutorial in here: https://www.mssqltips.com/sqlservertip/6136/azure-data-factory-pipeline-variables/
96
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
