When using Redshift Super type, I am unable to select nested mixed case data types from a super column.
The case insensitive setting on redshift is set to true:
> SET enable_case_sensitive_identifier to TRUE;
I run a query ie: select mysupercolumn.“myMixedCaseKey” from tablewithsupercol and I get no results. I copy and paste that same query into another interpreter, and I do get results. I checked on the redshift side on completed queries, from a redshift perspective, the queries are identical (ie there’s no escape chars or weird translations from Redash) however the end query is just null.