General availability: Stream Analytics no-code editor updates in December 2022

Azure Updates

Discussionpowered by zap.ms

Published

Dec 12, 2022

Status

Launched

Timeline

  • December 2022
    General Availability

Product

Azure Stream Analytics
Event Hubs

Tag

Features

Category

Analytics
Internet of Things

Description

Stream Analytics no-code editor was announced generally available at Microsoft Ignite 2022 in October. This month, a few new capabilities have been released, including:

  1. Support multiple parameters built-in functions in the three categories for data manipulation in “manage fields”: date and time function, string function, and mathematical function:
    • String functions: CHARINDEX, LEFT, REGEXMATCH, REPLACE, REPLICATE, RIGHT, SUBSTRING
    • Math functions: ROUND, POWER
    • Date and Time function: DATEADD, DATEDIFF, DATENAME, DATEPART
  2. Delta Lake format support in ADLS Gen2 output sink
    The Delta Lake format is added to support capturing event data into ADLS Gen2 with Delta Lake format.

To learn more about it, see No-code stream processing through Azure Stream Analytics | Microsoft Learn