title: Copying data from S3 to Redshift hangs
body: <p>I've been trying to load data into <code>Redshift</code> for the last couple of days with no success. I have provided the correct <code>IAM</code> role to the cluster, I have given access to <code>S3</code>, I am using the <code>COPY</code> command with either the <code>AWS</code> credentials or the <code>IAM</code> role and so far no success. What can be the reason for this? It has come to the point that I don't have many options left.</p>
  
  <p>So the code is pretty basic, nothing fancy there. See below:</p>
  
  <pre><code>copy test_schema.test from 's3://company.test/tmp/append.csv.gz' 
  iam_role 'arn:aws:iam::&lt;rolenumber&gt;/RedshiftCopyUnload'
  delimiter ',' gzip;
  </code></pre>
  
  <p>I didn't put any error messages because there are none. The code simply hangs and I have left it running for well over 40 minutes with no results. If I go into the Queries section in Redshift I dont see any abnormal. I am using Aginity and SQL Workbench to run the queries. </p>
  
  <p>I also tried to manually insert queries in Redshift and seems that works. COPY and UNLOAD do not work and even though I have created Roles with access to S3 and associated with the cluster I still get this problem.</p>
  
  <p>Thoughts?</p>
  
  <p>EDIT: Solution has been found. Basically it was a connectivity problem within our VPC. A VPC endpoint had to be created and associated with the subnet used by Redshift.</p>