Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Add/Enhance CustomCode Transformation Node (JavaScript / .NET) in Fabric Eventstream

Add a new Transform CustomCode node in Eventstreams that lets users author and run sandboxed JavaScript or .NET code as a streaming transformation step—similar in UX placement to existing transformations and the SQL operator, but designed for arbitrary code logic. 
Status: New
Comments
svelmurugan
Microsoft Employee
Interesting ask. 1/ What would you want to run inside this node -- ie what type of transform? 2/ do you want to process one or many events at once? 3/ where would you want to write the output to? To another stream? or ?
VChimbili
Microsoft Employee
Most customers today rely on custom functions written in JavaScript (UDF/UDA) in Azure Stream Analytics, and we are looking for similar capabilities in Eventstream. To address your questions: 1)We should enhance the Custom Code (SQL) capability by introducing support for user-defined functions, allowing transformations similar to Azure Stream Analytics. 2) Processing can be handled for both scenarios, depending on the event message type. 3) The SQL code can be extended in a flexible way to support multiple downstream use cases, such as writing to output or passing data to the next processing stage. For example: SELECT UDF.JavaScriptFunction(InputStream) AS sampleResult INTO output FROM InputStream For reference, refer Azure Stream Analytics supports JavaScript-based user-defined functions that enable complex transformations using built-in JavaScript capabilities. Here is the documentation link: https://learn.microsoft.com/en-us/azure/stream-analytics/stream-analytics-javascript-user-defined-fu...