title: Error while copying json data from S3 to redshift using COPY command
body: <p>I have below json data in S3:</p>
  
  <pre><code>{ "message": "{\"a\":\"b\",\"c\":\"d\"}"}
  </code></pre>
  
  <p>and jsonpath:</p>
  
  <pre><code>{
      "jsonpaths": [
          "$.message.a"
      ]
  }
  </code></pre>
  
  <p>I am using below copy command to load redshift table.</p>
  
  <pre><code>copy test.table1 from 's3://bucket1/test.gz' credentials 'aws_access_key_id=&lt;&gt;;aws_secret_access_key=&lt;&gt;' json 's3://bucket1/jsonpath.json' GZIP ;
  </code></pre>
  
  <p>but it fails with error.</p>
  
  <blockquote>
    <p>Invalid JSONPath format: Member is not an object.</p>
  </blockquote>