title: S3 to Redshift: Unknown boolean format
body: <p>Executing a copy command from S3 to Redshift, loading JSON files. I have some fields as bool in a new table I'm inserting into and always getting the following error: "Unknown boolean format"</p>
  
  <p>My JSON is well parsed, ran a million tests on that already. I've tried passing in the boolean fields as:</p>
  
  <pre><code>false  //  "false"  //  "False"  //  0  //  "0"  //  null
  </code></pre>
  
  <p>But always get the same error, when executing:</p>
  
  <pre><code>select * from stl_load_errors;
  
  err_code  err_reason
  1210      Unknown boolean format
  </code></pre>
  
  <p>I've seen some comments about using IGNOREHEADER in my statement but that isn't an option because the files I'm dealing with are in a single row json format. Ignoring the head would basically mean not reading thefile at all. I have other tables working like this and work fine, but don't have any bool columns in those tables. </p>