Array to row

Hi,

I was testing this with Redshift and got an error when importing the data into Quick Sight

and the field c_orders is the column of type super

The only way I have found to do this from Redshift is to use the unnesting functions integrated with Redshift.

Which if you use in a custom SQL over the table you get a normal dataset you can visualize.

I am not sure if the SUPER datatype is present in other databases or how will it be unnested, but for Redshift you can find more information and the example datasets I used here

Hope this helps!

Kind regards,
Andres.