Custom SQL access to Redshift super field

Question & Answer
, ,
1

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 data.
In Redshift I can use “SET enable_case_sensitive_super_attribute to TRUE” or just address the additional_data column with double quotes to ensure case sensitivity like additional_data.“id”.
But when I’m using either of these methods in Custom SQL, while creating dataset, I get an error (in case of SET SET enable_case_sensitive_super_attribute to TRUE) or empty field (in case of double quoted address to additional_data column).
How can I assure case sensitivity with custom SQL using Redshift?
Is there any way to address super data type field from custom SQL?

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