title: Amazon Redshift error while copying json file - Invalid JSONPath format: Member is not an object
body: <p>I am trying to copy a JSON file to Redshift but keep getting the error "Invalid JSONPath format: Member is not an object."</p>
  
  <p>the problem seems to be because of the presence of "[" and "]" as the first and last characters in the JSON file. Everything else in between confirms to the standard JSON format. When I modified the file and removed those two characters the table load goes through smoothly.</p>
  
  <p>The file is provided directly from a developer, and I don't have the influence to persuade him change the format. So my only option, is to somehow tell the COPY command to ignore those two characters at the beginning and end of the JSON file.</p>
  
  <p>I appreciate any suggestions/help from the group.</p>