title: Unable to Load Tab-delimited Txt File from S3 into Redshift
body: <p>At SQLWorkbenchJ, I am trying to load a text file that is 'tab' delimited from Amazon S3 into Redshift by using this command:</p>
  
  <pre><code>COPY table_property
  FROM 's3://...txt’
  CREDENTIALS 'aws_access_key_id=…;aws_secret_access_key=…’
  IGNOREHEADER 1
  DELIMITER '\t';
  </code></pre>
  
  <p>But it returns the following warning:</p>
  
  <pre><code>Warnings:
  Load into table 'table_property' completed, 0 record(s) loaded successfully.
  </code></pre>
  
  <p>I have checked various Stackoverflow sources and <a href="http://docs.aws.amazon.com/redshift/latest/dg/tutorial-loading-run-copy.html" rel="nofollow noreferrer">Tutorial: Loading Data from Amazon S3</a> but neither of the solutions works.</p>
  
  <p>My data from the text file looks like this:</p>
  
  <pre><code>BLDGSQFT    DESCRIPTION LANDVAL STRUCVAL    LOTAREA OWNER_PERCENTAGE
  12440   Apartment 15 Units or more      2013005 1342004 1716    100
  20247   Apartment 15 Units or more      8649930 5766620 7796.25 100
  101             
  1635    Live/Work Condominium                   977685  651790  0   100
  </code></pre>
  
  <p>Does anyone have the solution to this?</p>