Skip to content

How to Migrate from MongoDB to MotherDuck

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

Source: MongoDB. Destination: MotherDuck.

Sample config

yaml
skippr:
  workspace: mongodb_to_motherduck
pipelines:
  mongodb_to_motherduck:
    data_source: data_sources.source
    data_sink: data_sinks.warehouse
data_sources:
  source:
    Mongodb:
      connection_string: "mongodb://user:pass@host:27017"
      database: mydb
      collection: users
data_sinks:
  warehouse:
    Motherduck:
      motherduck_token: "${MOTHERDUCK_TOKEN}"
      database: my_database
      schema: main

Environment

bash
export MOTHERDUCK_TOKEN="eyJ..."

Source connector: mongodb. Destination connector: motherduck-warehouse.

See Quick start.