How should records be formatted for AWS Kinesis Firehose to Redshift?


Consider the following:

  • A table in Redshift called ‘people’ that has fields id, name and age
  • 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’

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:

Here are some of the docs I have checked:


The answer is here:

Fields need to be pipe ‘|’ separated by default. Rows should be separated by new lines.

Updated corrected code:

Leave a Reply