Copying JSON data from dynamoDB to redshift

3
votes

I wonder if it's possible to copy data from dynamoDB to redshift if my dynamoDB data contains JSON format values. If yes, how is it going to happen?

1
jsonamazon-dynamodbamazon-redshift

1 Answers

1
votes

You can upload values from DynamoDB to s3 then you can you copy commands to load data back to redshift.

The redshift supports JSON structure to be copied into DB . Refer link : http://docs.aws.amazon.com/redshift/latest/dg/copy-usage_notes-copy-from-json.html