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 Q&A 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

Q&A

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 Quick Sight.

Hope this helps!

1 Like

Topic		Replies	Views
Array to row Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	3	1362	October 12, 2023
Dataset query on Redshift cluster Q&A data-source , analysis , direct-query , redshift , quick-sight , Business-Intelligence-Engineer , SQL , tables	1	180	February 29, 2024
SQL Query editor Q&A direct-query , quick-sight	1	4126	December 16, 2021
Array "fields were skipped because they use unsupported data types" Q&A data-source , quick-sight , how-to	2	1566	December 16, 2022
RLS: with a custom postgresql query Q&A row-level-security , error , quick-sight	3	916	April 16, 2022

Custom SQL access to Redshift super field

Related topics