CODEWITHSUNDEEP
azureazure-data-factory
James
James

Reputation: 777

How to create and set a variable in azure data factory v2

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'?

screen shot Many thanks,

Upvotes: 9

Views: 19919

Answers (1)

Thiago Custodio
Thiago Custodio

Reputation: 18387

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:

enter image description here

You can also find a good tutorial in here: https://www.mssqltips.com/sqlservertip/6136/azure-data-factory-pipeline-variables/

Upvotes: 13

Related Questions