Get data from nested object

SQL++
,
2

@akibandali ,

UNNEST is self join of actual document with array element

For object use dot field i.e. i.element.id

SELECT i.validationLogicId, i.businessValidationId, i.`element`.id, i.severity
FROM  businessValidation  AS i
1 Like