Skip to content

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: main

Environment

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.