Activity

What is Activity

Copy Activity

In Azure Data Factory and Synapse pipelines, you can use the Copy activity to copy data among stores located on-premises and in the cloud.

After you copy the data, you can use otheer activities to further transform and analyze it.

Append Variable Activity

Use the Append Variable activity to add a value to an existing array variable.

Delete Activity

Delete files or folders from on-premises storage stores or cloud storage store.

This activity is used to clean up or achive files when they are no longer need.

Execute Pipeline Activity

The Execute Pipeline activity allows a Data Factory or Synapse pipeline to invoke another pipeline

Fail Activity

Throw an error in a pipeline intentionally

Get Metadata Activity

Use the Get Metadata activity to retrieve the metadata of any data in Azure Data Factory or a Synapse pipeline

The output from the Get Metadata activity can be used in conditional expressions to perform validation, or consume the metadata in subsequent activities.

Lookup Activity

Lookup activity reads and returns the content of a configuration file or table.

It also returns the result of executing a query or stored procedure.

The output can be a singleton value or an array of attributes which can be consumed in a subsequent copy, transformation, or control flow activities like ForEach activity

The Lookup activity can return up to 5000 rows; if the result set contains more records, the first 5000 rows will be returned.

The Lookup activity output supports up to 4MB in size, activity will fail if the size exceeds the limit.

Set Variable Activity

Use the Set Variable Activity to set the value of an existing variable of type String, Bool, or Array defined in a Data Factory or Synapse pipeline or use the Set Variable activity to set a pipeline return value

Wait Activity

When you use a Wait Activity in pipeline, the pipeline waits for specified period of time before continuing with the execution of subsequent activities.

Switch Activity

The Switch Activity provides the same functionality that a switch statement provides in programming languages

Filter Activity

Filter Activity in a pipeline is used to apply a filter expression to an input array.

ForEach Activity

The For Each Activity defines a repeating control flow in an Azure Data Factory or Synapse pipeline.

This activity is used to iterate over a collection and executes specified activities in a loop

The loop implementation of this activity similar to Foreach looping structure in gprogramming languages.

You can use any array type variable or output other activities as the input for your ForEach activity.

Util Activity

The Until Activity provides same function that a do-until looping structure provide programming languages.

It executes a set of activities in a loop condition associated with the activity evaluates to true.

If Condition Activity

The If Condition activity provides the same functionality that an if statement provides in programming languages

It executes a set of activities when condition evaluates to true