amazon-web-servicesamazon-dynamodbamazon-redshiftamazon-kinesis-firehoseamazon-redshift-spectrum

Sync dynamodb into redshift table with kenisis firehose


I've found a tutorial for how to get item level changes into s3 from dynambo via kinsis firehose here but how do I get these into a redshift table? If an item is updated, it will create a new record for it and post to s3, so is there a tutorial or guidance on how to take these item level changes and read them into a table?


Solution

  • Kinesis Firehose has multiple destinations that you can choose from. S3 is only one of them, and Redshift is another.

    You can use the following configuration to set up Redshift as the destination.