- My goal: "set enable_case_sensitive_super_attribute to true;" to allow accessing the super attribute of a raw_data column which contains a json format of data
- Issue: Does not seem to be possible in the SQL query directly
- Steps I've taken to troubleshoot: Contacted Support and this is the answer they gave me:
It seems like there may be some workarounds that COULD work with your need to set the enable_case_sensitive_super_attribute to true.
You could possibly alter session variables via SQL statements within a query. Or possibly using a JS code block that queries the database session before running your main business logic query. So this would take two steps: set the session attribute with the JS scriptn, then run the main query.
If you need help looking into these options or other solutions, please ask for help on our Developer Community Forum . There are community experts and Retool Community Engineers who can provide you with assistance.
- Additional info: -
I am relatively new to Retool, so appreciate any help with this. Thank you