Complex DynamoDB data into Redshift made easy

How to ingest DynamoDB Map / List types into Redshift

Photo by Rodion Kutsaev on Unsplash

It’s fairly common practice to store JSON payloads in DynamoDB. You have a few data storage options when doing this: storing the whole payload as a string or storing it within a DynamoDB Map.

Each have their pros and cons which I’ll discuss below and one approach in…