Skip to content

How to Migrate from MotherDuck to Databricks

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

Source: MotherDuck. Destination: Databricks.

Sample config

yaml
skippr:
  workspace: motherduck_to_databricks
pipelines:
  motherduck_to_databricks:
    data_source: data_sources.source
    data_sink: data_sinks.warehouse
data_sources:
  source:
    Motherduck:
      motherduck_token: "${MOTHERDUCK_TOKEN}"
      database: my_db
data_sinks:
  warehouse:
    Databricks:
      workspace_url: "${DATABRICKS_HOST}"
      token: "${DATABRICKS_TOKEN}"
      warehouse_id: "${DATABRICKS_WAREHOUSE_ID}"
      catalog: main
      schema: default

Environment

bash
export DATABRICKS_HOST="https://myworkspace.cloud.databricks.com"
export DATABRICKS_TOKEN="dapi..."
export DATABRICKS_WAREHOUSE_ID="abc123def456"
export MOTHERDUCK_TOKEN="eyJ..."

Source connector: motherduck-source. Destination connector: databricks.

See Quick start.