From Clicks to Code: SQL Operator under Fabric Eventstream (Preview)
A new feature has been added to Eventstream—the SQL Operator—which enables real-time data transformation within the platform.
Whether you’re filtering, aggregating, or joining data streams, or handling complex data transformation needs like conditional logic, nested expression, string manipulation etc. SQL Operator gives you the flexibility and control to craft custom transformations using the language you already know and love. This feature takes your Eventstream experience to the next level—unlocking advanced scenarios with precision and ease.
Get ready to transform your data like never before!
Why SQL Operator?
While Eventstream already offers rich no-code experience with built-in operators like Filter, Aggregate, join etc. the SQL Operator gives you full control to:
- Package the entire data transformation logic in one place.
- Write custom logic and complex transformation with ease.
- Apply conditional logic, aggregations, and use variety other supported built-in functions.
- Easily test and debug.
- Route enriched data to any supported destination.
- Easily bring your Azure Stream Analytics transformation logic to Fabric Eventstream.
Key Features
Custom SQL Logic: Define transformations using familiar SQL syntax.
Live Preview: Test your queries on real-time data before publishing.
Flexible Output: Route results to Eventhouse, Lakehouse, Activator or Derived Streams.
IntelliSense Support: Boost productivity and minimize errors with syntax highlighting and auto complete.
How it Works
1. Add the SQL Operator
From the Eventstream canvas, click Transform Events and select SQL Operator.
Alternatively, you can also add SQL operator by clicking on the ‘Transform events or add destination’ on the canvas and select SQL operator.
SQL node will be added to your Eventstream topology. Click on the pencil icon to edit the SQL operator node. Here you can define a name to this SQL node. Click on edit query button to enter the query editor experience as shown below.
2. Write Your Query
Click the pencil icon to open the SQL editor. Once inside the query editor, add the destination by clicking on the green + button on the left data explorer under output section.
Extend the default query template and write your own custom data transformation logic.
Eventstream is built on top of Azure stream analytics. You can use the same Stream Analytics Query Language, which is a subset of T-SQL to define your data transformation logic in Eventstream SQL operator.
3. Test and validate the output
To ensure the accuracy of your logic, use the Test Query button. After verifying the logic and are satisfied with the results, click ‘Save’ to exit the query editor and return to the Eventstream canvas.
4. Complete the output setup and Publish
After saving your SQL transformation, return to the main Eventstream canvas. You’ll notice that an output node has been automatically connected to your SQL operator. Click on this output node to configure your desired destination. Specify the output details according to your requirements, review the configuration and click save. Once complete, your Eventstream is fully configured and ready for publish.
Click ‘publish’ to deploy the eventstream topology as shown in the example. 
The Eventstream is now published and processing live data.
What’s Next?
The SQL Operator in Microsoft Fabric Eventstream is more than just a new feature—it’s a leap forward in how you can shape, enrich, and route real-time data. Whether you’re building complex joins, applying custom filters, nested expressions or string manipulation, SQL gives you the precision and flexibility to do it all—right inside the Eventstream canvas.
We can’t wait to see what you build with it. Try it out today and let us know what you think. Your feedback helps shape the future of real-time intelligence in Fabric. Please continue to share your feedback.
Start building smarter, more flexible real-time data processing pipelines with Eventstreams today. Please refer SQL Operator in Eventstream Microsoft Fabric to learn more and get started today.
Need help or want to suggest an improvement?
Reach out to us on Real-Time Intelligence Forum: Get Help with Real-Time Intelligence – Microsoft Fabric Community
Request or upvote a suggestion on Fabric Ideas RTI: Fabric Ideas – Microsoft Fabric Community
