Total Page Preview: 000000001509
What is set variable activity in azure data factory with demo
Set Variable Activity in Azure Data Factory in English:
Use the Set Variable activity to set the value of an existing variable of type String, Bool, or Array defined in a Data Factory
In Azure Data Factory, you can set a variable by following these steps:
-
Open your Azure Data Factory instance and navigate to the "Author & Monitor" section.
-
In the left-hand navigation menu, select "Author".
-
Click on the "Variables" tab at the top of the screen.
-
Click on the "New" button to create a new variable.
-
Enter a name for your variable and select the variable type (e.g. String, Boolean, Integer, etc.).
-
Enter a default value for your variable (optional).
-
Click on the "Create" button to create the variable.
-
In your Azure Data Factory pipeline, click on the "+" button to add an activity.
-
Search for "Set Variable" in the activities list and select it.
-
In the "Set Variable" activity settings, give your variable a name and a value. You can also choose the data type of the variable.
-
Click on "Publish all" to save your changes and publish the updated pipeline.
Once you have set the variable in the pipeline, you can use it in other activities by referencing it with its name. For example, you can use it in an "If Condition" activity to branch the pipeline based on the value of the variable
Set Variable Activity in Azure Data Factory in Hindi:
"Set Variable" activity Azure Data Factory me ek activity hai jo data factory ke andar variable ko set karne ke liye use kiya jata hai. Is activity ki madad se aap variable ka naam, data type aur value set kar sakte hain, aur phir us variable ko dusre activities me refer karke use kar sakte hain.
Is activity ko ek pipeline me add karne ke baad, aap usme kisi bhi value ko assign kar sakte hain. Iske baad, aap us variable ko dusre activities me access kar sakte hain, jaise Data Flow, Copy Data, Lookup, If Condition, For Each Loop, aur bhi bahut saare.
"Set Variable" activity ka upyog mainly dynamic pipeline creation, metadata management, variable-based conditional branching, aur runtime values ko control karne ke liye kiya jata hai. Is activity ki madad se aap apne pipeline ko flexible aur scalable bana sakte hain.
Create pipeline variables:
Set activity in azure data factory:
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com