If you send some data to Redshift, it needs to be parsed by Redshift. You are sending a string formatted as id, username, sentiment, tweet or a JSON string {id: 'id', username:'twetterin_chief', sentiment: '0.12', tweet:'Hello world it's a beautiful day'}. You need to make sure that the Redshift configuration in Kinesis follows the format of your data. You do so in the Kinesis-Redshift configuration screen with the two following fields:
- The Redshift table columns
- The Redshift COPY options