SQL Query editor

Question & Answer
1

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

2

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

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

1 Like