Hi, I have Redshift based dataset with Spice and need to get access to a field with super datatype (“additional_data”), which contains JSON string (like {“id”: “some_id”, “other_id”: “some_other_id”}). I’m trying to create dataset with custom SQL, where I have column (f.e. “id”) from additional da…

Hello @Valentin , Can you take a look at this post [image] Array to row Question & Answer I have a field open_dates which is Array of data type SUPER. Each user will have several open dates in the array, and I need to get all open date for the user to create a line graph…

Custom SQL access to Redshift super field

Question & Answer

andres007 April 17, 2024, 7:01am 2

Hello @Valentin,

Can you take a look at this post

I was able, following this documentation to unnest the SUPER data type and see it as columns in QuickSight.

Hope this helps!

1 Like