Edit

Share via

GetRecordProperties (Azure Stream Analytics)

  • Article

Returns a dataset with record property names and values. The result of the GetRecordProperties function must be used with the CROSS APPLY operator.

Syntax

GetRecordProperties ( column_reference )

Arguments

Column_reference

Is the column reference expression to be evaluated. Column must be of type Record

Return Types

Returns a dataset with PropertyName and PropertyValue columns.

Examples

SELECT   
    recordProperty.PropertyName,  
    recordProperty.PropertyValue  
FROM input as event  
CROSS APPLY GetRecordProperties(event.recordField) AS recordProperty