We need to do is to read the data from the user log dynamodb, again from dynamodb import data to the redshift do statement analysis,,
Question:
Because aws built-in SQL commands can use the whole table data imported into the redshift, however, the import dynamodb table after new data in the table if synchronization to the redshift?

CodePudding user response:

May I have your problem solved?

CodePudding user response:

Real-time synchronization of new data to the Redshift:
Enable DynamoDB stream, and then use the AWS Lambda and Firehose will import the new data to the Redshift, each time to DynamoDB do add and remove operations returned to have a new Event into the stream, then you can according to the Lambda updates to the Redshift,