Using Script Activity in Azure Data Factory
🔥 Learn Microsoft Fabric hands-on!
👉 https://www.skool.com/fabricforge
🔥 Ace Your Certification Exams – Free Practice Questions!
👉 https://certiace.com/
☕ Enjoying the Content? Support the Channel!
💖 https://buymeacoffee.com/aleksipartan...
👨💼 Follow Me on LinkedIn!
🔗 / aleksi-partanen
🚨 Join the Free Microsoft Fabric Community on Discord!
👉 / discord
📚 Recommended courses on Datacamp:
Python Data Fundamentals: https://datacamp.pxf.io/c/6429510/312...
Data Analyst in Python: https://datacamp.pxf.io/c/6429510/312...
SQL Fundamentals: https://datacamp.pxf.io/c/6429510/312...
Power BI Fundamentals: https://datacamp.pxf.io/c/6429510/291...
PL-300: Microsoft Power BI Data Analyst: https://datacamp.pxf.io/c/6429510/312...
Data analyst in Power BI: https://datacamp.pxf.io/c/6429510/312...
More courses: https://datacamp.pxf.io/c/6429510/207...
These are affiliate links. If you sign up through them, I may earn a small commission at no extra cost to you. Thanks for supporting the channel.
📂 Access Learning Materials (Files, Code, etc.)
💾 Download helpful resources here:
🔗 https://drive.google.com/drive/folder...
🎓 More of My Content:
🎥 • DP-700 Microsoft Certified: Fabric Data En...
🎥 • Microsoft Fabric Data Engineering
🎥 • Microsoft Fabric Tutorials
🎥 • DP-600 Microsoft Certified: Fabric Analyti...
🎥 • Learn Azure Data Factory in 2026 - Full Co...
🎥 • Learn Microsoft Fabric Data Pipelines in 2...
🎥 • Learn Microsoft Fabric Notebooks in 2026 -...
🔗 All the Videos:
/ @aleksipartanentech
How to Use the Script Activity in Azure Data Factory
In this tutorial, Aleksi explores the Script Activity in Azure Data Factory—a versatile tool that allows you to execute SQL statements in various SQL databases. Learn how to run queries, manage parameters, and log outputs while interacting with databases such as Azure SQL Database, Azure SQL Dedicated Pool, SQL Server, Oracle, and Snowflake.
What You’ll Learn:
🔷 The difference between Query and Non-Query script types
🔷 How to execute SQL scripts directly in your pipelines
🔷 Using Script Activity as a Lookup Activity to fetch data
🔷 Inserting and modifying data with Script Activity
🔷 Configuring parameters and advanced logging options
Key Takeaways:
✨ Understand when to use Query vs. Non-Query in pipelines
✨ Learn how to use Script Activity to insert, update, or fetch data
✨ Discover how to log SQL script outputs to activity outputs or external storage
✨ Get tips for optimizing timeouts and managing script execution
Related Hashtags:
#AzureDataFactory #ScriptActivity #SQLIntegration #DataEngineering #ETL #AzureSQL #DataPipelines