Splitting a Column of JSON Data and then Cross Apply

Help Procedural SQL
1

How to turn this:

image

To This:

image

2

I’d recommend writing a UDF f that returns an array of all the properties. Then use

SELECT *
from t, table(f(t.labels));

It would be easier if the data was already in a JSON array. For that situation, you can do something like

SELECT *
from t, table(json_to_array(t.column_with_json_array));

Relevant documentation:

And sorry it took so long to reply! I overlooked your question.