title: Is there any way to make a json key a field in redshift
body: <p>I basically want to obtain all of the keys within "questions" and make individual records for each key.
  Say I have json data that looks something like this: </p>
  
  <pre><code>"result": {
      "id": "dsgdsg",
      "name": "xxx",
      "expiration": {
          "startDate": null,
          "endDate": null
      },
      "questions": {
          "QID4": {
              "questionType": {
                  "selector": "TB",
                  "subSelector": null
              },
              "questionLabel": null,
              "validation": {
                  "doesForceResponse": false
              }
          },
          "QID5": {
              "questionType": {
                  "selector": "ML",
                  "subSelector": null
              },
              "questionLabel": null,
              "validation": {
                  "doesForceResponse": false
              }
          },
          "QID6": {
              "questionType": {
                  "selector": "SAVR",
                  "subSelector": "TX"
              },
              "questionLabel": null,
              "validation": {
                  "doesForceResponse": false
              }
  
          },
          "QID7": {
              "questionType": {
                  "selector": "SAVR",
                  "subSelector": "TX"
              },
              "questionLabel": null,
              "validation": {
                  "doesForceResponse": false
              }
  
          }
  
      }
      }
  </code></pre>
  
  <p>would there be any way using jsonpaths to individually load each QID into its own field with its own record? I have tried something on the lines of this:</p>
  
  <pre><code>    {
  "jsonpaths": [
      "$.result.id",
      "$.result.name",
      "$.result.questions.[0]"
  ]
  }
  </code></pre>
  
  <p>but this only gives the data within QID4 and so on. Could i somehow loop through the jsonpaths?</p>