title: How should records be formatted for AWS Kinesis Firehose to Redshift?
body: <p>Consider the following:</p>
  
  <ul>
  <li>A table in Redshift called 'people' that has fields id, name and age</li>
  <li>A kinesis firehose stream called 'people' that is configured to write to the 'people' table and the value for 'Redshift table columns' is 'id,name,age'</li>
  </ul>
  
  <p>It's not clear how to format the 'Data' blob. Here's an example of what the code looks like with the data separated by tabs:</p>
  
  <pre><code>let AWS = require('aws-sdk');
  let firehose = new AWS.Firehose();
  let params = {
    DeliveryStreamName: 'people',
    // id,name,age
    Records: [{Data: '4ccf6d3a-acdf-11e5-ad54-28cfe91fa8f1\tBob\tSmith'}]
  };
  firehose.putRecordBatch(params, (err, result) =&gt; {
    console.log(err || result);
  });
  </code></pre>
  
  <p>Here are some of the docs I have checked:</p>
  
  <ul>
  <li><a href="http://docs.aws.amazon.com/firehose/latest/APIReference/API_PutRecordBatch.html" rel="nofollow">http://docs.aws.amazon.com/firehose/latest/APIReference/API_PutRecordBatch.html</a></li>
  <li><a href="http://docs.aws.amazon.com/firehose/latest/dev/writing-with-sdk.html" rel="nofollow">http://docs.aws.amazon.com/firehose/latest/dev/writing-with-sdk.html</a></li>
  <li><a href="http://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/Firehose.html#putRecordBatch-property" rel="nofollow">http://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/Firehose.html#putRecordBatch-property</a></li>
  </ul>