String Type Variable in Azure Data Factory | How to Save Output of Activity to String Type Variable

Topic: String Type Variable in Azure Data Factory.

In this article, we are going to learn about string type variables in the Azure data factory, we will also learn how to save the output of activity to string type variable, we will create a pipeline, in this pipeline, we will create a variable then will copy data from our Azure SQL database to the variable. let's start our demonstration.

Open your Azure data factory studio, go to the Author tab, click on the pipeline, then click on New pipeline to create a new pipeline.


In the pipeline, click on the white canvas, go to the Variables tab, click on the + New button to create a new variable, name your variable, select the type, then provide the values.


Find and bring the lookup activity, go to the settings tab, click on the + New button to create a new source dataset.


Select Azure SQL database, then click on continue.


Name your dataset, then create a new linked service, name your link service, select Azure subscription, server name, provide database name, select authentication type, provide your username and password then click on create and then click on Ok.


In the settings tab select the query, then provide the SQL query.


Find and bring the set variable activity, then go to the Variables tab, select the variable, in the value click on '' add dynamic content'' then select the lookup and at the end of expression add ''.firstrow.col'', then click on Debug to execute the pipeline.



In another scenario, I am going to get the data from REST API and write it into a variable, create a new pipeline, find and bring the web activity, go to the settings tab, provide the URL, then in the method select GET.



Click on the white canvas, go to the Variables tab, click on the + New button to create a new variable, name your variable then select the variable type.


Find and bring the set variable, connect with the web activity, go to the Variables tab, select the variable we created, in the value click on Add dynamic content and select the web activity, and then click on 
Debug to execute the pipeline.   



Video Demo: String Type Variable in Azure Data Factory - How to Save Output of Activity to String Type Variable


8 comments:

  1. Many have come to the conclusion that Bitcoin and other cryptocurrencies cannot be traced or recovered but it’s incorrect, it can be traced and recovered with the right tools and resources. I was one of those who didn’t believe in it but I was able to recover my Bitcoin after I sent a huge amount to the wrong address with the help of a recovery team called Hack Judas. I thought all hope was lost for good but with the intervention of Judas, I was able to trace and recover my Bitcoins. Truly remarkable work by Hack Judas and I highly recommend their service.

    Judas can be reached via E-mail: hackerjudas9@gmail.com
    INSTAGRAM: hackerjudas

    ReplyDelete
  2. Consult A Licensed Crypto Recovery Expert / Captain WebGenesis.

    Contact info: Email: Captainwebgenesis@hackermail.com WhatsApp:(+1 (447) 442–0456.}
    G 'day, my name is Michael Collman, and I'm from Australia,...
      Here is my recommendations,
    While looking for help after losing $324,000 USD in Cryptocurrency to an unregulated trading platform (89 percent. com), I came across numerous endorsements and testimonials about Captain WebGenesis, I sent him a direct message, to which he replied and requested some information, which I also provided. After five hours of working with the Expert. and because it took me three weeks to find Captain WebGenesis, the Cyber Lord was able to recover $259,200 USD worth of Bitcoin out of $324,000 USD worth of Bitcoin. Even though he only recovered 80% of my bitcoin, I'm still overjoyed because I didn't think it was possible. Thanks to Captain WebGenesis... If your cryptocurrencies have been stolen in any way, contact the Expert as soon as possible.

    ReplyDelete
  3. HIRE A HACKER FOR CHANGE OF SCHOOL GRADES ......


    Are you tired of struggling with your school scores? Look no further than Contact Folkwin expert recovery! By seeking assistance from this amazing service, you can unlock a world of advantages that will have a positive impact on your academic performance and overall learning experience. Folkwin expert recovery provides you and other students with a lot of advantages. First of all, their team of professionals is prepared to offer individualized care that is catered to your particular requirements. They can aid you if you're having trouble with a specific subject or would like to improve your study habits. Additionally, utilizing Folkwin expert recovery can boost your confidence and motivation. By receiving guidance and encouragement from experienced professionals, you'll feel empowered to overcome any challenges standing in your way. Gone are the days of feeling overwhelmed or defeated. With their help, you can conquer your academic goals with ease. Don't just take these word for it; let the success stories of fellow students inspire you. Folkwin expert recovery has helped countless students achieve remarkable academic improvements. These inspiring testimonials highlight the effectiveness of the services provided and serve as a testament to the life-changing impact they can have. Students who were once struggling and disheartened found renewed motivation and achieved outstanding results with the help of Folkwin expert recovery . From failing grades to top of the class, these success stories showcase the transformative power of seeking assistance and utilizing the resources available to you. You can also get your grades improved by emailing: Folkwinexpertrecovery @ tech-center . com (or) Telegram: @folkwinexpertrecovery ..

    Regards,
    Naisha Berrios.

    ReplyDelete
  4. Having encountered a substantial loss of $508,000 due to an Instagram cryptocurrency scam, which resulted in denied withdrawals, I sought a solution. Turning to Wizard Asset Recovery, I was impressed by their remarkable effectiveness in retrieving my funds. I wholeheartedly recommend their services to individuals facing similar situations. For assistance in reclaiming lost crypto, reach out to Wizard Asset Recovery at Wizardassetrecovery@gmx.us or via WhatsApp at +1 (315) 756-1228. My sincere gratitude goes to them for their expertise in resolving my unfortunate situation.

    ReplyDelete
  5. came across a private investigator online who helped me fix my bad credit score,increase my son's bad school grades also helped me spy on my ex cheating wife who wanted to run away with half of my properties after divorce but she could not have her way all thanks to Premiumhackservices AT gmail DOT com now i am living a stress free life all because of the encounter i have with these private investigator, Contact now via Whatsapp +14106350697 and be left happy.

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. This informative piece guides users on saving the output of activities to string type variables, showcasing the utility and flexibility of Azure Data Factory. Such insights contribute to efficient data handling and processing. For those seeking academic assistance, especially in chemistry, https://essays.edubirdie.com/chemistry-help connects users with chemistry help services. Just as the article guides through technical processes, Edubirdie supports students in mastering complex subjects, ensuring a comprehensive understanding of academic topics.

    ReplyDelete
  8. I thought I was invested in cryptocurrency hoping to make a substantial profit. Unfortunately, the platform I chose turned out to be fraudulent, and I lost around $8,993,457. It was one of the most destructive phase of my life, but I am grateful I survived it through the help of my friends and family whom was there to support me in different ways. My best friend introduced me to a cryptocurrency recovery expert (SPYHOST CYBER SECURITY COMPANY ) who helped me recover my lost Bitcoin. I am grateful for their expertise, and dedication shown by Spyhost Cyber Services. If you wish to recover your stolen Bitcoin kindly send them an email via Email: Spyhost@cyberdude.com or through whatsapp +1(228) 313 - 3152

    ReplyDelete