title: Copying data from S3 to AWS redshift using python and psycopg2
body: <p>I'm having issues executing the copy command to load data from S3 to Amazon's Redshift from python.<br>
  I have the following copy command:  </p>
  
  <pre><code>copy moves from 's3://&lt;my_bucket_name&gt;/moves_data/2013-03-24/18/moves'
  credentials 'aws_access_key_id=&lt;key_id&gt;;aws_secret_access_key=&lt;key_secret&gt;'
  removequotes
  delimiter ',';
  </code></pre>
  
  <p>When I execute this command using SQL Workbench/j everything works as expected, however when I try to execute this with python and psycopg2 the command pass OK but no data is loaded and no error is thrown.<br>
  tried the following two options (assume psycopg2 connection is OK because it is):</p>
  
  <pre><code>cursor.execute(copy_command)  
  cursor.copy_expert(copy_command, sys.stdout)
  </code></pre>
  
  <p>both pass with no warning yet data isn't loaded</p>
  
  <p>Ideas?</p>
  
  <p>Thanks</p>