title: S3 to Redshift input data format
body: <p>I'm trying to run a simple chain s3-pipeline-redshift, but I've got completely stucked with input data  format. Here's my file:</p>
  
  <p>1,Toyota Park,Bridgeview,IL<br>
  2,Columbus Crew Stadium,Columbus,OH<br>
  3,RFK Stadium,Washington,DC<br>
  4,CommunityAmerica Ballpark,Kansas City,KS<br>
  5,Gillette Stadium,Foxborough,MA<br>
  6,New York Giants Stadium,East Rutherford,NJ<br>
  7,BMO Field,Toronto,ON<br>
  8,The Home Depot Center,Carson,CA<br>
  9,Dick's Sporting Goods Park,Commerce City,CO<br>
  10,Pizza Hut Park,Frisco,TX<br></p>
  
  <p>and here's the table I'm using:</p>
  
  <pre><code>    create table venue_new(
      venueid smallint not null,
      venuename varchar(100) not null,
      venuecity varchar(30),
      venuestate char(2),
      venueseats integer not null default '1000');
  </code></pre>
  
  <p>When I use | as a delimiter, I'm getting error 1214 - Delimiter not found                 , when I use comma - same thing, when I converted file to utf-8, I'm getting "Invalid digit, Value '.', Pos 0, Type: Short'. 
  I ran out of ideas. What a heck is wrong with that thing? Can somebody please give me the example of the input file or tell what I'm doing wrong? Thanks in advance.
  P.S. I also found that sample files are available in bucket awssampledb, but I have no idea how to get them.</p>