title: Redshift copy doesn't insert data into my table
body: <p>I have table SampleTable</p>
  
  <p>and run the following Redshift command through a SQL Client (JackDB)</p>
  
  <pre><code>copy SampleTable
  from 's3://bucket-name/backup/data.csv.gz'
  credentials 'aws_access_key_id=xxx;aws_secret_access_key=xxx'
  gzip
  csv;
  </code></pre>
  
  <p>the command does return</p>
  
  <blockquote>
    <p>Executed successfully  Updated 0 rows in 2.771 seconds.</p>
  </blockquote>
  
  <p>but no data are inserted into empty table SampleTable</p>
  
  <pre><code>select count(*)
  from SampleTabe
  </code></pre>
  
  <p>return 0</p>
  
  <p>there are 100MB data in data.csv.gz</p>