title: skip bad record in redshift data load
body: <p>I am trying to load data into AWS redshift using following command</p>
  
  <pre><code>copy venue from 's3://mybucket/venue'
  credentials 'aws_access_key_id=&lt;access-key-id&gt;;aws_secret_access_key=&lt;secret-access-key&gt;'
  delimiter '\t';
  </code></pre>
  
  <p>but data load is failing, when I checked Query section for that specific load I noticed it failed because of "Bad UTF8 hex sequence: a4 (error 3)"</p>
  
  <p>Is there a way to skip bad records in data load into redshift?</p>