DynamoDb to Redshift

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.