Hi! I’m trying to access nested data within my json file and read that that’s achievable using a direct query however I can’t seem to find the editor… the data source is on Redshift btw
Hi @Bluella -
You can take this approach.
Follow the steps on “To create a basic SQL query” on Using the Query Editor - Amazon QuickSight . When you get to Step 3 you’ll be able to select “Use custom SQL” at the bottom of the screen, this will bring you to the SQL Query editor.
Continue with the JSON documentation you mentioned here parseJson - Amazon QuickSight