Azure Synapse Analytics: Until Activity [Introduction to Synapse - Ep. 15] - Check if File Exists!

In this episode Mitchell will introduce you to the the until activity in Synapse Pipelines. More specifically, in this video you will learn how to use the Until Activity with variables and the get metadata activity to build a watcher that runs UNTIL a file is uploaded to the Azure Data Lake!

👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - https://pragmaticworks.com/pricing/

00:00 - Introduction
02:15 - Creation of a Boolean Variable ("file exist") in a New Pipeline
03:47 - Configuration of the Until Activity with a Boolean Expression (Dynamic Content)
05:13 - Inclusion of Get Metadata Activity to Check the Existence of a File
07:23 - Update of the Variable Based on the Output of Get Metadata Activity
08:47 - Addition of a Wait Activity to Introduce a Delay in the Until Loop
09:13 - Debugging and Running the Until Loop to Check File Existence
10:40 - Successful Completion of the Until Activity After File Upload (Variable Set to True)
11:44 - Overview of the Entire Process and Next Steps in Processing the File
12:00 - Closing Remarks
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

👉 On-Demand Learning - Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:

✔️Twitter: https://twitter.com/PragmaticWorks
✔️Facebook: https://www.facebook.com/pragmaticworks/
✔️Instagram: https://www.instagram.com/pragmatic.works
✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks
✔️YouTube: https://www.youtube.com/pragmaticworks


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks

Runtime 00:12:07

Azure Synapse Analytics, ETL in Azure, Until Activity, Parameters and Variables, PragmaticWorks, Mitchell Pearson, Learn Azure Synapse, Learn Azure Synapse Analytics, Azure How To, Microsoft Azure Synapse, Learn Synapse, Check if File Exists Synapse,