Loading data from DynamoDB into Amazon Redshift
- A copy operation from a DynamoDB table counts against that table’s read capacity.
- Before copying, first create Redshift table.
- Redshift COPY command
- Amazon Redshift table columns are case-insensitively matched to Amazon DynamoDB item attributes.
- Amazon Redshift table columns that do not match an attribute in the Amazon DynamoDB table are loaded as either NULL or empty
- Amazon DynamoDB attributes that do not match a column in the Amazon Redshift table are discarded
- Only Amazon DynamoDB attributes with scalar STRING and NUMBER data types are supported. The Amazon DynamoDB BINARY and SET data types are not supported. If a COPY command tries to load an attribute with an unsupported data type, the command will fail.