Author: Vaibhav Shirvastava - Principal Program Manager
_____________________________________________________________
The SQL operator was first introduced in preview to give customers an early look at a code‑first transformation experience in Fabric Eventstreams. During preview, customers used the SQL operator to simplify real-time pipelines, consolidate transformation logic, and unlock advanced scenarios using familiar SQL semantics. Feedback from this phase directly shaped this release—driving improvements across multi‑destination support, event‑time processing, testing capabilities, and overall production readiness.
Building on this preview momentum, we’ve reached the next milestone for SQL operator in Fabric Eventstreams, a powerful, code‑first way to transform and route data across Fabric’s Real-Time Intelligence experiences. This complements Eventstream’s no-code capabilities, giving engineers the flexibility to choose the right abstraction for their scenarios.
With this release, you can define transformation and routing logic once using familiar SQL semantics and seamlessly deliver streaming results to multiple destinations in parallel—all from a single operator.
What’s new
The SQL operator is now production‑ready with support for:
Multiple destinations from a single SQL operator - Fan out processed events simultaneously to Eventhouse, Lakehouse, Activator, or downstream Eventstreams—without duplicating pipelines.
Figure: Eventstream topology using SQL operator writing to multiple outputs.
Built‑in testing experience - Validate transformations for individual outputs before publishing, making it easier to author and debug complex streaming logic.
Figure: An updated explorer and test results design for multiple outputs.
Event‑time processing - Process events based on event timestamps in the payload, with built‑in controls for handling late and out‑of‑order data.
Figure: New advanced settings to configure late arrival and out of order threshold.
Why this matters
In enterprise data platforms, multiple systems like analytics, alerting, workflows, storage etc. depend upon the output of real-time pipelines. Previously, serving multiple such downstream consumers often led to more complex topologies or scattered transformation logic.
With the SQL operator in Fabric Eventstreams, you can:
- Centralize transformation and routing logic in one place.
- Reduce pipeline complexity and operational overhead.
- Iterate faster with confidence using built‑in testing.
- Scale real-time architectures without sacrificing clarity or performance.
- Handle late arrival and out-of-order events with ease.
This milestone brings the proven SQL query model of Azure Stream Analytics directly into Fabric’s unified Real-Time Intelligence experience.
Built for Real-Time Intelligence scenarios
From IoT monitoring and real-time dashboards to alerting and historical analysis, the SQL operator enables a wide range of real-time scenarios—using one lightweight, maintainable transformation node.
You decide what data each destination receives, while Fabric handles the parallel delivery at scale.
Get started today
Explore these resources to learn more and start building:
- Microsoft Fabric Eventstreams Overview
- Process Events Using a SQL Operator
- From Clicks to Code: SQL Operator under Fabric Eventstream
We can’t wait to see how you use the SQL operator to simplify real-time pipelines and unlock new streaming scenarios in Fabric.
We’d love your feedback!
If you find this blog helpful, please give it a thumbs up!
We would love to hear what real-time scenarios you’re exploring and what topics you’d like us to cover in future posts. Drop us a comment or reach out to us at askeventstreams@microsoft.com
Have new feature ideas? Submit them at Fabric Ideas – Microsoft Fabric Community