Export and import DynamoDB data across environments

transport-dynamodb-data.sh

#!/bin/sh

SOURCE_TABLE=xxx-mydata-accp
TARGET_TABLE=xxx-mydata-prod
AWS_PROFILE=default
AWS_REGION=ap-southeast-2

# Step 1 - export and transform

aws --profile=$AWS_PROFILE \
    --region=$AWS_REGION \
    dynamodb scan \
    --table-name $SOURCE_TABLE \
    | jq '{"$TARGET_TABLE": [.Items[] | {PutRequest: {Item: .}}]}' > export.json

# Step 2 - import data

aws --profile=$AWS_PROFILE \
    --region=$AWS_REGION \
    dynamodb batch-write-item \
    --request-items export.json