title: Redshift COPY - No Errors, 0 Record(s) Loaded Successfully
body: <p>I'm attempting to COPY a CSV file to Redshift from an S3 bucket. When I execute the command, I don't get any error messages, however the load doesn't work.</p>
  
  <p>Command:</p>
  
  <pre><code>COPY temp FROM 's3://&lt;bucket-redacted&gt;/&lt;object-redacted&gt;.csv'
  CREDENTIALS 'aws_access_key_id=&lt;redacted&gt;;aws_secret_access_key=&lt;redacted&gt;'
  DELIMITER ',' IGNOREHEADER 1;
  </code></pre>
  
  <p>Response:</p>
  
  <pre><code>Load into table 'temp' completed, 0 record(s) loaded successfully.
  </code></pre>
  
  <p>I attempted to isolate the issue via the system tables, but there is no indication there are issues.</p>
  
  <p>Table Definition:</p>
  
  <pre><code>CREATE TABLE temp ("id" BIGINT);
  </code></pre>
  
  <p>CSV Data:</p>
  
  <pre><code>id
  123,
  </code></pre>