 <p>You can do something like below, this gives the counters as (propertyName, propertyValue) pairs.</p> <pre><code>with T1 as ( select GetArrayElement(iotInput.performanceCounter, 0) Counter, System.Timestamp [EventTime] from iotInput timestamp by context.data.eventTime ) select [EventTime], Counter.categoryName, Counter.available_bytes [Value] from T1 where Counter.categoryName = 'Memory' union all select [EventTime], Counter.categoryName, Counter.percentage_processor_time [Value] from T1 where Counter.categoryName = 'Process' </code></pre> <p>Query that gives one column per counter type can also be done, you will have to either do a join or a group by with 'case' statements for every counter.</p>