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