Notebooks Unbound: Trigger, Parameterize, and Schedule Like a Pro
Proposed session for SQLBits 2026TL; DR
Stop hitting "Run" manually! Learn to transform Fabric Notebooks into dynamic, automated engines. Master parameterization, build robust pipelines like a pro in this high-energy, demo-led session.
Session Details
Writing a great Notebook is only half the battle; the real magic happens when you step away from the "Run" button and let Microsoft Fabric take the wheel. In this session, we go beyond manual execution to explore the powerful synergy between Fabric Notebooks and Data Pipelines.
We will break down the walls of static code by transforming your Notebooks into dynamic, reusable engines. You’ll learn how to implement parameters to make your logic flexible, use Pipelines to orchestrate complex workflows, and set up automated schedules that ensure your data reaches its destination-without you lifting a finger.
This session will cover the following:
- The Power of Parameters:
Stop hard-coding! Learn to inject dynamic values (dates, API keys, file paths) into your Notebooks via Pipeline expressions.
- Orchestration Excellence:
Master the "Invoke Notebook" activity, including how to handle dependencies and pass variables between pipeline stages.
- JSON on Demand:
A practical walkthrough of generating JSON payloads and automating their delivery to REST endpoints.
- Failure-Proofing: Implementing "Until" loops, error handling, and monitoring to ensure your automated runs are robust and reliable.
We will break down the walls of static code by transforming your Notebooks into dynamic, reusable engines. You’ll learn how to implement parameters to make your logic flexible, use Pipelines to orchestrate complex workflows, and set up automated schedules that ensure your data reaches its destination-without you lifting a finger.
This session will cover the following:
- The Power of Parameters:
Stop hard-coding! Learn to inject dynamic values (dates, API keys, file paths) into your Notebooks via Pipeline expressions.
- Orchestration Excellence:
Master the "Invoke Notebook" activity, including how to handle dependencies and pass variables between pipeline stages.
- JSON on Demand:
A practical walkthrough of generating JSON payloads and automating their delivery to REST endpoints.
- Failure-Proofing: Implementing "Until" loops, error handling, and monitoring to ensure your automated runs are robust and reliable.
3 things you'll get out of this session
The Key Takeaways for the audience:
- Design Dynamic Notebooks:
Learn to replace hard-coded values with Base Parameters, allowing your code to adapt to different data inputs and API environments.
- Architect Robust Pipelines:
Master the orchestration of "Invoke Notebook" activities, including passing variables, handling dependencies, and managing error-retry logic.
- Automate Data Delivery:
Implement automated scheduling and triggers without manual intervention.
Speakers
Pragati Jain's other proposed sessions for 2026
Break the Read-Only Barrier: Real-Time Action with Fabric Translytical Flows - 2026
Fabric in Flux: Streamlining Development with Azure DevOps & Git - 2026
See It, Fix It, Optimize It: Monitoring That Works in Microsoft Fabric - 2026
The Fabric Access Puzzle: Cracking Permission Problems with Confidence - 2026
TMDL in Action: Optimizing Power BI Models with Advanced Scripting - 2026