Export to S3 in DynamoDB - Mini Project: Build & Apply

Export DynamoDB Table to S3

📖 Scenario: You work in a company that stores customer orders in a DynamoDB table. Your manager wants you to export the entire orders table to an Amazon S3 bucket for backup and analysis.This project will guide you step-by-step to create the export setup and configuration.

🎯 Goal: Build a DynamoDB export configuration that exports the Orders table data to an S3 bucket named company-backups in the us-west-2 region.

📋 What You'll Learn

Create a DynamoDB table named Orders with specified attributes

Define an S3 bucket name and region for export

Write the export command referencing the table and S3 bucket

Complete the export configuration with export format and role ARN

💡 Why This Matters

🌍 Real World

Exporting DynamoDB tables to S3 is common for backups, data analysis, and migration tasks in real companies.

💼 Career

Knowing how to export DynamoDB data to S3 is useful for cloud engineers, database administrators, and data analysts working with AWS.

1

Create the DynamoDB table structure

Create a DynamoDB table named Orders with a partition key called OrderId of type S (string). Use the AWS CLI command aws dynamodb create-table with the exact parameters shown.

DynamoDB

# Your code here

Need a hint?

Use the AWS CLI create-table command with the exact table name and key schema.

2

Set the S3 bucket and region for export

Create two variables: bucket_name set to company-backups and region set to us-west-2. These will be used to configure the export destination.

DynamoDB

aws dynamodb create-table --table-name Orders --attribute-definitions AttributeName=OrderId,AttributeType=S --key-schema AttributeName=OrderId,KeyType=HASH --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5
# Define the S3 bucket name and region
# Your code here

Need a hint?

Assign the exact string values to bucket_name and region variables.

3

Write the export command referencing the table and S3 bucket

Write the AWS CLI command to export the DynamoDB table Orders to the S3 bucket stored in bucket_name in the region. Use the command aws dynamodb export-table-to-point-in-time with parameters --table-arn, --s3-bucket, and --region. Use the exact variable names bucket_name and region in the command.

DynamoDB

aws dynamodb create-table --table-name Orders --attribute-definitions AttributeName=OrderId,AttributeType=S --key-schema AttributeName=OrderId,KeyType=HASH --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5
bucket_name=company-backups
region=us-west-2
# Write the export command below
# Your code here

Need a hint?

Use the full table ARN with the exact region and account ID 123456789012. Use the variables $bucket_name and $region in the command.

4

Complete the export configuration with format and role ARN

Add the parameters --export-format DYNAMODB_JSON and --s3-prefix exports/orders to specify the export format and folder. Also add --role-arn arn:aws:iam::123456789012:role/DynamoDBExportRole to specify the IAM role for export permissions. Use the exact strings shown.

DynamoDB

aws dynamodb create-table --table-name Orders --attribute-definitions AttributeName=OrderId,AttributeType=S --key-schema AttributeName=OrderId,KeyType=HASH --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5
bucket_name=company-backups
region=us-west-2
aws dynamodb export-table-to-point-in-time --table-arn arn:aws:dynamodb:us-west-2:123456789012:table/Orders --s3-bucket $bucket_name --region $region
# Add export format, s3 prefix, and role ARN below
# Your code here

Need a hint?

Include all three parameters exactly as shown to complete the export command.