Skip to content

How to Migrate from MongoDB to Snowflake

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

Source: MongoDB. Destination: Snowflake.

Sample config

yaml
skippr:
  workspace: mongodb_to_snowflake
pipelines:
  mongodb_to_snowflake:
    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:
    Snowflake:
      database: ANALYTICS
      schema: RAW
      warehouse: COMPUTE_WH
      role: ACCOUNTADMIN

Environment

bash
export SNOWFLAKE_ACCOUNT="MYORG-MYACCOUNT"
export SNOWFLAKE_USER="myuser"
export SNOWFLAKE_PRIVATE_KEY_PATH="/path/to/snowflake_key.p8"

Source connector: mongodb. Destination connector: snowflake.

See Quick start.