Skip to content

How to Migrate from Amazon DynamoDB to Azure Synapse

Skippr is the easiest way to migrate from DynamoDB to Synapse and get fully cleansed and modeled data in one run command.

Source: DynamoDB. Destination: Synapse.

Sample config

yaml
skippr:
  workspace: dynamodb_to_synapse
pipelines:
  dynamodb_to_synapse:
    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:
    Synapse:
      schema: dbo

Environment

bash
export SYNAPSE_HOST="myworkspace.sql.azuresynapse.net"
export SYNAPSE_USER="sqladmin"
export SYNAPSE_PASSWORD="mypassword"
export SYNAPSE_DATABASE="analytics"
export AWS_ACCESS_KEY_ID="your-key"
export AWS_SECRET_ACCESS_KEY="your-secret"

Source connector: dynamodb. Destination connector: synapse.

See Quick start.