title: AWS Redshift - Copy data from s3 with wildcard
body: <p>I am trying to copy data from S3 bucket into Redshift using <code>copy</code> command. 
  When I pass the exact file name in copy command it works perfectly fine but when I use wildcard (<code>*</code>) in my from clause it throws an error - <strong>"The specified S3 prefix 'suiteX*' does not exist;"</strong></p>
  
  <p>All my files follow this naming convention - <code>SuiteX_Date_Hour.csv</code>  for example - <code>SuiteX-20150101-1.csv</code></p>
  
  <p>Here is my copy command that works :</p>
  
  <pre><code>copy mytable from 's3://mybucket/suiteX_20150101_1.csv'
  CREDENTIALS 'aws_access_key_id=XXXXX;aws_secret_access_key=XXXX'
  delimiter ',' REGION AS 'us-east-1';
  </code></pre>
  
  <p>Here is the copy command that does not work:</p>
  
  <pre><code>copy mytable from 's3://mybucket/suiteX*'
  CREDENTIALS 'aws_access_key_id=XXXXX;aws_secret_access_key=XXXX' 
  delimiter ',' REGION AS 'us-east-1';
  </code></pre>
  
  <p>Any idea how can make copy command to work with wildcard when I copy data from S3 ?</p>