Create a shell script to copy all data from a source DynamoDB table into a target DynamoDB table using the AWS CLI. Source and target tables are provisioned in different AWS accounts.
- Use named profiles called “source” and “target” to connect to the target and source account.
- Save scan results to a temporary directory
- Processing each item individually
Open Amazon Q Developer in the CLI via q chat. Copy-paste the prompt into your terminal. To improve the accuracy of the output, provide samples of how the data are structured inside your DynamoDB Tables.
Before running the script, make sure to create two named profiles for source and target accounts in your AWS CLI configuration.
Install Prompt
Add this prompt to your Amazon Q CLI prompt library:
1. Download to local prompt library:
mkdir -p .amazonq/cli-prompts && curl -o .amazonq/cli-prompts/copy-data-from-dynamodb-across-accounts.md https://promptz.dev/prompts/solutions/copy-data-from-dynamodb-across-accounts/2. Use with Q CLI:
q prompts use copy-data-from-dynamodb-across-accounts