~~~ SELECT id, FLATTEN(data)[0] AS dttm, FLATTEN(data)[1] AS result FROM ... ~~~
This works, but each FLATTEN seems to slow the query down dramatically, 3x slower with the second flatten.
Is there a better approach to extracting list elements? ~~~ [ { "id": 16, "data": [ [ "2016-07-13 00:00", 509, "OK" ], [ "2016-07-13 00:01", 461, "OK" ], [ "2016-07-13 00:02", 508, "OK" ], ~~~