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

azure azure-data-factory-2
James picture James · Nov 18, 2019 · Viewed 7.5k times · Source

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,

Answer

Thiago Custodio picture Thiago Custodio · Nov 18, 2019

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://docs.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/

Related questions

Azure Data Factory v2 using utcnow() as a pipeline parameter

For context, I currently have a Data Factory v2 pipeline with a ForEach Activity that calls a Copy activity. The Copy Activity simply copies data from an FTP server to a blob storage container. Here is the pipeline json file : { "…

Read More
How to run SQL Script in Azure Data Factory v2?

There is NO Sql Script activity in Azure Data Factory V2. So how can I create a stored proc, a schema in a database? What are my options?

Read More
How to read files with .xlsx and .xls extension in Azure data factory?

I am trying to read and excel file in Azure Blob Storage with .xlsx extension in my azure data factory dataset. it throws following error Error found when processing 'Csv/Tsv Format Text' source 'Filename.xlsx' with row number 3: found …

Read More