SQL Query editor

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.

  1. 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.

  2. Continue with the JSON documentation you mentioned here parseJson - Amazon QuickSight

1 Like