title: Kinesis Firehose load csv data into Redshift
body: <p>I am using Kinesis firehose to process data into redshift and i am trying both Json and Csv formats.</p>
  
  <p>The Json format works fine for me and data is getting loaded into redshift table.</p>
  
  <p><strong>COPY COMMAND USED FOR JSON :</strong></p>
  
  <p>COPY products_json FROM 's3://foldername/' CREDENTIALS 'aws_iam_role=arn:aws:iam:::role/' MANIFEST <strong>json 'auto';</strong></p>
  
  <p><strong>CLI Command to put record :</strong></p>
  
  <p>aws firehose put-record --delivery-stream-name csvtoredshiftstreamingjson --record='Data="{\"productid\":1,\"productname\":\"phone\",\"productprice\":\"2.30\"}"'</p>
  
  <p>However when i use CSV, data is present in S3 but not loaded in redshift.</p>
  
  <p><strong>COPY COMMAND USED FOR CSV :</strong></p>
  
  <p>COPY products_csv FROM 's3://foldername/' CREDENTIALS 'aws_iam_role=arn:aws:iam:::role/' MANIFEST <strong>csv</strong>;</p>
  
  <p><strong>CLI Command to put CSV Record :</strong></p>
  
  <p>aws firehose put-record --delivery-stream-name csvtoredshiftstream --record='Data="1,Phone,2.30"'</p>
  
  <p>The records are getting processed to S3 but not loaded to redshift. The STL_LOAD_ERRORS table also does not have any records. </p>
  
  <p>Please do let me know if I am missing something.</p>
  
  <p>Thanks.</p>