In Pipeline Builder, what is the recommended approach to collect an array of values where the order is defined by a field?
By default, the order in a Collect Array expression is not deterministic. A possible workaround is to use an Ordered Window expression with Collect Array and then sort on the required field.