How to Migrate from Amazon DynamoDB to MotherDuck
Skippr is the easiest way to migrate from DynamoDB to MotherDuck and get fully cleansed and modeled data in one run command.
Source: DynamoDB. Destination: MotherDuck.
Sample config
yaml
skippr:
workspace: dynamodb_to_motherduck
pipelines:
dynamodb_to_motherduck:
data_source: data_sources.source
data_sink: data_sinks.warehouse
data_sources:
source:
Dynamodb:
table_name: my-table
region: us-east-1
data_sinks:
warehouse:
Motherduck:
motherduck_token: "${MOTHERDUCK_TOKEN}"
database: my_database
schema: mainEnvironment
bash
export MOTHERDUCK_TOKEN="eyJ..."
export AWS_ACCESS_KEY_ID="your-key"
export AWS_SECRET_ACCESS_KEY="your-secret"Source connector: dynamodb. Destination connector: motherduck-warehouse.
See Quick start.
